My personal picks would be the whole of Chinese history between the opium wars and communist rule (or the century of humiliation as it is called), and most especially the warlord era, given that this was effectively how European powers, Japan and many internal revolutionaries managed to bring down the greatest economy in the world to civil war and then total warlordism for 40 years. For a vague concept, my pick would be the great divergence, the period where the US and European nations rose above the rest of the world and became the predominant world powers and colonized most of it, along with the many potential causes of this.

Is there a good smartwatch/simile that monitors sleep and has excellent battery life (measured in weeks not hours)?

I use the Withings (ex-Nokia) Steel HR, but it … kinda sucks. The bluetooth pairings very often lose sleep data, it's very inaccurate, the reporting sucks for non-24s, and the leather bracelet is of very poor quality, keeps breaking.

I really don't care for the fitness/step tracking which, as someone else here put it, thinks typing on a keyboard or eating is a step.

I also briefly tried an Oura (https://ouraring.com/), but I never got it to work and had to send it back.

I also don't care much for any of those "sleep quality" trackers that try to detect if I snore and what not. I can do sleep studies in my own time, I just want to have accurate stats on whether and when I am asleep.

… essentially Cube 2: Hypercube. It's even written and directed by Vincenzo Natali, the man behind Cube. I didn't dislike it, in fact I liked it. But seriously, am I the only one who noticed that?

Also, Harrison Gilbertson has big Aaron Paul energy. Especially in the voice.

The first episode of the BBC/HBO adaptation of His Dark Materials, by Phillip Pullman.

Synopsis: Orphan Lyra Belacqua's world is turned upside-down by her long-absent uncle's return from the north, while the glamorous Mrs Coulter visits Jordan College with a proposition.

Trailer
Title Sequence

My husband and I are looking to do more with our Instant Pot in the coming year. The last thread we had on this topic was from 2018, so I figure we could use an update.

• What are your favorite Instant Pot/pressure cooker recipes?

Please link to the full recipe if possible!

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.

I sort of want to casually throw this discussion out there, because I feel like this is something people sometimes mention in the same conversations without agreeing on it's fundamentals. Especially when talking about sites, like Tildes, leaning too much towards one particular worldview.

What is the goal of having diverse opinions? Why do you think it is necessary or desirable? Is it for a practical reason, or for a more ideological/principal one? What is the barometer by which you measure whether or not the level of achievement of a such a goal? And do you think it could produce undesired secondary effects?

To perhaps give a concrete hypothetical: do you think Tildes would benefit from it if we had more members who are of the opinion that the Australian Bushfires were caused in large part not by Anthropogenic Climate change but by, deliberate malicious actors (arsonists)?

Or if you disagree with the example what would your hypothetical be?

This question popped up between my friends and I when we were discussing the possibilities of lab grown meat. When discussing lab grown meat, one of the arguments for it is that it is far more ethical to consume as it didn't originate from a living, conscious being. But if you replace the meat being grown in a lab to human meat rather than fish or beef, is it still less ethical? Or is it something that will be seen as incredibly taboo to the point where it should be outlawed?

I would be curious to read your thoughts and points of view on this!

For me, it's going to be a hard no that it shouldn't it be done. But to be honest, I feel like my feelings regarding it come from an emotional perspective rather than a logical one.

Edit: Let's throw in lab grown human organs as well. Say these are the organs that aren't suitable for transplant, but are perfectly edible.

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?

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?