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?

Pop-Up Event: Ludonostalgia!

Task: Replay an old, favorite game that you haven't played in a long, long time. Tell us about how your playthrough now compares to your memories of the game.

Time Period: This weekend! (November 10-14)
Update: Ludonostalgia is extending its hours through November 21st!

Have you watched any movies recently you want to discuss? Any films 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.

My child (who does not live with me) has a PC. He's pretty good at sorting problems out for himself, but he sometimes needs extra help. We've tried doing this over phone and video calls, and it's an unfun experience for both of us.

Is there a remote access software that would fit our needs? I want to be able to connect to his computer over the Internet and have some level of control when he's logged into his account. I'd need to be able to open files, I wouldn't have to be able to save them. He's using Windows 11. I think he's using the home version. I'm using Windows 10 Pro. We both have reasonably good Internet speed.

I wrote the following as a Twitter thread first but I think this idea could work for Reddit/Tildes/Mastadon and would love to know what you folks think of it.

Here is how I would monetize a social network that could work for Twitter.

First of all, don’t charge your most valuable users - the power users that create the content for you. Instead focus on the users that get more value from your system - the consumers of the content.

The idea is simple - introduce a small time delay before content gets seen from the time it is published. For example, on Twitter it could be 1 minute. On Reddit it could be 10 minutes.

Paid subscribers would have no delay. Importantly - lift the delay for the users that generate a lot of views.

You can do revenue share with your content creators in proportion to how much time paid subscribers spent on their content.

And you can also identify your most valuable audience - the paid subscribers. This will help prioritize content moderation decisions, identify abuse, and prioritize appeals.

The delay would allow you to prioritize which content needs to be indexed instantly (ie from creators that paid subscribers are following) and which you can process on a best effort basis - saving on production costs.

You can gift subscriptions to your friends and family.