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?

For the past month, I have been reading "The Wisdom of Psychopaths" by Kevin Dutton which delves into traits, behaviors, and motivations behind psychopaths. This book isn't just about serial killers but rather also the "successful" functional psychopaths such as stockbrokers, politicians, and business executives. You can read an excerpt from the book here if interested. A few interesting takeaways that I have had from the book so far are the innate cues that some people have on picking up on psychopathic cues. This is like speaking to someone and getting the heebie-jeebies from them for some reason. Apparently, women are more perceptive to this than men.

So, I'm curious if you have ever met a person that gave off that vibe, and what in particular gave you that vibe?

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.

The IFSC is an international governing body for competitive climbing, recognised by the Olympic Committee. Sport climbing is now an Olympic sport. There are three disciplines: lead, boulder, and speed. In the Olympics the climbers will do all three disciplines.

In speed climbing there are two 15 meter tall walls with hand and footholds attached. The two walls are the same as each other. The layout is fixed -- the same layout is used for each competition. Two climbers race each other up the wall, and the winners go on to race each other up the wall.

Here's Wired with a useful introduction to speed climbing: Why it's almost impossible to climb 15 meters in 5 seconds I like this video because it gives a good "elevator pitch" introduction to the 3 disciplines, and then gives a good detailed intro to speed climbing. They talk about beta and some of the beta-breaks that have decreased the time taken to get up the wall.

Here's Albert Ok with a quite personal video about his training for speed climbing. I won't say more because I don't want to spoil it, but it's a nice description of training. 5 Lessons I learned speed climbing for 150+ hours

Here's Magnus Midtbø and Pete Whittaker having fun in a gym, challenging each other to a speed climbing dual. (The whole video is a fun watch - they both seem like nice, chill, people and they have good on screen chemistry with each other). I challenge Pete to a speed climbing dual

The most recent speed world cup was in Chamonix 2019. The next one (for speed and boulder) will be 28th - 30th May in Salt Lake City. The IFSC tend to live stream the events.

Over the past few months I've been questioning my gender identity, and so I've been doing what any good millennial does and trying to read up on what everyone else in my position did and does. I've found a few resources here and there, but I'd really like to read/watch/listen to more if I can. I'm looking for blogs, YouTube channels, podcasts, twitter users, and possibly even music... Anything created by non-cis people and which discusses their experience with figuring out their gender identity.
Hopefully my fellow Tilderen can recommend some good media to me? I'd also be glad and grateful to hear any personal stories from folks here as well, though I do know it can be a very personal thing so no sweat if you don't feel happy sharing.

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!

On my desk I have two screens -- one off to the side for movies, TV, etc and my main in front. Sometimes I find myself wanting subtitles on my main screen. The main issue I've found, at least with macOS, is that the SRT players suck.

I figured, why not just generate a tiny black video with embedded subtitles?

ffmpeg -i subs.srt -t 3:00:00 -s 40x10 -f rawvideo -pix_fmt rgb24 -r 25 -i /dev/zero subs.mpeg

Set the ratio to be super small without being too small. This video is 40px by 10px and the video only takes a few seconds to generate. For me, this generated at ~850x speed.

From there, jack up the subtitle font size and shift it up a little bit so nothing gets cut off. This also works really well with tiling window managers.

Screenshot