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?

I was stubbornly determined to get my new Yubikeys working for FIDO2 SSH on WSL, which led me down the road to compiling my own custom Linux kernel for WSL with HIDDEV and HIDRAW enabled.

This was my first time ever trying anything like this, and by the end of it I realized that it's not actually so scary to compile your own custom Linux kernel!

Have you ever compiled a custom kernel before? What was the sequence of events that led you to do it?

I have been running a DAKBoard on a Raspberry Pi 4 for almost 4 years now without any problems until recently following this guide IIRC.

About 2 weeks ago, DAKBoard started logging itself out and only shows a black screen with the time on it and the DAK logo in the lower right corner. If I go into the settings it will bring up the DAK page that shows I am not logged in. When I log in again it seems to work randomly for about 24-36 hours.

I'm running it in a kiosk mode browser on Raspberry Pi OS. I am using the free tier of DAKBoard.

Before I wipe the SD card and start over from scratch I was wondering if there were any suggestions? To be completely honest, it has been "set and forget" for the past number of years so I would like to make sure I'm not overlooking something pretty basic/easy.

On a side note: Has anyone had any experiense using the DAKBoard OS on a Pi? I don't remember it being an option when I set it up originally.

Thank you for any assistance and if you have any spare hardware laying around I'd highly recommend setting one up, my family finds it incredibly useful for the calendar function and a conversation piece when they notice different photos rotating in and out.

I'm a little late on this, admittedly. $dayjob is requiring us all to set up a pair of YubiKeys, and I'm using them for the first time and my mind is a little blown.

I was seeing articles about "passkeys" all summer, not really grokking what they were talking about, clinging to my usernames and passwords and 2FA codes coming out of 1Password, etc.

I just set it up on a few accounts today, initially as an additional 2FA source, but when I set them on GitHub, I saw for the first time how exactly they are used instead of the username and password and 2FA combo to log in, and it seems incredible to me!

For long-time YubiKey users: what are some cool things in the ecosystem that you would recommend looking at?

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 decided to set up automatic backup of my files from my phone and laptop to Backblaze B2. I didn't find a good solution to sync photos from my phone directly to Backblaze, so I decided to do the following:

1. Sync photos from my phone to my laptop using Syncthing
2. Back up those photos as well as other files from the laptop to Backblaze using Restic

Is this backup solution fine, or are there any issues with it?

Also, most of the stuff I need to back up, even on my laptop, are photos/videos. Is there a point in using Restic with it's deduplication and incremental backups for this use case, or should I just use Rclone directly? I'd assume deduplication won't save me much storage because photos generally don't have similar byte chunks, although I may be wrong.

I have been going over services for which I pay monthly in my business. I have 17 clients where I do unattended cloud backups as well as doing a backup that I hold onto myself. Overall I backup around 4TB of data. I'm looking at possibly changing cloud services as the one I currently use has progressively increased their fees. I understand the need to pay for a good, reliable service as it reflects upon myself , my business and the service I provide but feel there are more competitive companies out there.

None of this is for personal use and many cloud services are just that, personal use. These are all server (Windows and Linux) use cases.

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?

I've taken on the monumental task of scanning my family photo albums in and saving them to a NAS (plus cloud, of course). 1000+ photos in, and I had the great idea of also banging through the images with AI to clean them. Anyone who plays with AI knows it can be a little hit-and-miss. The tool of choice was GFPGAN and in some images it cleaned them lovely, others, not so much.

To help sort this out I'm looking for a side-by-side image viewer, similar to something simple like Gwenview, that allows me to look at the files and simply pick the better image. I'm not sure this software even exists after the exhaustive time I've been looking for it. I'm on Linux, so that may be the hindrance here. Brownie points if I can pick the better image, and it copies the file to a new folder to allow building out a mixed bunch of files from the two source folders.

Absolute worst case, I'm willing to put some money in a pot for someone to develop this very needed tool. Best case, if the software doesn't exist and they build it for timasomo.

Note: Tried XNView but it won't compare across folders.

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 was fortunate enough to grab a discounted 4090 while on my travels and just got everything installed. Already having a lot of fun pumping all my games to max settings, but I'm also interested in running generative AI stuff locally to really take advantage of all that VRAM.

Do you have any newbie-friendly Windows 11 software to recommend for getting started? Thanks!

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?

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?

I want to finally try NixOS and build a desktop OS from the ground up with sway, iwd, waybar, foot terminal, cmus, etc.

I'm not a developer, but I'm a seasoned Linux user. Used Gentoo for years, Void Linux and now I'm on OpenSUSE TW.

I'm finding all sorts of guides and it seems confusing. In the past there wasn't any mention of home-manager and flakes, now it seems there are these things. Those are all things I need to care about? Is it all configured in one file?