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.

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!

Hi everyone!

I've been using Vox for about a year now to listen to music and while there are some good qualities to it, I'm honestly fed up with the lack of volume normalisation and having to constantly adjust my volume manually (There's heaps years old of threads on their forums requesting or complaining about this). So here I am looking for a replacement and was wondering if anyone has a setup that I could copy. Here are the requirements that I have:

• I can stream my own music library of high quality music (FLAC format).
• It provides volume normalisation.
• I can set my whole library to shuffle.
• Native macOS client.

I've been doing some looking around and so far the most likely solution will be for me to set up a Gonic server at home and use Strawberry Music Player on my laptop. A close second contender was Youtube music but they don't provide a native client and I currently use a combination of keyboard shortcuts and applescripts to manage playback (I found media keys insufficient but that's a topic for another post).

I am currently paying a subscription fee for Vox so I don't mind if I have to pay for the new player, I'd prefer a service like that for ease of use rather than rolling out my own.

Update
For posterity I'm posting what I ended up doing. I tried Roon and while it looked and felt amazing, the ability for streaming out of home is very limited, it's intended to stream within a local network. It appears you can only do remote streaming to a mobile device and requires a custom port to be forwarded, I wanted to put this behind a reverse proxy but was not able to do that (Seems it's not supported).
I did not try Plexamp, after all the work I did to get Gonic set up properly it felt like I was doing too much work myself to pay for a solution. Ideally I wanted something that would "just work" even if it wasn't free but no solution did that. If I had access to a free trial I would have probably tested it as well.
I already had Gonic working within my home network going into this but setup of it is still trivial. The bulk of the work came in setting a dynamic DNS set up, and a reverse proxy (NPM) inside my network to provide HTTPS support with Letsencrypt certificates for Gonic (It's only HTTP). I spend too much time trying to have a secure setup (Crowdsec + Cloudflare) but after ditching that, I'm still happy with it and looking at logs it does not appear there's any significant risk to my network (I'm also using a geoip block to outright block requests from some countries).
As far as clients go, I settled with Strawberry. Tried the following:

• Sonixd: It had limited hotkey functionality and doesn't seem to be actively developed anymore.
• Submariner: Did not work.
• Clementine: Current version crashes on launch, rc version complaints about wrong credentials when connecting to the server.

Picture: EEAAO

Director: Steven Spielberg - The Fabelmans

Original Screenplay: The Banshees of Inisherin

Adapted Screenplay: Women Talking

Lead Actress: (TIE) Cate Blanchett - Tar and Michelle Yeoh - EEAAO

Lead Actor: Colin Farrell - The Banshees of Inisherin

Supporting Actress: Angela Bassett - Black Panther: Wakanda Forever

Supporting Actor: Ke Huy Quan - EEAAO

Ensemble: The Fabelmans

Young Actor: Gabrielle Labelle - The Fabelmans

Comedy: EEAAO

Animated: Guillermo Del Toro’s Pinocchio

International Film: RRR

Original Song: Naatu Naatu - RRR

Original Score: Babylon

Film Editing: EEAAO

Costumes: Babylon

Production Design: Babylon

Hair and make-up: The Whale

Cinematography: Top Gun: Maverick

I happen to host my blog https://prahladyeri.github.io/blog statically, built using Pelican and served on Github Pages. Plebs like us can't afford a backend server infrastructure, so we must rely on external services like Disqus for comment hosting.

So far, Disqus was the only fellow in town who allowed us to host comments on a free plan. Though there were some issues (bloat, adware, etc.), people seemed to be generally happy with it so far.

But now, a new fellow named giscus commenting system has entered the town, it's basically powered by github. Since I already host my blog on github pages, this should be a natural choice for me, right? Many bloggers seem to be migrating to this new system and I might too soon. The downsides however are as follows:

1. It won't allow me to export existing comments from the old disqus system. Understandable to an extent as those exact author usernames may not be on the Github platform?
2. Disqus interface seems to have improved all of a sudden in last few days! There no longer seem to be any ad and even the comment interface seems to be less heavy or cluttered now. It might sound a bit conspiratorial in nature but could this be the result of rising competition in the form of Giscus!

I'm a lazy status-quoist by nature and might well end up retaining disqus if they don't deviate too much from where they are now. But I'll keep an eye out on Giscus too and its progress. What do you guys suggest?

Starting on Thursday night, Twitter cut off API access for some of the biggest third party clients.

From The Verge:

It’s hard to tell whether the third-party client outage is due to the API. Attempting certain calls from my individual Twitter developer account seemed to work, while Twitter’s own API explorer tool is currently broken.

It definitely seems like it is on purpose. For it to last this long without any update definitely makes it feel like it was done on purpose. Many developers' apps have started showing up as "suspended". In looking at my own account, I can see that both Tweetbot and Fenix are gone from my list of connected apps.

The Icon Factory (makers of Twitteriffic) have a blog post about it as well.

The complete silence from Twitter is completely baffling. Burning more than a decade of working with developers overnight seems incredibly stupid. As Paul Hadad, one of the makers of Tweetbot said:

Even during the darkest Twitter 1.0 days they were pretty open about what they were doing. I remember getting a call prior to the 4 quadrants token limit where they explained what was going to happen and answered questions. I wasn't happy but at least felt there was respect.