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?

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?

This thread is posted weekly on Thursday - please try to post relevant content in here, such as news, updates, opinion articles, etc. Especially significant updates may warrant a separate topic, but most should be posted here.

If you'd like to help support Ukraine, please visit the official site at https://help.gov.ua/ - an official portal for those who want to provide humanitarian or financial assistance to people of Ukraine, businesses or the government at the times of resistance against the Russian aggression.

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.

Find yourself watching tons of great videos on [insert chosen video sharing platform], but also find yourself reluctant to flood the Tildes front page with them? Then this thread is for you.

It could be one quirky video that you feel deserves some eyeballs on it, or perhaps you've got a curated list of videos that you'd love to talk us through...

Share some of the best video content you've watched this past week/fortnight with us!

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.

Good morning ~ This is a thread to discuss new album releases that have arrived on our doorstep this week. Feel free to share albums and EPs that have caught your eye and interest.

Discussion Points

What are you looking forward to listen to?
Have you listened to any of these releases?
What are your thoughts?
What have you enjoyed from these artists in the past?

Why Friday?

Most (but not all) new LPs release on a Friday, as labels want to give the release a full week of sales before entering the charts.

~~ Feedback on the format welcome!

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?

Add awesome game deals to this topic as they come up over the course of the week!

Alternately, ask about a given game deal if you want the community’s opinions: e.g. “What games from this bundle are most worth my attention?”

Rules:

• No grey market sales
• No affiliate links

It is strongly encouraged that you share why you think the game/games are worthwhile.

If you don’t want to see threads in this series, add save point to your personal tag filters.

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!

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 week. Did you accomplish any goals? Suffer a failure? Do nothing at all? Tell us about it!

Tildes is a very serious site, where we discuss very serious matters like adhd, digital distribution and antitrust. Tags culled from the highest voted topics from the last seven days, if anyone was bemused.

But one of my favourite tags happens to be offbeat! Taking its original inspiration from Sir Nils Olav III, this thread is looking for any far-fetched offbeat stories lurking in the newspapers. It may not deserve its own post, but it deserves a wider audience!

Choose one album
that you love
that you think deserves more love

Tell us what it is, and why.

Previous posts in series

Additional Details

What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started a new diet or have a new recipe you want to share? Anything else health and wellness related?

Good morning ~ This is a thread to discuss new album releases that have arrived on our doorstep this week. Feel free to share albums and EPs that have caught your eye and interest!

Discussion Points

What are you looking forward to listen to?
Have you listened to any of these releases?
What are your thoughts?
What have you enjoyed from these artists in the past?

Why Friday?

Most (but not all) new LPs release on a Friday, as labels want to give the release a full week of sales before entering the charts.

~~ Feedback on the format welcome!

This thread is posted weekly on Thursday - please try to post relevant content in here, such as news, updates, opinion articles, etc. Especially significant updates may warrant a separate topic, but most should be posted here.

If you'd like to help support Ukraine, please visit the official site at https://help.gov.ua/ - an official portal for those who want to provide humanitarian or financial assistance to people of Ukraine, businesses or the government at the times of resistance against the Russian aggression.

This is Album of the Week #5 ~ This week's album is Eminem - The Marshall Mathers LP

Year of Release: 2000
Genre(s): Hip Hop
Country: United States
Length: 72 minutes
Album.Link

Excerpt from Pitchfork:

But the anger and trauma he conjured from his childhood of abuse and bullying felt uncomfortably real in all his performances. On The Marshall Mathers LP, he suits the action to the word and the word to the action. He picks the right tone for the right mood, the horrorcore of “Remember Me?,” the beleaguered artist on “The Way I Am,” the impish malevolence of “Criminal,” or the tortured, regretful, loving, deranged, murderous everything-all-at-once feeling of “Kim.” We don’t really believe it, but we believe Eminem really believes it.

Discussion points:
Have you heard this artist/album before? Is this your first time hearing?
Do you enjoy this genre? Is this an album you would have chosen?
Does this album remind you of something you've heard before?
What were the album's strengths or weaknesses?
Was there a standout track for you?
How did you hear the album? Where were you? What was your setup?

--

Album of the week is currently chosen randomly (via random.org) from the top 5000 albums from a custom all-time RYM chart, with a 4/5 popularity weighting. The chart is recalculated weekly.

Missed last week? It can be found here.

Any feedback on the format is welcome ~~

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.

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?

Tildes is a very serious site, where we discuss very serious matters like cuisine.american, grammar and incels. Tags culled from the highest voted topics from the last seven days, if anyone was bamboozled.

But one of my favourite tags happens to be offbeat! Taking its original inspiration from Sir Nils Olav III, this thread is looking for any far-fetched offbeat stories lurking in the newspapers. It may not deserve its own post, but it deserves a wider audience!

Add awesome game deals to this topic as they come up over the course of the week!

Alternately, ask about a given game deal if you want the community’s opinions: e.g. “What games from this bundle are most worth my attention?”

Rules:

• No grey market sales
• No affiliate links
• Each deal must include a short statement of why you think the game/games are worthwhile, or a question to the community about the game/games

If you don’t want to see threads in this series, add save point to your personal tag filters.

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 week. Did you accomplish any goals? Suffer a failure? Do nothing at all? Tell us about it!

This is Album of the Week #4 ~ This week's album is The Notorious B.I.G. - Life After Death

Year of Release: 1997
Genre(s): Hip Hop, Gangsta Rap
Country: United States
Length: 109 minutes
Album.Link

Excerpt from Stereogum:

Perhaps the greatest testament to the power of Life After Death, the second and final album from the Notorious B.I.G., was that Biggie’s death somehow didn’t overshadow it. By all rights, that’s exactly what should’ve happened. Here, we had the single greatest talent of his generation cut down in his prime — or maybe, since he was only 24, before he’d even had a chance to reach his prime. It was sudden and shocking and violent, and the murder remains unsolved. Life After Death came out barely two weeks later. It is called Life After Death, which is, in retrospect, even weirder than Hole recording an album called Live Through This before Kurt Cobain’s suicide and then releasing it almost immediately afterward. It ends with a song called “You’re Nobody Till Somebody Kills You” — and in Biggie’s case, that turned out to be vaguely true. (Biggie was a star before his death, but he became a genre-transcending superstar afterward.) All these morbid, poetic coincidences should dominate the album’s narrative. And yet Life After Death took on a life of its own. It became a document of celebration, not sadness. It wrote its own narrative.

Discussion points:
Have you heard this artist/album before? Is this your first time hearing?
Do you enjoy this genre? Is this an album you would have chosen?
Does this album remind you of something you've heard before?
What were the album's strengths or weaknesses?
Was there a standout track for you?
How did you hear the album? Where were you? What was your setup?

--

Album of the week is currently chosen randomly (via random.org) from the top 5000 albums from a custom all-time RYM chart, with a 4/5 popularity weighting. The chart is recalculated weekly.

Missed last week? It can be found here.

Any feedback on the format is welcome ~~

What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started a new diet or have a new recipe you want to share? Anything else health and wellness related?

Have you watched any movies recently you want to discuss? Any films 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.

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.

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 thread is posted weekly on Thursday - please try to post relevant content in here, such as news, updates, opinion articles, etc. Especially significant updates may warrant a separate topic, but most should be posted here.

If you'd like to help support Ukraine, please visit the official site at https://help.gov.ua/ - an official portal for those who want to provide humanitarian or financial assistance to people of Ukraine, businesses or the government at the times of resistance against the Russian aggression.

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?

Choose one series
that you love
that you think deserves more love

Tell us what it is, and why.

Welcome to the inaugural MangaLove post. Passively being exposed to new manga and anime is one of the things I've missed most about Reddit, so this is an effort to bring some of that spirit to Tildes.

Many thanks to @kfwyre and their AlbumLove series in ~music that I plagiarized was inspired by.

Additional Details

What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started a new diet or have a new recipe you want to share? Anything else health and wellness related?

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.

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.

What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started a new diet or have a new recipe you want to share? Anything else health and wellness related?

Tildetablers,

What board games, card games and whatnot have you been playing this week? Don't be shy, share those sessions!

For me it was a single game of Western Legends with expansions. I've played this game, sans expansions, a couple of times and have never really been blown way, but the expansion certainly helped and I enjoyed it a whole lot more.

The game sets you as a character in the wild west. It's a bit of a sandbox game: there are a bunch of things you can do and you have freedom moving around and doing them. You can hustle cattle, play poker, buy upgrades, prospect for gold, fight, steal, &c. You basically earn points by doing each of these things and working your way up various tracks to earn legendary points which are victory points.

The expansions added a whole frontier area to explore and added story cards, which are basically thematic events that give you goals to claim. I feel like extra board and story cards really improved the experience and immersion and it was much more enjoyable this time around. We also played two characters each, which may also have helped, as this made it possible to explore different strategies at the same time.

I'm still not massively impressed with the game, but I don't think I'll disappointed if it's suggested now. If I were forced to rate it I'd probably give it a 1.8/π.

So, everyone, what have you played this week? What did you think? What are you hoping to play next?

Good morning ~ This is a thread to discuss new album releases that have arrived on our doorstep this week. Feel free to share albums and EPs that have caught your eye and interest!

Discussion Points

What are you looking forward to listen to?
Have you listened to any of these releases?
What are your thoughts?
What have you enjoyed from these artists in the past?

Why Friday?

Most (but not all) new LPs release on a Friday, as labels want to give the release a full week of sales before entering the charts.

~~ Feedback on the format welcome!

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!

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 week. Did you accomplish any goals? Suffer a failure? Do nothing at all? Tell us about it!

Tildes is a very serious site, where we discuss very serious matters like data.user, litigation and politicians. Tags culled from the highest voted topics from the last seven days, if anyone was nosy.

But one of my favourite tags happens to be offbeat! Taking its original inspiration from Sir Nils Olav III, this thread is looking for any far-fetched offbeat stories lurking in the newspapers. It may not deserve its own post, but it deserves a wider audience!