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?

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 currently dual-boot Arch and Windows and just use the Windows EFI partition in Arch as well, however I only have about 13 MB of space left on it.

I’d like to try installing Gentoo on an extra SSD I have with nothing on it, but don’t really want to have a second EFI partition if I can avoid it.

So my question is, can I shrink the Windows main partition towards the right and expand the the Windows EFI partition into the newly freed space?

I'm talking about silly harmless stuff like "I believed in Santa Claus till I was 13", and not deep existential stuff like "It took me till adulthood to realize that my parents were doing their best despite their their failings".

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.

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!

I'm an on-again off-again smoker, currently (the past 4-5 months) on-again. Been meaning to requit, but it's been much harder for me this time.

Here's the crux. Two of my roommates just tested positive (for Covid). Not guaranteed, but it's a good bet that, within another 2-3 days, all 5 of us will be symptomatic.

Am I better off quitting right now, or will that just put added stress on my lungs during the coming illness, and I should wait until after I recover (always assuming I survive it, of course)?

ETA: Y'all are shooting holes in my, apparently, flimsy justifications to keep smoking. Just switched to vaping now.

Thanks everyone.