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?

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.

I suspect many don’t write anything down and do this largely by intuition/experience but I want to tease out some ideas.

when it comes to describing and designing a system from a blank piece of paper, what are the parameters you think of?

I’m thinking napkin sketch level of software design.

So things like:
Number of users, are they concurrent users, what load dimensions there are (disk IO, network IO etc.), target platform (everything is a web app these days), how do you design/visualise the data model?

Any decisions or constraints that impact what and how you build a proof of concept / MVP? How do you document this? How do you test it against the finished software?

Sorry Tabletiddles, couple of days late with the thread as I've been busy on the bank holiday weekend here in UK.

What boardgames have you all been playing this week? Please share your experiences,.no matter what you've been playing.

For context, this was neither in the US nor Europe. This is not my first language and some terms are direct translations since I am not aware of actual usage.

I'm coming from an intense experience: my first son is born. In the days before that, I cared for my pregnant wife during the passing of her mother, who spent 3 months in the hospital fighting multiple conditions, chiefly neurological.

Two days after the burial, we went to the hospital for several exams. My wife was diagnosed with pre-eclampsia, a potentially dangerous pregnancy complication characterized by high blood pressure.

We spent almost a week in the hospital. My wife did not want a c-section, so our doctor employed multiple methods to induce labor over the course of several days.

There are no men in the maternity ward. Men do not sweep floors, do not take calls, or take any position of care.

I did not see any men in the hallway, although I assumed there were some hidden in the bedrooms.

When the nurses entered the room, they did not look at me. I was not a father, but rather a "companion" whatever you would use in English for someone who is just kind of there. When they had instructions pertaining to the care of my wife and son, they never addressed me. They only addressed me in matters lacking importance, like "Get me a towel", or "Is there any cotton left?".

The tone and body language were of contempt and distrust.

When my wife was soon to go into labor, I decided to go to the bathroom, since I expected to be locked in a room for many hours. When I left the bathroom (which was in the same room where she was), my wife was not there. She was gone. I looked for information and realized she was in the delivery room.

When I was in the bathroom, someone asked me to get something for the doula (a woman), but didn't tell me why. I did. You see, they had time to request me to get something for the doula, but couldn't use the same time to warn me that my wife was being taken to another floor.

That was incredibly traumatizing.

At every step, the message was very clear: "You are not welcome here". "You are not qualified to care for your wife and son". "You are man, and, therefore, a menace to this environment".

Well, fuck them. I was there for my wife since day one. In every contraction, every second she needed me, I was there.

I was the first person to touch my son when he left the womb.

We had to revolt to leave that place as soon as we could. Our personal pediatrician had to intervene because apparently, the maternity ward didn't really trust my wife either -- they just pretended. The kid was slightly underweight. I was convinced that the long stay at the hospital was the main factor impacting breastfeeding. My wife needed to mourn the loss of her mother and required some sense of normality and routine (we are so incredibly happy in our day-to-day, I was confident she would improve!). Turns out that I (and our doctor) were right. We're home now, and the kid's gaining weight again.

At every step of this process, I was invited not to care. "Get out, father, you are not needed here." "That is not a job for men, let the women do it for you".

Earlier today, a neighbor came asking "Are the girls helping you out?". I gotta be honest, I snapped. "No", I said. "This kid has a father". "Oh, but the feminine touch is special!". "It is not", I answered.

Well, fuck them, because I do care for my son, and I will continue to do so. I fully acknowledge and respect the special connection a mother has with their kids. I cannot bear a child, and I lack the ability to produce milk. Other than that, there are no tasks my wife can do that I cannot do as well.

I am not an angry person. Thinking about this makes me very angry and I hate that feeling. I feel a long-lasting trauma is forming. I'm pretty shook-up.

I love my son, I guess that ultimately that is all that matters.

I'm just glad I'm now home, and that I am no longer the only man in a place that considered me a foreign body, trying to eject me at every chance.

I am a reddit refugee and I was drawn to this network by its mission, its decisive rebuff of chasing capital at all costs, and the overall vibe.

I lurked for a while before I was invited to join, but shortly after joining I noticed something. While a good discussion from opposing viewpoints can help everyone broaden their horizons a bit, it felt like white supremacists were testing the waters. While I can't directly cite any threads, there were a couple instances where I felt one side was seeing just how close they could get without being obvious. But it felt like some of the subtler dog whistles were there.

It felt very similar to how QAnon got a lot of people with the disinformative statistic about child abductions. After all, who's going to be on the other side "child abductions are bad?"

After seeing a few threads and getting the same vibe, I stopped visiting the site for the last couple months. Life getting pretty busy also helped.

I haven't been back long enough to determine for myself whether I'm in a "Nazi bar" or not. I would be happy to admit that it was all in my head. But it is a major concern for any up-and-coming social network. And that's an opposing viewpoint no one needs to take seriously. Was it in my head? Was I reading too much into things? Did all the nazis just go to X? More generally, how has moderation been with the influx of new users? The same, but more? A couple extra reminders doing the trick? Uptick in bans? Is this information already somewhere and I'm a bad user for not having seen it?

I've recently been watching the old episodes of Patriot act, and it occured to me that since we cut the cord with regular cable I have no clue if there is a contemporary analog for that show. Basically, a left leaning, comedic news and current events show that tends toward actually doing it's homework on the topics covered would be awesome.