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.

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've seen a few posts about the Framework Laptop on Tildes and since I received mine, I thought I'd do a write up for it.

I've been using the Framework laptop for a few weeks now and it's been great so far. I was originally skeptical but I decided that I would take a shot at it as I've been growing increasingly unhappy with the design decisions that Apple has been making with MacOS.

I ordered the DIY kit, which was nice since I already had an NVMe SSD I could use with it, so I ended up saving about $150. It only took about 20 minutes to get the RAM, SSD and wifi card installed.

Specs:

• Intel i7-1165G7
• 32 GB of RAM
• Intel WiFi 6E card

Total cost: $1,422.03.

Unfortunately my first laptop arrived with a dead display. The Framework support team was pretty helpful and quickly sent out a new one, which works perfectly.

After toying around with Linux Mint and a few other distros, I ended up installing the Windows 11 beta. Getting the drivers installed was easy, since Framework offers a single download that runs one script to install all necessary drivers in unattended mode. Just hit one button and restart - all the drivers are installed. I wish all manufacturers offered something similar.

Overall construction is great. For something as modular as this, it feels extremely solid and well built. While the build quality isn't equal to something like a MacBook, I'd say it's on par with a Dell XPS or similar high end machine.

The screen is nice and bright, with accurate colors. I've always been a fan of 3:2 screens on laptops and moving from a MacBook Pro with a 16-inch 16:9 display to the 13.5-inch 3:2 display on the Framework doesn't feel like losing too much real estate. Having the taller display is great for sites like Tildes, where it can fit almost the same amount of content as a much larger screen.

The keyboard and trackpad are both great. The keys remind me of the older pre-2015 style MacBook keyboards before they switched to the butterfly mechanism. They are bouncy and responsive, with a nice feedback that doesn't feel too harsh like the butterfly keyboards do. The trackpad is pretty good and it uses the Windows Precision drivers, so it supports swiping and pinching if you like that. It does sound a bit louder than my MacBook Pro's trackpad.

The speakers are a bit disappointing. The max loudness is pretty anemic. Even in a normal acoustic environment (A/C running in a house), you have to actively listen to hear. Coming from a MacBook Pro 16-inch, I would say that the speakers are the biggest downgrade.

The main draw of the Framework is the expandability and upgradability.

The Framework modules are a fantastic idea and I love them. While they don't save you from having to carry around adapters, it is really nice to have those adapters slot in to your machine and feel more integrated. I purchased 2 USB-C, 2 full-sized USB, a DisplayPort, and an HDMI adapter. Being able to just slot in a USB A port and swap it for a display out one on the rare occasion that I need it has been great. I love being able to adapt the ports on my laptop to a situation without having to have dongles coming out of the side of my laptop.

The adapters are tiny and easily fit in any backpack or carrying case. I'm really curious to see what new adapters they offer in the future and what crazy niche ones third parties come up with. I'd love to see a cellular modem jammed into one of these things. Or maybe one that can hide a dongle for my wireless keyboard and mouse?

Battery life is...fine. It's an all day machine, but you'll definitely need to charge it every day if you're using it a good deal. The battery is on the smaller side, but it gets me through a normal work day so that's good enough. But when the battery goes bad (as all Lithium-Ion batteries do), it's an easy fix.

In terms of upgradability, getting into the laptop is dead simple. There's five screws on the bottom and then entire top deck (keyboard and trackpad) comes off. Everything is easily accessible and sensibly laid out. It's also all labeled with QR codes that take you to specific guides on how to install/upgrade those components. I think the educational component is great. It really shows people who would have never thought to upgrade their RAM or storage how easy it can be.

That's the big selling point for me. If I decide in a year or two that I need more than 1TB of storage, I can just buy a larger drive and stick it in there. Or if my display dies, I can get a one for a lot less than the cost of replacing the laptop. Or if the keyboard or trackpad dies, then I can easily replace just that component. On my MacBook Pro, replacing the keyboard is an $800+ repair, since it involves replacing the entire top case, which includes the motherboard and other expensive components.

For years we've been hearing from manufacturers that they can't make a laptop thin, light and upgradable. This laptop proves them wrong.

My biggest concern is the long term viability of the company. It's nice that they made an upgradable laptop, but if they aren't around in a year or two to keep selling replacement parts, then it doesn't matter much.

Overall, I'm pretty impressed with the Framework and I plan on keeping it and making it my daily driver.

EDIT: I forgot to mention my absolute favorite feature, one that I've missed ever since Apple went all USB-C on their laptops: It has a light on the side to tell you if it is currently charging or fully charged!

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 have never been in the military, nor wanted to. I assume a great degree of hardship is required in military life, but I wonder what everyone thinks of the exaggerated, highly theatrical shouting and demeaning language used on recruits. Does that actually make someone a more apt soldier? Does that really prepare them for difficult/tough/combat situations?

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!

What is this?

Your "backlog" is all those games you've been meaning to play or get around to, but never have yet! This event is an attempt to get us to collectively dig into that treasure trove of experiences!

How do I participate?

Choose a game (or several) from your backlog and play it/them. Then tell us about your experiences in the discussion thread for the week! If you're not sure what you might write, take a look at a previous backlog post or our previous Backlog Burner event in 2020 to get an idea. Also if you want to keep track of statistics across the whole event or anything else like that, go for it!

Do I need to finish the games I play?

Nope! Not at all. There aren't really any requirements for the event so much as this is an incentive to get us to play games we've been avoiding starting up, for whatever reason. Play as much or as little as you like of a given game. Try out dozens for ten minutes each or dive into one for 40 hours. There's no wrong way to participate!

What's the timeline?

I will post an update thread weekly, each Tuesday, for the four weeks of February. At the end of the month, I think it would be neat to tally how many collective games we all removed from our backlogs, as well as what the best finds were from our collective digging into our libraries. I expect we'll turn up some good hidden gems, as well as interesting insights.

Do I need to sign up?

You don't have to do anything to officially join or participate in the event other than post in these threads! Participate in whatever way works for you. Also, because this is ongoing, it is okay to make more than one top-level post if you're updating the thread with new information.

Do I need to wait until February to get started?

Nah. I figured people might want to begin over the weekend, which is why I'm posting the announcement now! The first official discussion thread will go up on Tuesday, but feel free to kick things off here if you're wanting to pre-game the month!

Let's burn through these backlogs!