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?

Hey guys,

I am kind of out of touch with the Anime scene these days, and as the title says... What should I watch on Crunchyroll?

All genres are a go, I will try anything, but I do tend to prefer your classic fantasy/sci-fi esque action types. I watched Claymore a few years ago and loved it, Hellsing, Tri-gun, Cowboy Bebop, etc.. So just drop some good recommendations if you don't mind.

Edit: Thank you to everyone posting suggestions! It is appreciated.

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 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.

Let's say I want to draw/paint things like this: 1 2

Think black/death metal album covers, medieval renaissance, dark/sci fi scenarios.

I know this takes years of practice and I just want to do these as a hobby.

I am just lost to where I start. Just pen and paper and focus learn how to draw people first? Is there any online courses/resources?

The second thing is I don't want to spend money so I won't learn to do these with oil or any real world material. If I do commit to the hobby with pen and paper, I will go to digital (drawing tablet + Linux/krita) and stay on that forever.

It's the same with guitar. I play guitar for years and I'm settled for life with a nice guitar + mid priced digital pedalboard with nice effects/simulations (ampero II stomp) and a 1x12 flat speaker cabinet. No more purchases.

Aiming this question at parents mostly.

I'm about to be a dad in the next week or so and I obviously want to raise my son to be a good person. My father was/is an absent drug addict, so I have a good roadmap of "don't." But I saw very little in the way of "do."

Where is the line between being too authoritarian vs too permissive? What are your thoughts on gentle parenting? I don't want to trade "well-behaved" for "well-adjusted" or vice versa.

I'm also open to newborn advice since that's what I'll primarily be dealing with for the next little while, obviously.

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.

The vaccine antigen technology, developed by the University of Cambridge and spin-out DIOSynVax in early 2020, provided protection against all known variants of SARS-CoV-2 – the virus that causes COVID-19 – as well as other major coronaviruses, including those that caused the first SARS epidemic in 2002.

The studies in mice, rabbits and guinea pigs [...] found that the vaccine candidate provided a strong immune response against a range of coronaviruses by targeting the parts of the virus that are required for replication.

Professor Jonathan Heeney from Cambridge’s Department of Veterinary Medicine, who led the research, [said] “We wanted to come up with a vaccine that wouldn’t only protect against SARS-CoV-2, but all its relatives.”

https://www.eurekalert.org/news-releases/1002345

https://www.nature.com/articles/s41551-023-01094-2

So the discussion at https://tildes.net/~movies/1ar2/martin_scorsese_says_fight_back_against_comic_book_movie_culture_by_supporting_directors_like made me think about mainstream Hollywood way of movies versus - well everyone else? I am not even sure I like the term "arthouse" movies, because movies are movies regardless of the boxes we put them in, but for the sake of the argument movies that don't fall in the category of traditional mainstream storytelling. Is it just French artsy fartsy pretentious weirdness or is (quote) real cinema (unquote)?

I think my movie habits have been pretty average. I am not American, but most of what I have watched during my lifetime have been Hollywood productions. By a huge margin. In recent years I found myself going more and more bored with both movies and tv series from whatever the algorithms at the streaming services were pushing to me. Not that it was bad, just felt more and more like a product designed after a specific set of criteria aimed at my taste demographic. So I forced myself to break out of the bubble and watched movies totally outside my comfort zone with something I am sure the algorithms would never have recommended me. Started with movies by Kieslowski and Wong Kar-wai. And since then I feel like a whole new world of movies has opened up for me. Not that everything is magically great. There are still pretentious French movies that make me roll my eyes, but most of all it is something different. Story telling rules I thought couldn't be broken are thrown in the air and something completely unexpected appears on screen instead.

It takes some getting used to. I really struggled with a good deal of self-doubt whether I could actually understand these movies, because I have studied film theory or went to art school. At the end of the day it is really just about watching things intuitively and trying not to analyze everything or thinking about what things are supposed to mean, and be curious to why the movie does things that maybe the complete opposite of the film techniques I was used to from more mainstream movies.

This is not to bash at the Hollywood blockbuster way of filmmaking, because when that formula works - it really damn well works. But so can something completely different like Hlynur Pálmason's Godland, Haneke's Funny Games or Bujalski's Computer Chess - just to name a few of my recent very compelling movie experiences.

Tildetablers,

What board games, card games and whatnot have you been playing this week? Don't be shy, share those sessions!

For me it was a single game of Western Legends with expansions. I've played this game, sans expansions, a couple of times and have never really been blown way, but the expansion certainly helped and I enjoyed it a whole lot more.

The game sets you as a character in the wild west. It's a bit of a sandbox game: there are a bunch of things you can do and you have freedom moving around and doing them. You can hustle cattle, play poker, buy upgrades, prospect for gold, fight, steal, &c. You basically earn points by doing each of these things and working your way up various tracks to earn legendary points which are victory points.

The expansions added a whole frontier area to explore and added story cards, which are basically thematic events that give you goals to claim. I feel like extra board and story cards really improved the experience and immersion and it was much more enjoyable this time around. We also played two characters each, which may also have helped, as this made it possible to explore different strategies at the same time.

I'm still not massively impressed with the game, but I don't think I'll disappointed if it's suggested now. If I were forced to rate it I'd probably give it a 1.8/π.

So, everyone, what have you played this week? What did you think? What are you hoping to play next?