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!

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?

In the 2000s I used to use a service called last.fm (originally called Audioscrobbler) that would track the music I listened to and give me recommendations based on that. It was able to give me some really great personalized suggestions, but that came at the expense of me handing over significant amounts of personal data.

In prioritizing privacy, I feel like I've stepped away from a lot of the big recommendation engines because they're tied to data-hungry companies I am in the process of disengaging with (e.g. Goodreads is owned by Amazon). I can still find stuff I like, but it's often the result of manual searching that turns up popular recommendations that work for me, rather than less well-known or acutely relevant things. last.fm was good at giving me less "obvious" recommendations and would find music I was unlikely to find on my own. I want that, but for all of my media: books, movies, etc.

There's a second concern in that I also feel like I can't trust platforms like Netflix, who seem to prioritize their content over that of other studios. Their recommendations feel weighted in their favor, not mine.

What I want is an impartial recommendation engine that gives me high quality personalized suggestions without a huge privacy cost.¹ Is this a pipe dream, or are there examples of this kind of thing out there?

1. I don't mind handing over some of my specific interest data in order to get good recommendations for myself and help a site's algorithms cater to others, as I get that's how these things work. I just don't like the idea of my interests being even more data for a company that already has thousands of intimate data points on me.

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?

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 get heavily into Universal Paperclips about a year ago, it really just scratched a particular itch in my mind. It was particularly nice to be able to play it at work and not need to worry about it being open 100% of the time!

What are your recommendations for similar idle/incremental games?

Prologue: Feeling cranky, trying to be civil.

I posted a link to an article, in the ~news, about two of the top US dairy producers declaring bankruptcy ... and Someone moved it to ~food.

Harumpf.

~food is "check out this new latte recipe" or "how to survive the vegetarian keto diet" (yes, that's a thing; I'm on it. May be why I'm cranky).

My post was ~news, about the US economy, shifting societal norms, potentially about climate change.

But forget about this specific categorization issue. This is the first time I've bumped into Tildes' moderation methodology.

I don't subscribe to ~food, so for me, my post just vanished, w/o notification or explanation. Took me a few minutes to find it. I don't see any way to ID who moved it (may well have been @Deimos, for all I know), nor any way to challenge the move.

Have I overlooked some 'moderation dispute' button, or some such? Or is moderation here beyond dispute?

ETA: For anyone visiting this post down the line, here's the official/original statement on this ...

https://tildes.net/~tildes.official/53r/users_can_now_be_manually_granted_permissions_to_re_tag_topics_move_them_between_groups_and_edit

For Christmas, I got the household a toaster oven with air fryer. We have so far done french fries and brussels sprouts, both of which turned out great. I'm curious what else I can air fry? Any favorite recipes?

It also has a dehydrate feature and we've done apple slices and strawberry slices. They also turned out pretty good. (I think I needed to leave them in for maybe an extra hour or two because they weren't quite crisp.)