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?

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 week. Did you accomplish any goals? Suffer a failure? Do nothing at all? Tell us about it!

I say that after throwing some caution to air because I understand that every new thing has some initial resistance or pushback due to the "past comfort zone" effect.

But having said that, I feel the aesthetics of the old site was much better than the new one. But then again, I'm from the old-school world who also prefers old reddit to the new one in browsing experience, so my opinion could be biased! But even considering the modern web design, don't you think the black icons on the top right have a somewhat odd look? And the "21 languages" feels a bit verbose, the I10N icon already conveys what that dropdown is about? And finally, that scrollable sidebar on the left looks a tad ugly?

I just hope this is just a beta stage or something of Wikipedia's new version and a better one will evolve soon! But that's just one humble unpopular opinion, me thinks!

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?

Inspired by this post by @kfwyre.

For me, there's many; I don't want to influence responses but I will shout out the monthly mental health threads. Those really got me to (over)share feelings and find some reason. I got through dark times thanks to you all, Tildoes.

For me, as much as I didn’t care for the film, This is a Life from EEAAO getting into original song would make me incredibly happy. It’s such a good song and indie songs like it rarely get nominated.

Another one would be Glass Onion getting into Supporting Actress and Costumes.

As I recall, about 2-3 years ago I had experimented with what is called the npm install xyz through some tutorials, etc. The objective was to improve my tooling or toolchain at least with things like css/js minification, etc. along with Bootstrap customization. The idea was to then move on to other newer learnings like react, etc.

But I was soon disgruntled by the whole process! Neither bootstrap turned out to be an easy horse to tame, and NPM was like this astronomical universe of packages that keep on downloading into your folders! I soon lost taste of the whole thing and kept using my tried and tested stack of PHP scripts and using stock Bootstrap through CDNs.

But today, I want to give it another shot. Has NPM improved than earlier days? What is the best way to go about building a toolchain using it? Are there any useful guides that make the whole process easier to digest?

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!