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?

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.

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 thread is posted Monday/Wednesday/Friday - 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.

By "not too specific to the UK", I mean something that can be enjoyed and understood (on a cultural level, not the language - subtitles take care of that) by someone who is not part of that culture. For reference, I really enjoyed The IT Crowd and Peep Show. Thanks!

I'm making a video game, which is sort of a mixture of a puzzle game and interactive fiction. I'm a little uncertain about some name and pronoun choices that I currently offer to the player and I thought that you guys might be able to help me.

The game is in English. At the beginning of the game, the player chooses the main character's name and pronoun. This is presented through two screens that offer the choices through textual narrative. It goes something like this, with [brackets] marking the options that the player can currently choose between.

This is the story of...
[...Alice Aster.]
[...Alan Aster.]
[...Al Aster.]

It is...
[...her story.]
[...his story.]
[...their story.]

Detached from the wider narrative context, this method may seem clunky, but I believe it works within the game itself. Mechanically, that is. I'm less sure about the options that I'm offering.

The player can choose any of the three options in the first screen and again any in the second, regardless of what they chose in the first. This affects the player character's name and pronouns used throughout the game.

Now, there clearly are also many other pronouns that people identify with in English, just like there are many other names. However, for technical and design reasons, it would be challenging for me to have the player freely type in their preferred name or pronouns, and neither can I really present a long list of options. At the same time, by condensing all non-binary choices into the most common (?) "their" and by assuming that "her" also equates to "she" and so on, I wonder if I end up coming across as someone who thinks they are on top of things, but clearly has only a very superficial understanding of the topic. Which, to be honest, might not be that far from the truth.

Similarly, of the three names offered, "Al" is intended as a more gender-neutral or non-binary option than the other two. Does that make sense? Would there be a better way to handle this? Are there names that better signal non-binary or gender-neutral identity?

Or am I simply approaching this wrong?

The game itself does not deal with gender identity. As you can see, I'm not the right person to write about the topic. The choice of gender in fact has relatively little effect on the story itself. The player also has no choice over other matters of identity, including their character's cultural background or family structure. The character is not intended to be the player, but someone whose story the player follows. But it still feels important for me and for the story to offer a choice about the name and the pronoun. And I wouldn't be comfortable with it being just a "traditional" choice between male and female, as it would quite explicitly imply and reinforce assumptions about the world that I think we should move away from as a society.

Not that my game is of course going to change the world in any meaningful way. But having worked on it for about six years now, it has been one long personal learning experience for me. And this feels like another opportunity to understand something better.

Thanks in advance for any thoughts and advice.

(If there’s a better way to word this question, feel free to edit my title.) I’m interested in aspects of your self-disclosure that others are often surprised by or that they disregard as false/overblown/fabricated.

It can be anything, big or small. What is it and what is it like to have people disregard it so regularly?

Hi folks! I am, unfortunately, probably going to have to build a new PC soon; my beloved Thelio-r1 is slowly failing, and while my original plan was to buy a Ryzen 7 5800X and keep riding this PC for another three to five years, I don't know that I'll actually be able to make that work.

I like the NXT H510 I used for my boyfriend's gaming build, but the thermal performance isn't amazing and, most importantly, I hate tempered glass!

Yes, I understand that people want to show off their (ridiculously!) expensive components. I understand that lots of things have RGB. However, metal is cheaper, easier to work with, doesn't shatter, and I can modify it if I need to.

So, does anyone know of a good mid-tower PC case with decent airflow, up-to-date features (no 5 inch bays, good cable management hardpoints, a cable hiding bay, etc.), and no tempered glass or, preferably, acrylic?

Thank you!