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 a few weeks back someone posted an article here about Super Recognizers. These are people that can instantly remember 80% of a persons face and can identify that face easily later on. It talked about how these people are getting hired by police departments across the world.

It caught my attention because my wife has always been freakishly good at facial recognition and recall. Well, she took the test, which led to another test, and today she received her official invitation to join Super Recognizers International!

This is a big deal because her company is about to go under and she has been considering leaving lately. This will open up doors for her to find work she can do from home on a flexible schedule. Thanks @skybrain for posting that article and thank you to the Tildes community for being here!

I'm looking for some new material for my ice dancing playlist.

Anything decently musical and rhythmic is good. Current favorites: weapon of choice, stop the bot, uptown funk, blackheart (tsfh), burn (Goulding).

Sometimes I get into a back-and-forth... heated interaction with someone, and it goes on for a while, and then they stop responding. Afterwords, I might wonder if it was worthwhile. Maybe they got tired of arguing with me, or maybe they just thought the conversation reached its natural endpoint? Rarely, the conversation might end with us explicitly agreeing it was a good discussion, but that's kind of formal and not the usual case online.

Just stopping is my habit as well. If I don't want to talk anymore, I upvote the last comment (if I thought it was good) but don't reply.

In the case of repeated interactions like this with the same person, sometimes I wonder if I'm annoying them by replying to their comments too much, particularly if we disagree often. I've never been explicitly told to go away, but people are often reluctant to say things like that, for good reason since you never know how people will react.

It seems to me that upvotes don't tell me this. Upvotes tell you whether your comments make sense to the crowd. They don't tell you whether the person you're talking to liked your reply. Which seems like it would be good to know. It would be valuable feedback if the goal is to be a better conversationalist. That seems like a good goal to aim for?

I guess we could get in the habit of saying "good point" and all that, and sometimes things can be inferred from what people say if you're good at taking hints, but not all of us are. But we are all trained to upvote things we like already, and it seems like it would be nice to take advantage of that.

To the extent that people like to gather internet points, I wonder what sort of conversation would be encouraged if you got them by writing a good reply from the perspective of the person being replied to? But I guess it could be gamed pretty easily if two people cooperate, so we probably shouldn't keep a total.

Also, think about how this looks from the outside: if you are reading a conversation by two other people in a heated back-and-forth, how do you know whether they're having a good time or not? Maybe it seems obvious, but in some cases a heated discussion might look worse to outsiders than participants. If you could see that they liked each other's comments then it would seem friendlier.

Note that Facebook does tell you who upvoted a comment, but since it tells you everyone who upvoted it, it's even more information, maybe too much.

(This is a followup to @NaraVara's previous topic, focusing on a particular aspect of it.)

OK, let's give this a shot.

Feel free to share your thoughts about anything going on this week in the world of sports - an event you're looking forward to, a great game you watched that you recommend, a story that you're keeping tabs on, whatever tickles your fancy. Also, if you have any ideas/suggestions about this thread itself, feel free to chime in. My one suggestion is to please keep spoilers out of top-level comments.

Edit: We don't have a theme tune (yet) but just imagine this is the intro (other brands are available).

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!

Most California voters received their ballots this week, and as usual there are a bunch of propositions to vote on that we’ve barely heard of because nearly all election discussion is about national issues. So, what are you using to study up?

I have tried to answer this myself and come up empty handed. When a U.S. president leaves office, they take intimate awareness of many national secrets with them (weapons systems, intelligence gathering techniques, etc.). What prevents a former president from selling this information to the highest bidder?