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.

These are the real nominations, not my predictions. Here’s the article about it:
https://www.indiewire.com/2022/11/2023-independent-spirit-award-nominations-1234784758/

Best Feature

Bones and All

Everything Everywhere All At Once

Our Father, the Devil

TÁR

Women Talking

Best Director

Todd Field, TÁR

Kogonda, After Yang

Daniel Kwan and Daniel Scheinert, Everything Everywhere All At Once

Sarah Polley, Women Talking

Halina Reijn, Bodies Bodies Bodies

Best First Feature

Aftersun

Emily the Criminal

The Inspection

Murina

Palm Trees and Power Lines

Best Lead Performance

Cate Blanchett - TÁR

Dale Dickey - A Love Song

Mia Goth - Pearl

Regina Hall - Honk for Jesus, Save Your Soul

Paul Mescal - Aftersun

Aubrey Plaza - Emily the Criminal

Jeremy Pope - The Inspection

Taylor Russell - Bones and All

Andrea Riseborough - To Leslie

Michelle Yeoh - Everything Everywhere All At Once

Best Supporting Performance

Jamie Lee Curtis - Everything Everywhere All At Once

Brian Tyree Henry - Causeway

Nina Hoss - TÁR

Brian d’Arcy James - The Cathedral

Ke Huy Quan - Everything Everywhere All At Once

Trevante Rhodes - Bruiser

Theo Rossi - Emily the Criminal

Mark Rylance - Bones and All

Jonathan Tucker - Palm Trees and Power Lines

Gabrielle Union - The Inspection

Breakthrough Performance

Frankie Corio - Aftersun

Gracija Filipovic - Murina

Stephanie Hsu - Everything Everywhere All At Once

Lily McInerny - Palm Trees and Power Lines

Daniel Zolghardi - Funny Pages

Best Screenplay

After Yang

Catherine Called Birdy

Everything Everywhere All At Once

TÁR

Women Talking

Best First Screenplay

Bodies Bodies Bodies

Emergency

Emily the Criminal

Fire Island

Palm Trees and Power Lines

Best Cinematography

Aftersun

Murina

Neptune Frost

Peal

TÁR

Best Editing

Aftersun

The Cathedral

Everything Everywhere All At Once

Marcel the Shell with Shoes On

TÁR

Robert Altman Award

Women Talking

Best Documentary

A House Made of Splinters

All That Breathes

All the Beauty and the Bloodshed

Midwives

Riotsville USA

Best International Film

Corsage

Joyland

Leonor Will Never Die

Return to Seol

Saint Omer

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.