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.

Any big Comic fans here? anyone see GOTG3 yet? I'm going on the 13th, didn't have time to get to it till then.

No Spoilers, please just curious what everyone thinks.

Was wondering were you would rank it in the MCU.

My top three for Solo Films
Captain America Winter Solider
Captain America Civil War
Thor Ragnarök

Top Avengers
Infinity War and Endgame

Does GOTG3 beat Civil War or Winter Solider ? I hear its better than two but I don't think that's hard to do. GOTG 2 is the weakest of the first two for sure.

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 instead of just posting a link to the opening weekend of Guardians of the Galaxy Vol 3 (which is looking to open in the low 110s) I thought I'd just make a post talking about the recent box office of super-hero movies and the fatigue going on with general audiences.

Let's rewind to the far distant past of December 2021. Spider-Man: No Way Home just opened to over 200 million dollars. It re-invigorates movie going among the general public. Grosses at the box office afterwards are vastly higher. Spider-Man makes nearly two billion dollars at the box office. The next super-hero movie to come out is Batman, which does pretty well considering it's the first entry in a rebooted series.

Then, the summer movie season kicks off with Doctor Strange in the Multiverse of Madness. Seemingly, the movie is heading towards a 200+ opening weekend (much like Spider-Man). The film was sold as a follow-up to No Way Home, but in reality it had little to nothing to do with that movie. General audiences caught on, and were overall mixed on the film, so the opening weekend landed under 200 million. The film ultimately went on to gross over 900 million at the box office, but with terrible legs.

The next film after that was Thor: Love and Thunder. Again, the film garners a mixed reception with both critics and audiences. It ultimately grosses less than it's predecessor Thor: Ragnarok (although L&T did not open in China or Russia). It did okay all things considered, but it was another poorly received entry in the franchise.

Black Panther: Wakanda Forever comes out in November with much better reception. Although it still ended up dropping 500 million worldwide from it's predecessor (300 domestic). Again, considering this was dealing with the loss of it's star, it did okay all things considered. Still, it was a disappointment compared to what it was expected to make and the critical reception was weaker than anticipated.

Then the big dumpster fire happens. Ant-Man and the Wasp: Quantumania is released. It gets the MCU's second rotten score on RT, and gets the worst audience reception of the series since Eternals. The film manages to get the highest opening of the Ant-Man franchise, but with terrible reception it also gets the worst legs of the MCU. It ends up with the lowest gross of the Ant-Man movies despite opening higher than both of them.

The GA got burned from a constant flood of mediocre product (and we're not even talking about all the TV shows).

Guardians of the Galaxy Vol 3, despite much better reception than most recent MCU films, is ending up with a lower opening than it's predecessor, and will most likely end up with a lower gross than the first film. This is referred to as "paying for the sins of the father."

This will be the lowest May opener since The Amazing Spider-Man 2 opened in 2014 (not counting 2020 or 2021).

Super-hero movies will still be around, and some of them might make a lot of money, but it's clear the utter dominance it had at the box office for the past 10 years is over. Which is kind of insane to think about how quickly this all came crumbling down (only 1.5 years!). But it goes to show there's a limit to how many mediocre/bad movies the GA can handle in a franchise.

And this isn't even counting how poorly both Shazam and Black Adam did for DC.

It seems like Quantumania might have been the "Heaven's Gate" for the MCU, it was the straw that broke the camels back.

So what will happen with super-hero movies? Probably a return to the pre-Avengers normal. Mainline superheroes (like Batman and Spider-Man) will remain lucrative. But lesser known superheroes are now riskier bets, and if those lesser known heroes are in a bad movie, there's no saving it. Logically, budgets for these movies should get lower to accommodate the lower grosses bound to happen from now on. And there needs to be actual effort put into the film in order to make it a good film first and foremost.

Unfortunately for the MCU, many of the movies slated for 2024 were greenlit before they could change direction (like Captain America: New World Order which went into production a few months ago). The budgets for these films are probably going to be really high like they've all been (200M+) and the grosses will get even lower as these movies were not given proper re-writes to right the ship.

As for DC, it puts a lot of pressure on Gunn to make Superman a good movie. And not just a good super-hero movie, but a good movie. Like how Batman Begins was just a good movie.

Hollywood is now looking towards video game movies as the next big thing, thanks to the massive success of Mario, so these movies are going to have to build themselves back up.

What have you been listening to this week? You don't need to do a 6000 word review if you don't want to, but please write something! If you've just picked up some music, please update on that as well, we'd love to see your hauls :)

Feel free to give recs or discuss anything about each others' listening habits.

You can make a chart if you use last.fm:

http://www.tapmusic.net/lastfm/

Remember that linking directly to your image will update with your future listening, make sure to reupload to somewhere like imgur if you'd like it to remain what you have at the time of posting.