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.

It might sound silly to most, but I have had one for years now.

I started to really listen to music on my own volition in the early 2010s when I was in my early 10s, and I was really big into EDM at the time (big room house, brostep, electro house, progressive house, etc).

At some point in 2014 I wanted to expand my tastes so I ended up on rateyourmusic.com which is the kinda place you always end up on at some point if you go down this path the way I see it, and at first I just checked the overall charts and shrugged since it wasn't my kind of music at all (The Beatles, The Beach Boys, Miles Davis, Pink Floyd, The Rolling Stones, Radiohead, etc), but at some point it started bothering me; "why is all that crappy old music so highly regarded?" and I started giving the stuff a try. Didn't like it at all, but I somehow starting feeling compelled to try and understand/appreciate it.

Eventually, I fell down a sort of rabbit hole when I started reading discussions on how some music is "objectively better" than others and I completely believed it. Pushed around by the extremely harsh disdain towards the EDM I loved and godly praise of the type of thing I just mentioned, I just kinda felt like I was supposed to move on and basically listened to a lot of stuff like that.

Another while later I eventually realized that the whole "objectively good/bad" thing is one ugly sack of false shit, but I've been really burned out since then, and now I don't even really feel the music I used to like. Problem is, at this point the act of crawling through the charts looking for new music, constantly listening to new stuff, thinking about genres, etc, is so deeply ingrained in my behavior that I can't seem to stop. I have music on at nearly all times, and I force myself to listen to everything in full despite not feeling it at all.

Something that's also gotten me is the whole repeated listening thing, I've always really loved the idea of being able to enjoy something you initially didn't care for or were lukewarm towards by simply repeatedly listening to it. That also caused me to disregard my own impressions and force myself to repeatedly listen to almost everything. I'm mostly out of that phase now, but I sometimes still find myself digging through random stuff I've given low ratings and listening to it again purely to see if I suddenly like it, but it has literally never even worked once. I also think this has been a contributor to me being burned out on music.

At this point I kinda feel like I'll never truly enjoy music again like I used to and it's really sad. Sometimes it does return a little, but if have to explain it with a rating, I can't say I've ever really felt anything above a 7/10 again, most of the time it's between a 3/10 and 6/10. I totally realize I just need to take a break, but I simply can't seem to stop (through a lot of effort I have actually managed to take a full break last month, but I immediately relapsed when I resumed this month, and even without that it doesn't seem like it helped all that much). What a lot of people have with things like gaming and food, I basically have with music.

Does anyone else have anything like this?

We're lucky when we share mutual interests with friends, but often there's that category of things for which there isn't much overlap. Though it speaks to us, we're seemingly alone in appreciating it, yet long for someone to connect with it over.

What's that thing for you?

I have some music links I was thinking of posting. However, I didn't want to flood ~music with 10 new links at once. It can make a category look like it has really homogenous content to newcomers when a single poster has posted a bunch of links at once. What I'd like to do is post one per day for the next several days. But I don't want to potentially forget one day because I got a little busy, or whatever. Would it be useful to be able to create a topic but set it to not post until a particular day or time?

Inspired by a similar thread @kfwyre posted a while ago.

I've been given an Android phone for a work contract and I don't want to carry two devices, so I will likely migrate from my Blackberry Z10 soon. The BB10 OS (not to be confused with BBOS, which ran the Bolds, etc. of BB's heyday) was intuitive, useful, and wayyyyy better than most people who never used it would have expected, only being doomed by the app gap. I'd have considered buying another Blackberry this year if I hadn't been given this other phone. I have long been wary of Android due to both privacy concerns and UI/UX gripes. Having tooled around for a couple days already, I'm struck by how many simple things I apparently can't do out of the box, and the fact that there are so. many. ads. Even in the apps! I know I will root and de-Google the device as much as I can once I get a hang of the OS.

So, I'm mainly looking for app recommendations, but general advice is appreciated as well. My use case is very functional - email, scheduling, messaging, browsing, navigation, weather, and calls. Preference given to FOSS and/or ad-free apps, but I'll pay up if it's really worth it. So far I've uninstalled a bunch of bloatware, installed Firefox, found SwiftKey to be the only half-decent replacement for Blackberry's terrific keyboard software, and the best free no-ad weather app looks to be a Norwegian one called Yr.

Hey all! I got the idea for this from looking at the thread asking the users what they want to see more of on Tildes. While I unfortunately don't feel I have much to contribute in the way of ~arts, ~books, or ~humanities, I do have a love of ~music! (And an electric drum-kit, that I hooked up to my laptop yesterday)

I remember there being a thread about music collaboration a while back, and while it looks like nothing came of it then, I figured the time was ripe for another try! My idea is this: People record themselves playing any instrument they want (or know how), and post that recording as a top level comment. Others in the thread download the format (midi, wav, whatever) and add their own instrument into the mix, posting as a reply to the top level comment. Think of it like crowdsourcing a song, I suppose.

To start us off, have a link to a google drive folder of mine which has a couple drum beats (3 wav, and 1 midi). Import those, riff off em, and post what you got! I'll see if I can do the same if anyone else has audio they'd like to share.

If this thread goes well, maybe we could make it a recurring topic!

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!

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!

My husband and I invested in a smoothie blender for the purposes of incorporating more fruits and veggies into our diets. We made our first batch this weekend — quite tasty, but definitely not perfect. Does anyone more experienced in the art of homemade smoothies have any wisdom they can share as we start to experiment with them?