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?

The Emmy’s are happening right now. I’ll put the winners here as they’re happening.

Lead Actor Limited Series: Michael Keaton - Dopesick

Supporting Actor Limited Series: Murray Bartlett - The White Lotus

Supporting Actor Drama: Matthew McFayden - Succession

Supporting Actress Drama: Julia Garner - Ozark

Supporting Actress Comedy: Sheryl Lee Ralph - Abbott Elementary

Supporting Actor Comedy: Brett Goldstein - Ted Lasso

Variety Sketch Series: Saturday Night Live

Variety Talk Series: Last Week Tonight

Supporting Actress Limited: Jennifer Coolidge - The White Lotus

Lead Actress Limited: Amanda Seyfried - The Dropout

Competition Program: Lizzo's Watch Out For The Big Grrrls

Limited Directing: Mike White - The White Lotus

Limited Series Writing: Mike White - The White Lotus

Variety Special Writing: Jerrord Carmichael

Lead Actor Comedy: Jason Sudeikis - Ted Lasso

Comedy Series Writing: Abbott Elementary

Drama Series Directing: Squid Games

Lead Actress Drama: Zendaya - Euphoria

Lead Actress Comedy: Jean Smart - Hacks

Comedy Series Directing: MJ Delaney - Ted Lasso

Drama Series Writing: All The Bells Say - Succession

Lead Actor Drama: LEE JUNG-JAE - SQUID GAMES

Limited Series: The White Lotus

Comedy Series: Ted Lasso

Drama Series: Succession

My initial reaction to cloud_loud's post about the upcoming Winnie the Pooh slasher movie was viscerally negative - my gut feeling is that my life would be objectively better without a movie like this in the world tainting a treasured childhood memory for millions of people.

Then I thought back to my reaction to the Wednesday Addams trailer and it became immediately clear to me that it was just a 'me problem' - I had no sentimental ties to the Addams Family as a kid, but Winnie the Pooh was one of my mum's bedtime story staples. I trust Tim Burton based on his track record to bring a high-quality rendition of Wednesday to the screen, but these nameless & faceless filmmakers were suddenly antagonists in my mind for turning an innocent story about a talking teddy bear into a trashy slasher. But apples & oranges comparison aside, just like how there will be people against the idea of Burton's vision of the Addams family or Tom Hanks' portrayal of Mr. Rogers, there most likely will be people who enjoy this movie when it releases - it just won't be my cup of tea.

I then started thinking about the implications of franchises reaching public domain like in this scenario - for better or worse, creators can now build upon, remix or bastardize the world and characters of Winnie the Pooh. I recently had a conversation here on Tildes about the necessity of copyright, patent and intellectual property law where @archevel raised the question of whether a person/entity should be able to 'own' an idea, and on the surface the immediate answer is a resounding "no". But thinking deeper about it (especially in this context) pushed me down a different path, calling someone's creation simply an 'idea' is very reductionist. To me, an idea is 'a honey-obsessed talking teddy bear' - there's no characterisation to that, no soul, no story, no sense of being. An idea is a I-V-VI-IV chord progression (and thus holds no legal protections), but shouldn't the artistic integrity of Journey's Don't Stop Believing be protected even after the creators are gone? Why are we so indifferent towards parodies like this when it could just as easily be something more offensive like this that can harm the legacy of the creator just by association? I've always been a proponent of free speech/freedom of expression but thinking about it from this perspective is fascinating to me.

That's not inherently an issue of something becoming public domain though, it's an issue of preserving the creator's legacy. Copyright doesn't just protect the creator's means to compensation, it protects their right to control their creations - the right to control their artistic integrity and the legacy they leave behind. Knowing that Milne and Shepard created Pooh to entertain children in a wholesome way, I think it's fairly safe to say they would not be happy with a slasher adaptation if they were still alive. If these filmmakers were using Pooh's likeness to parody Xi Jinping and push a communist agenda, would we care more about preserving Milne's legacy then?

All that brought me to the question of decency - whose moral compass should we guide ourselves by? Where is the line between socially-acceptable satire and obscenity? Western culture has been extremely cagey about some of the most natural things like nudity and sexuality, but here in Australia our government has no issue plastering billboards, bus stops and cigarette cartons with images of nicotine-stained teeth, abscessed mouths and diseased organs in an attempt to warn people of the dangers of smoking & excess sugar consumption - all in the name of public health. Everybody has genitals, why is our government happy to tell us that seeing boobs on a billboard could be potentially shocking for children to see when kids are exposed to NSFL images just by walking past the cigarette shelf in a store or a discarded carton in the street? When our cultural morality is so cagey about something as innocuous as a natural human body, why are we so unconcerned when someone perverts the life's work of a creator just because it's turned public domain? Should the creator have the right to protect their work from beyond the grave?

I'm willing to bet when Mickey Mouse turns public domain in 2024 the internet will be flooded with Beeple-style grotesqueries (NSFW) and everyone will get sick of profane parodies very quickly.

Just wanted to post a frame-by-frame analysis of the philosophical rabbit hole I went down today and hopefully stir up a conversation - I know these are fairly deep questions that none of us can really answer definitively but I still love to hear different people's thoughts and perspectives regardless :)

IMDb Link
TheTVDB Link

Has anyone else here watched this? If so, I would love to hear your thoughts.

I just finished it and am sorting through how I feel about it, especially after that final episode. I’ll type out longer thoughts in a comment once they’ve settled.

I'm starting to get tired of being complacent about the fact that I am using Google's services when I'm well beyond the 'reasonable doubt' phase of Google being evil. They're a giant monopoly and I want to stop making them money as much as I possibly can.

Thankfully, I'm not as badly intertwined with them as I could be; I have already downloaded all the music I bought from them and since I have switched to iPhone, I'm not reliant on too many of their services. They do have some of my old files and pictures, but that shouldn't be too hard to get out. The biggest problem I can see is my email. Right now I'm actually paying $4/mo for an Amazon WorkMail account for a failed venture (which I'm planning on getting rid of), but I'm sure there are much better alternatives out there. I'd prefer something that has good spam filtering options including custom filtering. I was also wondering if anyone would recommend Apple's email service since I'm already paying for iCloud+ to store my backups.

Another more specific recommendation I need is for a replacement to Google Authenticator that works on iPhone. It looks like there are several options but I'm frankly not sure how to evaluate them.

If you have any other resources you'd like to share, please feel free to share.

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!

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.

I’m a solo freelance programmer and want to write an app for internal project management, somewhere I can add projects, milestones, tasks, etc. and track them as I work on them, occasionally remind me of things like take a break, lunch time, etc. and over time I can track on which category I worked how many hours, etc.

I’m actually confused between whether to build this as a Web or Windows Desktop app. I’m considering latter because it can run efficiently on my laptop in the system tray using least memory and resources, web-based on the other hand will force me keep running an apache server too which will be an overhead (unless I host it on Google Cloud or someplace which might be an option?)

The only reason for considering web-based is that eventually I’m planning to make this tool open source and with web-based, many others can find this useful too (including OSX/Linux users). At that point, I may consider expanding its schema to include multi-user connectivity, client login, etc. but that’s going too far at this point!

The idea is that this tool should be useful not just for me but other freelancers, students, etc. who might be in my shoes. From that perspective, what do you think is the right technology to use? Web based or Windows based?

(I’ve extensively worked on C#/WinForms projects before and I’m thinking Visual Studio Express for desktop development. If web-based, it’ll be php/mysql based)

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!