This topic is part of a weekly series. It is meant to be a place for users to discuss their week.

If you have any plans, goals, accomplishments, or even failures, whether they be personal or work related, I'd love to hear about them. This is a place for casual discussion about your week, past, present, and future.

A list of all previous topics in this series can be found here.

So, what (or how) are you doing this week?

EDIT: Latest update

This is something so rudimentary that I'm a little embarrassed to ask, but I've also tried looking around online to no avail. One of the hard parts about being a Linux newbie is that the amount of support material out there seems to differ based on distro, DE, and also time, so posts from even a year or two ago can be outdated or inapplicable.

Here's my situation: I'm a newbie Linux user running Pop!_OS 19.10 with the GNOME desktop environment. Occasionally, games I'm playing will hard crash and lock up my system completely, leaving a still image of the game frozen on the screen indefinitely. The system stays there, completely unresponsive to seemingly any inputs. It doesn't happen often, but when it does it's almost always when I'm running a Windows game through Steam's Proton layer. I suspect it also might have something to do with graphics drivers, as I'll at times notice an uptick in frequency after certain updates, though that might just be me finding a suspicious pattern where none exists.

Anyway, what I don't know how to do is gracefully exit or recover from these crashes. No keyboard shortcut seems to work, and I end up having to hold the power button on my computer until it abruptly shuts off. This seems to be the "worse case scenario" for handling it, so if there is a better way I should go about this, I'd love to know about it.

EDIT: I really want to thank everyone for their help so far. My initial question has been answered, and for posterity's sake I'd like to post the solution here, to anyone who is searching around for this same issue and ends up in this thread:

• Use CTRL+ALT+F3/F4/F5/F6 keys to access a terminal, where you can try to kill any offending processes and reboot if needed.
• If that fails, use ALT+SYSRQ+R-E-I-S-U-B.

With that out of the way, I've added more information about the crashes specifically to the thread, primarily here, and some people are helping me out with diagnosing the issue. This thread is now less about the proper way to deal with the crash than it is about trying to identify the cause of the crash and prevent it in the first place.

I didn't know tildes has trending topics.

I'd either pick the rise of the bolsheviks in Russia (You can replace them with the mensheviks, who wanted to abide by democracy.), The division of the HRE (A united germany in 900CE would be very consequential.) And the rise of the hapsburgs in what would be Austria-Hungary, since it meshed a dozen linguistic groups together.

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!

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.

I was chatting with a friend today and this question came up - I drew a complete blank.

Aside from a few foreign movies retranslated into a completely different context, like Seven Samurai and The Magnificent Seven, most remakes don't even approach the quality of the original, for my tastes.

Please enlighten me if you're aware of any superior, or even equivalent remakes that tell roughly the same story with the same characters.

As far as "vice" is concerned, do any of you draw the line somewhere? For example, has anyone here been to a strip club? Paid for sex? Engaged in recreational use of illegal drugs? Gambled?

I was inspired by this post and was wondering where ya'll stand.

In an attempt to get somewhat back into shape, I've recently taken up meal prepping again. I love cooking but my previous job was ~60 hour weeks, and some things had to be sacrificed because there just wasn't enough time in the day. However, I have a somewhat more normal job now and I can get back into the things I love(d) to do.

I made some teriyaki salmon and veggies for the next week: https://imgur.com/a/GCFPeJS

Recipe: https://www.lecremedelacrumb.com/one-pan-baked-teriyaki-salmon-and-vegetables/

I'm not good with fish and I rarely try to cook with it (landlocked state so it's hard to get it fresh), l but I found that fish-based dishes very generally tend to be healthier and dairy-free (lactose-intolerant).

What are your favorite foods to prep for a week? Got any recipes? Any tips for a fledgling beginner?

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?

Today I went to my favorite bakery/cafeteria/restaurant/grocery store (yeah it's one place, but not large enough to be considered a supermarket - IDK the correct terminology in English but you get the gist). It's a nice place if a little pricey. About a month ago, they installed a gate. Next to the gate, there's a huge metal thing with a single red button. When you press the button, it tosses an electronic ticket (that stores every purchase you make in the system) and the gate lets you go through. These are not synchronous, sometimes the gate is unlocked a lot sooner than the ticket is tossed. So today, after I got into the store, an employee had to run towards me to give me my electronic ticket. Okay.

I noticed that, despite the machine having only one very big button, lots of people still need to be instructed by the employee in order to enter, and he's constantly manually handing out the tickets. There is also a gate to leave that slows things down.

In this last month, I went a lot less to this place. That's because, whenever passing by, I used to enter just to check things up, see if there was something new or appetizing. You know, impulse buys. The need to check myself in and out (even when I don't purchase anything) made me quit that habit. I think other people are the same. Besides, what's the good of automation if it requires a human being to make it work correctly? AFAIK, the analog system worked. And we're not in a dangerous part of town where one needs to worry about people putting products in their pockets.

That's why I say: sometimes, there is such a thing as too much technology.