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.

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

I received my Steam Deck on June 6th and have used it literally every day since then. Here are some assorted thoughts that might be of value to people either waiting on theirs or on the fence about ordering:

The Good

• I had no idea until I got it that there's an official Deck test game: Aperture Desk Job. It's essentially a cute test/tutorial for the Deck's controls, set in the Portal universe. Takes about half an hour, but it's a fun onboarding for the device.
• On the past two Saturdays, I have woken up and played Vampire Survivors with one hand while I held my morning coffee in the other. This is the way.
• The control remapping options are absolutely incredible. It is a very robust system. Even simple fixes (like putting A on a back paddle so I can play Vampire Survivors one-handed) can make a world of difference.
• I haven't run many heavy games on it, but I started up Bugsnax, and it was keeping a solid 60 FPS and looked great.
• Emulation on the device is a dream. I haven't done anything past OG PlayStation games yet, but the power of the device, the robust control customization, and the ease of installing emulators (adding Flatpaks in desktop mode) make this absolutely ideal for revisiting older consoles. I've spent probably 80% of my time on the device in PSOne games.
• Battery life is fine, but I don't really use it. I bought a long power cord and spend most of the time with it plugged in on my couch since it has passthrough. I thought the cord sticking out the top of the device would bother me, but it hasn't really been an issue.
• Game selection is increasing steadily (1700+ verified games currently). If you're buying it to play specific games you might be disappointed, as there's still a lot that doesn't work. If you're buying it for games in general though, there is plenty to keep you occupied.
• The grips are MUCH more comfortable for bigger hands than standard Switch joycons. Those would always cramp my hands, but the Deck feels natural and comfortable.
• The middle of the device gets warm to the touch during gameplay, especially on more demanding stuff, but the grips remain cool and you won't feel the heat at all unless you specifically move your hands to the back middle of the device.

The Bad

• The paddles on the back are a little awkward, and I accidentally click them more than I like. In most games they're not mapped to anything so it's fine, but in emulators I use them for save states. I had to set them to respond to long presses only so my accidental clicks didn't mess things up.
• The software is... still getting there. I get navigation issues on store and profile pages frequently, along with frequent UI lag. It's a bit unpolished at the moment.
• Don't know if it's specific to my hardware or a software bug, but sometimes it won't log me in to my Friends list and the only fix is a reboot.
• I wish the control sticks had deeper indents for your thumbs. They're pretty flat, and my thumbs tend to slip off on stick-focused games (most noticeable on my right (aiming) thumb during 20 Minutes Till Dawn).
• Bluetooth headphones have to be manually reconnected in the Settings menu each time. No idea why this is, but it's a bit of an inconvenience.
• Mid-game suspending is still clunky. I don't really do it, as I don't trust that it'll save like it should. It also still counts playtime while suspended but seems to have a rollback feature? I put the device to sleep with a game open that I'd played for 20 minutes and came back to it saying I'd played it for 3 hours. The playtime ended up dropping back down to 20 minutes, but only after I restarted the device.

The Ugly

• There isn't any ugly. I absolutely love this device. Despite my nitpicks above, I think it's nothing short of splendid. I'm more excited about this than I've been about anything in videogaming in a long time.

If anyone has any questions, ask away! Also if any other people here have their Steam Decks and want to chime in with their experiences (@Autoxidation), go for it!

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?

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.

As discussed and suggested here.

What are you learning? How is it going? Share your progress, tips and tricks. Ask other learners questions.

Writing in non-English languages is welcome in this thread if you want to practice, but please at least include a Google Translate or Deepl translation in a foldable paragraph, using <details>[your translation]</details>

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, 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!

Note: there's a number of disclaimers I feel I want to include regarding "miracle" diets, direct-to-consumer businesses, health benefits/risks of dieting, etc but it'd get too long to put them up here. I'll add a comment with that stuff. Also, no one is paying me to say anything here.

I decided to write about my experiences with different low calorie/diabetic-friendly/keto food options. Let me know if this is at all helpful to you :)

Magic Spoon

This is that unavoidable direct-to-consumer business; you may have been bothered w/dozens of promo codes for their cereal across various podcasts, YouTube videos, and Twitch streams. I have been on a ketogenic diet for a long while (and have had success with it*), and saw that Magic Spoon is low carb and comparably low in calories compared to other sugary cereals.

I bought a variety pack with 4 boxes for ~$40 including shipping w/promo code. $10/box is pricey, but since I used to be a cereal lover, I figured it might be worth having it to scratch the itch. All of these I had with Blue Diamond Almond Breeze Unsweetened Almond Milk (<1g carbs.) I can't really tell a flavor difference between almond milk and low fat milk. Whole milk sells for about $3 in my market where as almond milk is about $4. Note: I am easy to please, I definitely don't have a "refined" palate. Now to the boxes:

Peanut Butter

I think maybe my expectations were off for this. I'm not a sommelier, so I'll describe flavors best I can in common folk language. This is just not good. At all. The taste is peanut-buttery, but has an overwhelming salty flavor. There's also this off-note that tastes like artificial sweetener. Texture-wise really adheres to your teeth. I finished the bowel, only because I didn't have enough time to pour a new one before work. It's been a few weeks, and I still haven't touched the box (aside from a small bowel to write this review.)

Rating: 1/5

Fruity

I had pretty low expectations from the previous box, and some anxiety about having potentially wasted $40 on food I won't eat. The smell when I opened the box was immediately that of fruit loops. I noticed the shape of the cereal was the same as the peanut butter ones. Fortunately, these didn't glue themselves to my teeth in quite the same way that the PB flavor did, but I still used my tongue to dislodge it from a couple of molars at the end. This tasted quite close to fruit loops, but overall is a unique flavor. I quite enjoyed this flavor. This cereal can sit in the bowel for some time before becoming soggy; a good quality since I typically take my time and browse Reddit/HN in the mornings while slowly working on a bowel of cereal before work. Flavor is a half-step down from fruit loops, but a step up in consistency.

Rating: 4/5

Frosty

When I tried this, this was the best keto cereal I've tried. I'd say it's the best cereal I've ever had, but that title still belongs to Reese's Puffs. It's hard to describe the flavor, something like Lucky Charms if you had a high-number of mash-mellows, but far more substantial. It isn't an especially complex flavor; it's just a "frosted" flavor that seems perfectly balanced in both flavor and consistency. Following the trend of other cereals, it doesn't get soggy fast, which I appreciate. Doesn't really get stuck in the teeth.

Rating: 5/5

Chocolate

This will be a short review: not great. It tastes like Cocoa Puffs, if they very obviously had substituted artificial sweetener for sugar. Maybe that's your thing, but I wasn't a huge fan of Cocoa Puffs in the first place. Not offensive, I'll probably finish the box when I run out of other things to eat, but not great.

Rating: 2/5

Conclusion

This scratches that craving for cereal that you miss out on when you go on a low carb diet. If you are on keto, you should note the cereal is relatively high in protein (around 13g per cup) where total fat is only 8g per cup. I'll probably purchase again, but I'll do a custom bundle next time w/fruity, 2 frosty, and maybe a different interesting flavor as a fourth.