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.

Howdy, citizens!

So, after begging, borrowing and stealing, I've managed to piece together what I believe to be a barely capable rig so that I can get into playing this incredible looking game, but I'm running into a performance issue that makes it pretty unplayable.

Here's my rig:
AMD A-10 6800k @ 4.1 GHz
32 GB Ram
128 GB SanDisk SSD (for the game only, OS is on a similar size Kingston)
GTX 960 for the graphics.

Last night I tried running the game from my normal HD, which is a 1tb platter. This did not go well. Just moving my character around in the initial apartment was torture, and using anything in the room was an exercise in frustration to the point that the room ended up looking like a brawl had happened in it before I made it out, with coffee cups and water bottles all over the floor.

So, after I read a few pointers online, I salvaged the SanDisk from a different PC and began reinstalling on that. Today I hope to be able to move around smoothly enough to actually play, but aside from setting every option to its lowest, are there any other little tricks I can use to get it more playable?

Today's problem description: https://adventofcode.com/2023/day/5

Please post your solutions in your own top-level comment. Here's a template you can copy-paste into your comment to format it nicely, with the code collapsed by default inside an expandable section with syntax highlighting (you can replace python with any of the "short names" listed in this page of supported languages):

<details>
<summary>Part 1</summary>

```python
Your code here.
```

</details>

This is a topic that I have been holding to myself for quite some time, mostly because I didn't know how to quite phrase what I wanted to say. I still don't think I am going to do the best job but I wanted to hear what other peoples thoughts.

I'm someone who has always valued my few friendships very highly. My dad drilled into me at a young age that it is better to have fewer, high quality friendships than a plethora of not very meaningful relationships.

As people age and move on to different stages in their life, I completely understand that some people might not have the same amount of time to give you in a day that they previously used to. People get busy, have relationships, get married, etc. Which brings me to my situation and how I feel:

I have a friend who I've known since high school, and we're both 30 now. We've always been pretty good friends and in our later 20's we got even closer. I would say that we both deviate from the 'typical' unemotional guys who don't share how they feel with others. Both him and I would let us know what's going on in our lives and how it made us feel, etc. During this time, he was in a relationship (which he was not super happy with, due to some actions his partner did), but would share some of his more inner thoughts with me rather than her. They weren't the best at communicating with one another.

Fast forward two to three years, I got married, my friend broke up with his then partner. He moved back to his parents place, and the time before my marriage (I lived with my parents and had access to a car) I would try and visit him as often as I can just to hang out at night, or to see how he's doing. I've even driven over at midnight just to hangout with him until 4 AM because he was feeling lonely.

He congratulated me online (my wedding took place in another country, and I know none of my friends could afford to, or would not want to, travel just for a ceremony, so I didn't really invite anyone) but also indirectly told me he was jealous that I was married and stuff and he wasn't. For him, getting married is a much bigger deal than it is for me, I never really minded being single or alone. Please don't misconstrue this as me not being appreciative of my wife. She is very dear to me and I always to provide the best for her.

Fast forward another 2 years, and my friend got married to someone he met online. Since then our friendship has been mostly one sided almost. I had to initiate almost every conversation, and it's like messaging a blank wall, there's no reciprocation, and if there is it is very shallow. On top of that, we hang out much less as well (which I get, you do have to give a certain amount of commitment and attention to your spouse) so messaging is the main way to keep in touch.

Don't get me wrong, I've had this happen to me plenty of times. Mostly in university, had a couple of really good friends (or so I thought), as soon as they get a girlfriend, most of them forget I even exist. Maybe I expected more because I've known him for so long, or maybe I should expect less and accept that in the way our current society is shaped people start forming a bubble around themselves past a certain point in their life and you're no longer included in it.

Maybe this post came off as me being really entitled, I don't know. I just wanted to vent my frustrations somewhere. What does everyone on here think about relationships with their friends when you're married? Are you okay with seeing them less often? Is this just an expected outcome of being married?

A friend and I were bantering about how we should organize a RPS tournament, where the LOSER advanced and was ultimately kicked in the bum by the "winner" of the final round, and also given $10 as a pity for being the "greatest loser".

This quickly morphed into daydreams of a global event, culminating in the grand finals at the Mandalay Bay, with coverage by ESPN 12, sponsorship deals, trading cards ("Joe is known for his southpaw stance and shooting from his off-hand which greatly throws off his opponent." and per-year statistics of Win % by rock, paper, and scissors); the whole nine yards.

But it got us thinking... in today's age, would it be difficult to organize a simple RPS tournament GLOBALLY? What technologies would you use? Could you approach it 100% digitally? How would you verify the loser for advancement?

Let's even say someone was willing to put up $20k or even $100k to actually fly winners from each continent or major population region and put them up at the Mandalay Bay (btw - that hotel just came to mind because it was the first to come to mind in Las Vegas) for a 1-day event. Would that change anything?

RPS because the absurdity of it and the zero cost to entry.

We await your thoughts...

Golden Globe noms will be coming out next week. They recently changed a rule that each category now has six nominees instead of five (boo!). These are the only categories listed on Goldderby so that's all I'm gonna be predicting (Original Score and Original Song are the two categories not listed). Here's where I think the nominations will land:

Motion Picture - Drama

1. Oppenheimer
2. Killers of the Flower Moon
3. Maestro
4. All of Us Strangers
5. Anatomy of a Fall
6. Past Lives

Motion Picture - Musical or Comedy

1. Barbie
2. The Holdovers
3. Poor Things
4. American Fiction
5. The Color Purple
6. May December

Director

1. Christopher Nolan - Oppenheimer
2. Martin Scorsese - Killers of the Flower Moon
3. Yorgos Lanthimos - Poor Things
4. Greta Gerwig - Barbie
5. Alexander Payne - The Holdovers
6. Bradley Cooper - Maestro

Screenplay

1. Barbie
2. The Holdovers
3. Oppenheimer
4. Killers of the Flower Moon
5. Poor Things
6. American Fiction

Lead Actor - Drama

1. Cillian Murphy - Oppenheimer
2. Bradley Cooper - Maestro
3. Leonardo DiCaprio - Killers of the Flower Moon
4. Andrew Scott - All of Us Strangers
5. Adam Driver - Ferrari
6. Teo Yoo - Past Lives

Lead Actress - Drama

1. Lilly Gladstone - Killers of the Flower Moon
2. Cailee Spaeny - Priscilla
3. Sandra Huller - Anatomy of a Fall
4. Carey Mulligan - Maestro
5. Annette Bening - Nyad
6. Greta Lee - Past Lives

Lead Actor - Musical or Comedy

1. Paul Giamatti - The Holdovers
2. Jeffrey Wright - American Fiction
3. Timothee Chalamet - Wonka
4. Nicolas Cage - Dream Scenario
5. Matt Damon - Air
6. Peter Dinklage - She Came To Me

Lead Actress - Musical or Comedy

1. Margot Robbie - Barbie
2. Emma Stone - Poor Things
3. Fantasia Barrino - The Color Purple
4. Natalie Portman - May December
5. Julia Louis Dreyfus - You Hurt My Feelings
6. Jennifer Lawrence - No Hard Feelings

Supporting Actor - Any Motion Picture:

1. Robert Downey Jr. - Oppenheimer
2. Ryan Gosling - Barbie
3. Mark Ruffalo - Poor Things
4. Robert DeNiro - Killers of the Flower Moon
5. Charles Melton - May December
6. Dominic Sessa - The Holdovers

Supporting Actress:

1. D'avine Joy Randolph - The Holdovers
2. Emily Blunt - Oppenheimer
3. Julianne Moore - May December
4. Danielle Brooks - The Color Purple
5. Penelope Cruz - Ferrari
6. America Ferrera - Barbie

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.

So we have a month with movies from the 1990s and we are starting off with Lost Highway directed by David Lynch from 1997.

IMDb
Letterboxd
Wikipedia

Are you familiar with other works by David Lynch and how does this compare? Does it have a certain "90s feel" to it? Feel free to add any thoughts, opinions, reflections, analysis or whatever comments related to this film.

The rest of the schedule is:

• 11th of December: Edward Scissorhands
• 18th of December: The Talented Mr. Ripley
• 25th of December: Home Alone

Hey everyone! I thought since the community has grown quite substantially since I last asked this question^[1] it would be nice to bring it back up again. Without getting into whether or not the specific idea that "strong opinions, weakly held" may or may not have merit, I think having flexibility in your thinking and not holding on to opinions out of loyalty or inertia is a valuable skill to have. So, small or big, what is something that you changed your mind about this year?

[1] https://tildes.net/~talk/11mw/what_is_something_you_have_changed_your_mind_about_in_the_last_year

I just got into watching physics simulation videos on youtube, stuff like marble races, marble battles, Multiply Or Release, and various other simulation content. Absolutely enthralling stuff for someone like me who enjoys simply watching an environment do its thing.

I wanted to get into making my own sims/scenarios and was wondering if you all on tildes had some recommendations. I've been trying algodoo and it seems very nice but I've heard its mostly abandonware and theres some features I find lacking. So I wanted to look into options for my little tinkering. I understand that there may not be a perfect one but I'd love to have some options to try and tinker in, and my research has led me to lots of them that seem at first look to be purely for academic purposes.

To crystallize my desires into a definite paragraph:
I'm looking for physics sim software recommendations to make my own marble races and other simulated 'games'. I don't mind having to learn it from scratch(including scripting language). I dont care if its paid or free. Ease of use is great but Non-essential since it can likely be learned over time. Preferrably not abandonware, or at least feature-rich if development has been completed. and lastly, performance is definitely important since I'll likely be building some grand designs as I settle in.