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.

Riff.cc is a private tracker torrent site that is completely focused on works distributed with creative commons, public domain, gpl or other free culture licenses.
It has some plans to allow tipping creators and seeders using digital currency.

You can use this invite to signup (I believe there is a limit of 90 people who can use it).

https://u.riff.cc/register/fb4dc3bf-af81-43f4-94fb-5afc6b24b159

I was wondering if anyone organizes their life in checklists, and if so, how people go about doing it. I'm interested in starting to try this, but haven't yet taken the time to do so and I'm curious what works for people.
My idea of this came off of CGP Grey's usage, which he often talked about in his podcast with Brady Haran, Hello Internet, but I'm a Windows/Android kind of person and would probably use a program such as Notion, which I'm using for notetaking and other tasks already, to do so.

What I'm mainly wondering is how you might structure checklists to a day of the week, and what to include/not include on there. What works for you if you've tried this before, and would you recommend it?

This thread is posted weekly - please try to post all relevant US political content in here, such as news, updates, opinion articles, etc. Extremely significant events may warrant a separate topic, but almost all should be posted in here.

This is an inherently political thread; please try to avoid antagonistic arguments and bickering matches. Comment threads that devolve into unproductive arguments may be removed so that the overall topic is able to continue.

As part of a weekly series, these topics are a place for users to casually discuss the things they did — or didn't do — during their weekend. Did you make any plans? Take a trip? Do nothing at all? Tell us about it!

This thread is posted weekly, and is intended as a place for more-casual discussion of the coronavirus and questions/updates that may not warrant their own dedicated topics. Tell us about what the situation is like where you live!

The title question is more of an umbrella one, and I want to state from the get go that I am asking these questions non-judgmentally. I want this to be a space where people can feel safe to respond honestly.

I’ll also qualify that I’m not asking these impartially, as part of my reason for making this thread stems from some identified frictions in my own life that I’ve been mulling over. I don’t want to prime anyone’s answers, however, so instead I’ll just lay out what I’m interested in hearing about:

• Do you feel that you need to hide your gaming from others?
• Are you honest with others about the amount of time you spend playing games, the types of games you play, or the importance you ascribe to them?
• Do you feel that people judge your gaming habits or status as a gamer negatively?
• Do you identify yourself as being a part of a broader gaming culture?

I know that "over" is a nebulous concept as it relates to COVID-19, but I'm using that more as a way of prompting long-term thinking rather than identifying any actual endpoint to the pandemic.

The question could also be phrased: what changes did COVID-19 bring about that you hope will stick around in the years to come?

I find myself at a point in my life where I have the time, energy, and money to adopt a dog. Growing up I never had a dog - my parents only had cats. I don't totally know what I'm getting into so I'm looking for some advice.

I would like to have a moderately active dog, as I live a moderately active life. However, many donation sites list even just moderately active dogs as needing a yard. I live in a fairly spacious 1 bedroom apartment that's in a small complex (5 units) on the ground floor. Does this severely restrict the kind of dogs I should adopt? I know a hyper-active breed wouldn't be happy here. But should I consider myself limited to small, lower needs dogs?

Edit:

Probably important bit of information, I don't plan to get a puppy.