• What's something you wish people would take more seriously?
• Why do you think many people downplay, overlook, or deride it?
• What are the potential upsides or advantages to changing people's minds on this issue?
• Are there any potential downsides?
• What are the downsides caused by people failing to take it seriously?
• What do you think is the best way, if any, to get people to take this issue more seriously?

Answers for this question can be anything, and they don't have to be broad, something-that-affects-everyone things like the coronavirus or climate change. This can also be stuff that's specific to your field, societal norms, health habits, technology, entertainment -- whatever you think is relevant to the question.

Also, due to the nature of the question, please extend the principle of charity to people in this thread. People will likely be answering from a place of frustration. Keep that in mind when choosing how to respond to them!

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?

Firaxis just announced a new addition to the XCOM series in the form of XCOM: Chimera Squad. It takes place 5 years after the events of XCOM 2 and focuses on a specific squad of named human and alien characters trying to maintain the peace in a one of the new cities.

Game Reveal Trailer

Gameplay Trailer

It's currently $10 on steam, presumably since it looks like it was built on the XCOM 2 engine. The sale lasts until May 1st, so you'll have time to wait until some reviews are out before you buy it.

I absolutely loved XCOM 2: War of the Chosen, so this is a nice surprise for me. Some of my friend who have played some of the older XCOMs are comparing it at least thematically to XCOM: Apocalypse

Edit:
@cwagner provided a link to GMG where its currently $9.50

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.

This thread is posted daily, and is intended as a place for more-casual discussion of the coronavirus and questions/updates that may not warrant their own dedicated topics. Tell us about what the situation is like where you live!

I'm now T-1 to 2 days from having my sourdough starter that was created from nothing but natural yeast around where I live (and obviously generous amounts of flour or water) to being ready to bake/cook with. This is my first time working with starters, and dough in general, so I'm really looking forward to baking my own sourdough bread in the oven, or making a classic sourdough pizza with mozzarella and a marinara sauce (this is first on the list!).

I've been feeding it twice daily for several days now, and am getting close to the doubling-within-a-day metric many use as a baseline for when it's "ready", although I haven't tried the float test quite yet It's got an almost fruity, alcoholic aroma to it—with no funky, displeasing notes.

Here's the first recipe I'm planning, unfortunately our oven barely goes above 500°F, and I don't have any handy sources of thermal mass to properly cook a pizza, so I'm hopeful a cast-iron approach to really crisping the base on the stove first will pay dividends.

Seamus Blackley has also been a bit of an inspiration.

Anyone got any tips? Recipes to share? Surely I'm not the only person on Tildes trying this (for obvious reasons).

My mother is 65+ years old and loves everything Apple, but whenever I need to touch her computer I find myself questioning that choice.

The degree to which Apple abstract things from the user enables the most absurd behaviors. macOS gives little indication about which programs are open, and the red x on the top left corner just closes windows, not apps. Because the session persistence is so robust, the consequence is that my mother's Macbook Air keeps 12+ programs and their states open at all times literally for months. Every time she comes over from another continent, I close a bunch of stuff and get her an instant performance boost. Plus, she's never really sure if a program is open or not.

The concept of (work)Spaces, as well as the launchpad, spotlight, or even how Finder really works is beyond her. Because of her over-reliance on the dock, she never enabled autohiding, so her screen real state is always crowded.

Folders are entirely immaterial for her. Everything goes to "Downloads" with no organization whatsoever, and she's always looking for stuff "manually" by reading the filenames.

Her machine is running Mojave, and right now I can only see that finder displays two "Libraries": Documents and Downloads. Linux and Windows have Videos, Downloads, Music, etc. Those are easy to make sense of. What's the supposed Mac alternative? Buy stuff on iTunes. Well, if something is not on Amazon Video or Netflix my mother is a pirate like me (hehe), so she never made sense of it and I truly despise using iTunes for doing anything at all. She also downloads a bunch of media related to her job.

I'm not saying macOS is bad, I'm just asking: is it really the best choice for non-technical older people?

So, tonight as I was putting my young kid to bed, they listed every one of the places that they desperately want to go to, but can't. It broke me. This playlist is very much still a work in progress, but if you've been curious how things sound in my head when I'm working through some shit, it's a lot like this.

Videos were selected when possible, and I'm going to warn you: There's a ton of depressing shit in these videos. If you can't handle real videos of violence right now, I'd suggest moving on.

This playlist is best paired with a strong drink, deep feelings of sadness and anger, and a dash of mental instability.

Existential Crisis Playlist

1. Prophets of Rage - Hail to the Chief
2. KMFDM - Paradise
3. WAKRAT - Generation Fucked
4. Straylight Run - Hands in the Sky
5. Alexisonfire - Sharks and Danger
6. A Perfect Circle - So Long, And Thanks For All The Fish
7. Pink Floyd - Mother
8. William Shatner - You'll Have Time
9. Monty Python - Galaxy Song

I've been thinking about the feasibility of defining a language spec that can both be compiled and interpreted lately. I first thought about it while writing code in crystal, which, for the unfamiliar, is a compiled language based heavily off the syntax of an interpreted language (ruby).

Here are a couple reasons I find the idea interesting:

• It effectively neuters the interpreted/compiled language debates. Why just choose one, when both have such big upsides?
• You could develop a program in the interpreter with the same playfulness as you get in a shell, and then compile it into a speedy 'lil thing!
• It would be wonderful for metaprogramming! From my experience, languages usually define a little janked together syntax for compile-time execution. If the language had an interpreter for itself within the compiler, you could metaprogram and program in the exact same language.

I'm curious if any languages like this exist, or if you can think of more benefits.

Edit:
I just want to mention that my reference to 'feasibility' earlier is not born of disbelief - you can write a compiler or interpreter for any (to the best of my knowledge!) well defined formal grammar with enough effort. I suppose I left that word there to account for the fact that I might have unknown unknowns here.