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 topic is part of a series. It is meant to be a place for users to discuss creative projects they have been working on.

Projects can be personal, professional, physical, digital, or even just ideas.

If you have any creative projects that you have been working on or want to eventually work on, this is a place for discussing those.

Speculative fiction contains elements that don't exist in reality. It includes genres such as science fiction, fantasy, and supernatural horror.

A producer friend is looking for stories with a focus on LGBT issues. As someone with a predilection for speculative fiction, it would be great to read/watch some speculative stories that deal with issues in that area. I am aware of some stories with LGBT characters, but gender and LGBT issues are generally not the main themes. I'd love to get suggestions for movies, TV shows, and books (especially short stories) that deal with those issues in a proper and inventive way.

As usual, Wikipedia has an extensive list on the subject, but I was hoping to get some more personal suggestions from the Tildes crowd.

Thanks!

Pride month has already started, so - as per the title - what are you doing for Pride this week?

Are there any cool events where you live? Is the encroaching summer making it hard to choose between hugging the AC and ironing your flags? Are you still in the closet, and would you like to vent about it?

I don’t think best necessarily needs to mean most useful. For example though English, Mandarin, and Spanish are widely spoken they all have their problems, for example the reliance of Chinese on non-phonetic logograms or English’s complete mess when it comes to spelling and vocabulary.

I’ve been learning some Dutch these past few days and have been enjoying it quite a bit. It’s got a lot of the Germanic roots I’m familiar with without the junk and inconsistencies that seem pervasive in English.

Korean also seems like a potentially interesting “objectively good” language to learn since I believe the writing system was invented relatively recently (1950s?) and is phonetic.

All that being said, that’s pretty much all I know about linguistics so I’d love to hear peoples input on language and what they enjoy.

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!

Over the past few months I've been questioning my gender identity, and so I've been doing what any good millennial does and trying to read up on what everyone else in my position did and does. I've found a few resources here and there, but I'd really like to read/watch/listen to more if I can. I'm looking for blogs, YouTube channels, podcasts, twitter users, and possibly even music... Anything created by non-cis people and which discusses their experience with figuring out their gender identity.
Hopefully my fellow Tilderen can recommend some good media to me? I'd also be glad and grateful to hear any personal stories from folks here as well, though I do know it can be a very personal thing so no sweat if you don't feel happy sharing.

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.

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 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 - 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.