What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.

If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!

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?

I've posted about my mental health issues on Tildes before, 1st post 2nd post.

I reread my other 2 posts before writing this, and I definitely cringed a bit at them. I was not doing good and did not have a real sense of what to include and not. However, I really needed to feel seen and heard, so I also don't regret either of them. I didn't have anyone to open up to in my real life.

I've gotten a much better understanding of what I went through as a kid over the past year. My sister physically and emotional abused me since before I can remember until she left for college, and my parents always ignored it. That's fucked up, and there's nothing wrong with me for being so damaged because of it.

I moved to Portland, and it was definitely the right choose. I can't imagine living in the suburbs again. I went to my first concert, I got my first tattoo. I tried weed for the first time, and it really helps me gain emotional clarity. For first time in my life, I have some real hope for my future.

As the final note, I'd like to thank all the nice people here again; you really did help a scared, lonely kid more then you think.

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.

I'm a longtime Linux user, and I haven't used Windows in a while aside from just launching games from Steam on my living room computer, but my new work laptop is Microsoft's flagship Surface Pro 4 so I figured it'd be the best experience you can have on a Windows machine.

I got the laptop in yesterday, and here's the summary of my experience:

• I am required by IT to use Chrome. To install Chrome, I had to click through no fewer than three "Are you sure you don't want to use Microsoft's more secure, faster browser?" banners to do so.

• When I plug in my external monitor, by default, the two monitors were mirrored; when I went into display settings, it didn't show the external monitor until I closed and reopened the settings menu.

• I have an Apple Magic Touchpad 2, and I had some issues getting it set up on Ubuntu 20.04 when I initially got it. These problems are now solved on the latest version of Ubuntu, but I was expecting a nice contrast in a good plug-and-play experience on Windows. Instead, I had to install sketchy drivers from some random GitHub page to get it to work properly.

• I've had some minor annoyances with my audio interface (a Zoom R-22) not being set as the default when I want it to be on Ubuntu, and I was really looking forward to getting a smooth video calling experience with my nice mic and interface on Windows. Lo and behold, the R-22 audio input - the whole reason I have it - doesn't work at all, at least in the Zoom video calling app.

• On Ubuntu, I use QV4L2 to configure the framing, zoom, exposure, etc of my camera. It's a bit clunky, and I was looking forward to having a smooth experience with this on the premier business OS. Unfortunately, the camera on this laptop has extremely aggressive aperture priority mode enabled, and there is no first-party app to configure it! The documentation tells me to go to Settings -> Devices -> Camera but there is no such menu item. So, I just look either washed-out or ultra-dark in every video call.

• After running Windows Update and rebooting, I was greeted with a full-screen and quite annoying to exit tutorial for Microsoft Teams - an app I did not install, because my company uses Slack.

This in addition to some setup papercuts, but I think those were probably due to my corporate IT's process rather than Windows itself.

Is this common? Do people who use Windows just... put up with this kind of thing? Or am I having an exceptionally bad experience for some reason?

I'm mostly interested in metro/subways, but also over the ground systems and rapid transit in general.

Mostly the vehicles themselves, the rails, and the related technologies. I mean, I do enjoy the city planning bits, but some channels focus too much on the design and evolution of the lines and I don't like that, looking at a map is not really enticing to me. A healthy mix would be nice, some engineering deep dives mixed with history, urban planning, and a lot of train porn! (Not rule 34 lol).

Thanks!

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.

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!

It’s the summer movie season, which means that Oscar season is right around the corner. Here are my current predictions for what gets nominated. Not everything will end up happening, last year I had The Last Duel making several categories and it ended up getting blanked. You can see my previous relatively early predictions here

The Cannes Film Festival happened and it was a total bust. Doesn’t seem like there will be a Cannes breakout this year like last year’s Drive My Car.

Picture:

1. Killers of the Flower Moon
2. Empire of Light
3. The Fabelmans
4. Avatar: The Way of Water
5. Babylon
6. The Whale
7. Poor Things
8. Women Talking
9. Elvis
10. Thirteen Lives

Director:

1. Martin Scorsese - Killers of the Flower Moon
2. Sam Mendes - Empire of Light
3. James Cameron - Avatar: The Way of Water
4. Damien Chazelle - Babylon
5. Sarah Polley - Women Talking

Original Screenplay:

1. Empire of Light
2. Babylon
3. The Fabelmans
4. Thirteen Lives
5. TAR

Adapted Screenplay

1. Killers of the Flower Moon
2. Poor Things
3. Women Talking
4. The Whale
5. The Son

Lead Actor:

1. Austin Butler - Elvis
2. Hugh Jackman - The Son
3. Leonardo DiCaprio - Killers of the Flower Moon
4. Brendan Fraser - The Whale
5. Colman Domingo - Rustin

Lead Actress:

1. Margot Robbie - Babylon
2. Cate Blanchett - TAR
3. Emma Stone - Poor Things
4. Lilly Gladstone - Killers of the Flower Moon
5. Olivia Colman - Empire of Light

Supporting Actor:

1. Paul Dano - The Fabelmans
2. Robert DeNiro - Killers of the Flower Moon
3. Ben Wishaw - Women Talking
4. Colin Firth - Empire of Light
5. Brad Pitt - Babylon

Supporting Actress:

1. Michelle Williams - The Fabelmans
2. Jessie Buckley - Women Talking
3. Sadie Sink - The Whale
4. Laura Dern - The Son
5. Jean Smart - Babylon

Animated Feature:

1. Lightyear
2. Strange World
3. Turning Red
4. Pinnochio
5. Puss in Boots: The Last Wish

Best Original Score:

1. Empire of Light
2. Avatar: The Way of Water
3. Women Talking
4. Babylon
5. Killers of the Flower Moon

Best Original Song:

1. Hold My Hands by Lady Gaga from Top Gun: Maverick
2. Carolina by Taylor Swift from Where The Crawdad Sing?
3. Nobody Like U by Billie Eillish and Finneas from Turning Red
4. On My Way by Jennifer Lopez from Marry Me
5. Vegas by Doja Cat from Elvis (might be ineligible)

Best Sound:

1. Avatar: The Way of Water
2. Top Gun: Maverick
3. Killers of the Flower Moon
4. Babylon
5. Thirteen Lives

Best Production Design:

1. Babylon
2. Killers of the Flower Moon
3. Avatar: The Way of Water
4. Empire of Light
5. Elvis

Best Cinematography:

1. Avatar: The Way of Water
2. Killers of the Flower Moon
3. Babylon
4. Empire of Light
5. Poor Things

Best Makeup and Hairstyling:

1. The Batman
2. Elvis
3. The Whale
4. Babylon
5. Poor Things

Best Costume Design:

1. Poor Things
2. Killers of the Flower Moon
3. Babylon
4. Empire of Light
5. Elvis

Best Film Editing:

1. Avatar: The Way of Water
2. Babylon
3. Killers of the Flower Moon
4. Thirteen Lives
5. Elvis

Best Visual Effects:

1. Avatar: The Way of Water
2. Top Gun: Maverick
3. Doctor Strange in the Multiverse of Madness
4. The Batman
5. Thirteen Lives

I know we already have more than enough launchers for the PC platform, but are there any recommendations for the one that can rule them all, with the controller functionality and presentation of Steam's Big Picture Mode, but also with the modularity and ease of setup of GOG Galaxy? Or is it pretty much one of the above as far as easy options go?

Edit: Took a look at Playnite, really impressed. Deeper impressions in the thread.