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?

I recently got my significant other into Eurotruck Simulator 2 and was given the go-ahead to purchase a VR headset so that we can better experience the various sim games out there. Unfortunately, the complete Valve Index package is back-ordered about 8 weeks so it will be a while before I can take the plunge and buy one.

Was just curious though if anyone here also has a VR headset and what their experience has been with it. I had a 1st generation Oculus Rift a long time ago but ended up selling it since I felt the software wasn't there (2016) and I could really only play the seated experiences with a 360 controller so I felt I was behind the curve even on my 1st purchase.

Some prompts to help spur discussion, but feel free to share what you would like to share:

• How often do you play on your headset?
• What games/experiences would you recommend?
• What games/experiences do you not recommend?
• What headset do you own/have you tried any others?
• Are there any accessories or peripherals that are worth checking out?

What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started a new diet or have a new recipe you want to share? Anything else health and wellness related?

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.

You could look up, say, CMSes, get some basic info about each one (to make useful decision), and learn who its active committers were. The site closed, I know. Do you remember its name? Or people who were part of it?

I asked someone to write an article for me about "review sites for open source" -- think Yelp for Software -- and neither of us can remember its name. But if you have others that you think should be included (for positive or negative reasons), please let me know.

What have you been listening to this week? You don't need to do a 6000 word review if you don't want to, but please write something! If you've just picked up some music, please update on that as well, we'd love to see your hauls :)

Feel free to give recs or discuss anything about each others' listening habits.

You can make a chart if you use last.fm:

http://www.tapmusic.net/lastfm/

Remember that linking directly to your image will update with your future listening, make sure to reupload to somewhere like imgur if you'd like it to remain what you have at the time of posting.

I'm building a playlist with that classic exercise montage aesthetic. Right now it's a bunch of new retro wave, montage tracks from Rocky, Top Gun, Rad, Karate Kid, etc.

Temporary playlist

If you have any suggestions for tracks that maintain this aesthetic, it'd be appreciated.

TL;DR: I did not know each individual group had wikis and I find them pretty great (the LGBT and tech ones in particular). Do they get updated regularly, are they searchable via the site-wide search, and who can contribute to them exactly?

I was looking through the "note-taking" and "productivity" tags for recommendations on a new note-taking app when I came across the extension resources wiki article in "Tech". It hasn't been updated recently but it made me realize one of the reasons why I find places like reddit useful is that the "Pinned FAQs", "Beginner Guides to <Hobby>", and "Megaposts" on reddit are an excellent source of (for lack of a better term) "peer-reviewed" recommendations and are often the catalyst for fun discussions.

I have, through my time here on tildes, discovered so many excellent recommendations even by just using the search bar and browsing threads - to the point that if say, a reddit and tildes post give me conflicting recommendations, I would trust the tildes post 9 out of 10 times. The climate of posts here are less inflammatory and the discussion on pros/cons are more calm, friendly, and thought through. I admit they have impacted my views on a bunch of things (not least of which is trying firefox as my main browser).

Are resource dumps like that something that the community here find viable in general? Are there plans for updating their implementation to be more easily accessible or is it too far removed from the discussion-based fluidity of the site? I understand that there are other places online to find information, but rarely do I find it at this level of transparency of bias and (on average) free of any bloat.

I guess I'll end this little thought stream with a thank you for all the people who post here and a curiosity for the future discussions to come. I've lurked a lot and learned a lot.