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.

Since no one has posted this yet and the day approaches the end (UTC), I decided to post this...

How would you all feel about a virtual film festival?

We nominate candidate films, documentaries or shorts, focusing on things ​rarely watched, but that might provoke an interesting discussion.

We watch candidate films over maybe a three week period, watching maybe 3 times as many films as we nominate.

Then discussion ensues.

Talk about anything you have "automated" in your life. No restrictions on the tools or things to automate. You have a simple "silence your phone at work" thing? Great job! Do you have a complex thing with hundreds of lines of custom code? Wonderful! All are welcome!

I myself have automated a bit of stuff, and am constantly looking for more (that's why this thread exists):

Home:

• My room will turn on the lights when it detects the brightness inside is going down, but will slowly do it relative to the current brightness so it doesn't suddenly turn on at once. (Tries to keep a certain brightness at certain times)
• I can send "loff", "lon" or, "lauto" through XMPP to turn my lights off, on, or toggle the automatic mode mentioned above from anywhere. I am blocking internet connections from my smart light hub so I had to re-implement that manually

Computer:

• Copying any YouTube links (or Invidious links, which get translated into YouTube) will automatically prompt me about opening them under MPV

Phone:

This is where I do the bulk of my automation, as Tasker is a very convenient way to automate stuff.

• Toggle full brightness and/or auto rotation on specific apps (Gallery, NewPipe, etc.)
• A couple of Android "Share" targets for
  • Uploading dumb images to my webserver
  • Adding links to Miniflux (abusing it's bookmarklet functionality)
  • youtube-dl through Termux
• And some (mostly gimmicky) text-to-speech notifications for calls and XMPP messages

Planned:

• Miniflux notifier over XMPP. My last attempt failed because Node-RED apparently doesn't reconnect over to XMPP when its connection drops :(

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!

I need to read some fiction children books about death (for research) -- any age group preferably for young children.

Stories both realistic and fantasy/fantastical that doesn't gloss over the suffering and pain children can experience, possibly with dark overtones.

Stories featuring Death as a character would be great too.

Thanks!

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!