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.

So I thought I'd try a little experiment here. Here are 2 songs I like from the same band. They're very different songs, and here's why I like them:

I Got You - This is a song about infatuation. It conveys that feeling I had when I was smitten with someone as a teenager. It feels very intimate to me, like the singer's directly expressing his innermost feelings to the person he's infatuated with. Or perhaps thinking of what he would say if he had the guts. It's very much a new wave pop song, and is probably the most well-known of Split Enz songs, at least where I live in the US.

I See Red - This is very much a song of rage. To me it's about a guy who's been dumped, or maybe who was infatuated with someone, and now they're with someone else. Whereas "I Got You" was very poppy, this is more punky. (I mean it's still pop, but with a punk flavor.) Putting it together with the previous song makes a lot of sense to me, even though they have such different tone. It's like the 2 songs together tell a story. I also love the phrase "down the drain like molten toothpaste." There's just something so illustrative about "molten toothpaste."

Anyway, just thought I'd share these random thoughts.

Are you an “old timer” in the computer industry? I’m writing a story about the things programmers (and QA people) had to do to test their software. It’s meant to be a nostalgic piece that’ll remind people about old methods — for good or ill.

For example, there was a point where the only way to insert a breakpoint in the code was to insert “printfs” that said “I got to this place in the code!” And all testing was manual testing. Nothing was automated. If you wanted a bug tracking system, you built your own.

So tell me your stories. Tell me what you had to do to test software, way back when, and compare it to today. What tools did you use -- or build? Is there anything you miss? Anything that makes you especially glad that the past is past?

C’mon, you know you wanted a “remember when”!

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!

I sense some folks are chomping at the bit so let's get this party started.

Think of this thread as a gigantic pile of records. This is our pile - there are many like it, but this one is ours. Don't waste a second worrying about what anyone else thinks. Got a record, even an EP that you've been spinning since it dropped? Find some random album from a /mu/ sharethread that blew your hair back? Throw it on the pile. Tracks for the stacks, just keep dropping them in the comments. If it's enough for you to spin repeatedly or to buy, it's worth sharing.

Stick to one comment per album, so that each album can be voted on individually. All we need is the artist and album name, brief/generalized genre tag (folk, metal, rock, indie, etc) and a listening link. Oh, and just a short sentence-to-paragraph size plug telling us what you're digging so much about the record. No need to go all war-and-peace on it, listening is always better than reading. ;)

Don't forget to name a favorite track (or two, three) from the record so the rest of us can easily dip a toe in.

No singles as top level comments. I'll leave a special comment below (mark it as joke/noise to keep it at the bottom) and you can drop your singles in there. The circumstances around covid-19 have lead to an absolute glut of singles coming out this year, even from artists who don't usually bother. I have a hunch it's worth keeping track of this year.

What we need here is albums, ears, and votes. We've got two months until the next thread, these things are best done slow so people can fit the listening time with their schedules. Dust off your favorite listening nook and make a date with some excellent albums, you might even feel better. :)

Bookmark this post if you plan to keep tossing albums in over the next two months. Also bookmark it if you want to comment and vote on the albums, find the best. We need all the ears we can get, and there is no such thing as layman opinions in music - you know what you like and that's all you should think about when voting.

Ignore it if you don't, because this thing is going to bump a lot as it builds.

If the album is on Bandcamp then that's the preferred stream source. If it isn't, then go with whatever streaming link floats your boat. You'll find most albums are on youtube (as playlists) this year due to their progress replacing google play music with youtube music. Hardly ideal listening with all the ads, but it is the most accessible to people who aren't paying for streaming services.

Right now this is more about building the library than it is about voting and vetting on the posts. We'll have another thread for that during the first week of December, and to collect late releases. The goal is to get the final set up as nice easy-to-consume playlists on most streaming services, and that's a job for late December, not right now.

When voting - upvote if you dig it, simple as that. If after listening, you think it's epic as hell and should be at the top of the list (a must-listen pick) then hit it with your exemplary token and thank the folks who brought you all the shiny gems to brighten up this wreck of a year.

2020 releases only, of course. Some albums may have been released in 2019, then pulled down and re-released in 2020. Those are just fine too since we didn't do one last year. Generally best to err on the side of inclusion.