Hey all, I'm looking to expand my stable of long-form, "crunchy" reading material. I'll recommend three. ( I think I found all these through tildes.)

Casey Handmer's Blog
A blog about the new space industry with a specific focus on SpaceX and the industrialization of Mars.

Construction Physics
A newsletter that analyses trends and data in the construction industry with a focus on modular construction.

ACOUP
Essays about medieval and ancient history as well as their interaction with popular culture, with a focus on methods of production and common people in history.

Another type of content I've really enjoyed is detailed breakdowns of zero-day vulnerabilities and large software catastrophies.

Sorry if this is dumb, I just woke up and had this idea randomly. What would happen if the site had a built-in mechanic for correction spelling mistakes. It could be opt-in (or opt-out?) if you don't want anyone to bother you. This would allow other people that notice them to ping a comment author privately with perhaps a short message explanation.

Not everyone has English as their first language which is why I think it could be valuable. If the feature is not built into the site, correcting someone would be seen as a negative experience (I think) both in public or private messages.

It would be up to the comment author to edit their comment. (Or perhaps a way to accept the changes would be nice?)

Thoughts? Is this a thing anywhere else?

Edit: I put feature request in the title, but this is more of a discussion of the idea in general. I don't expect this to become a thing, but I feel like it's interesting to think about.

What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.

If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

Hi all, I'm becoming almost certain that my apartment is dealing with a minor bedbug infestation. Do any of you have experience dealing with the things? Specifically, my unit shares a building with about 20 others, so has anybody dealt with infestations in a similar situation? I'm wondering if a heat treatment is even possible or realistic.

Occasionally people here get into discussions about social relationships, namely dating, and what quickly comes up is how both of those seem to be less common and harder to 'get'. This more frequently happens in overtly dating and relationship subreddits and similar dedicated spaces, albeit, of course, this also pops up in more general communities, alongside any community where social relationships are an important topic, like communities about social ideologies like feminism or the manosphere or about genders because heterosexuality.

One thing I often find is missing is some historical context. A lot of talk about loneliness and lack of platonic or romantic relationships is basically limited to the recent past, if it even talks about the past at all. It seems like it would be helpful to look at what relationships and dating were like 10, 20, 30 years ago when it comes to talking about the problems or just general state of both today. So do you know of good sources of information concerning relationships in the past? If so, then why do you think they don't pop up in discussions about dating?

Almost all of my anime suggestions come from 2 friends. I went outside the circle for first time and got lucky with OddTaxi Episode. Apart from that I've pretty much only watched the big names like Death Note, One Punch Man, AoT, FMA and on other end Daily Lives of Highschool boys and Saiki K.

I realize OddTaxi was very much unusual for Anime, but I'd like to continue the trend. Anything fresh, and not from usual anime fold will be nice, so recommendations welcome!

Have you watched any TV shows recently you want to discuss? Any shows you want to recommend or are hyped about? Feel free to discuss anything here.

Please just try to provide fair warning of spoilers if you can.

So this is a very simple question. There's a free talk thread for everyone to talk about the TV shows they have watched in the preceding week. Every once in a while we use that thread to talk about movies (I did that just now. My justification is that I watched the movies on my television), but the thread asks specifically for TV shows so it feels kinda weird. So maybe we should have a recurring thread for movies? If not, I'd suggest changing the TV thread to make it explicitly welcoming to discussions about movies (in that case, maybe it would be ideal to make the thread appear both in ~tv and in ~movies? I don't think that is technically possible right now, but I leave the suggestion).

General Programming Q&A thread! Ask any questions about programming, answer the questions of other users, or post suggestions for future threads.

Don't forget to format your code using the triple backticks or tildes:

Here is my schema:

```sql
CREATE TABLE article_to_warehouse (
  article_id   INTEGER
, warehouse_id INTEGER
)
;
```

How do I add a `UNIQUE` constraint?