So I'm on Tildes less often these days so I'm not keeping up with certain things as much as I used to. In particular, I really like the recurring "What games are you playing" topics but I'm often not noticing them in my skimming of the front page, especially if I haven't checked in in a day or two and it's not near the top.

So what if there was a feature, specifically for recurring topics, to subscribe to them where it gives me a "New Instance of Weekly Topic" notification in the same was as the "New Comment Reply" notification? It's probably not useful since we basically just have one recurring topic right now. But I'd honestly like to see more of these recurring topics, especially a "What are you listening to right now" one and even ones that automatically reoccur for TV shows (Episode 1, Episode 2, etc.) rather than an open thread.

This thread is posted weekly - please try to post all relevant US political content in here, such as news, updates, opinion articles, etc. Extremely significant events may warrant a separate topic, but almost all should be posted in here.

This is an inherently political thread; please try to avoid antagonistic arguments and bickering matches. Comment threads that devolve into unproductive arguments may be removed so that the overall topic is able to continue.

Usually when I ask people this question, I get a lot of phone numbers.

Having worked on a World of Warcraft database a decade ago I still remember the internal IDs of many items and spells. (12345 is Bijou's Belongings! And the lowest item ID I had found is 17, an internal item called Martin Thunder)

T'was picking fruit down under, where
I learned the truth of underwear
Davenport made the best boxer
costed more but last forever

At first my junk was hanging loose
no more briefs snuggling like a noose
but soon I loved it hanging free
it's quicker when you have to pee

Decade later holes not in sight
Bought some more in case they might
Thought they'd be with me till the end
Thirty years they've been my friend

Now I'm down to last seven pair
Out of business they went I fear
Brought down low by cheap knock offs
Where oh where is my Undie Guru now?

So I’m curious if there are any other Californians here looking at the ballot for the recall of Governor Newsom and scratching their heads like me. A group of Trump supporters got up enough votes to hold a recall of the governor, and we have to vote in the next few weeks. The ballots arrived this week and there are 2 votes we have to make: 1) Should we recall the governor? And 2) Which of these 46 (not joking!) people should replace him. Unfortunately, of the 46 possible replacements, I’ve heard of 2 of them: Caitlyn Jenner and Angelyne. Neither appear to have any relevant experience. (I’ll give Ms. Jenner the benefit of the doubt that she’d at least give a voice to an underserved portion of the population, though.)

This opinion piece from the LA Times makes the point that if the recall succeeds, there are no viable Democratic candidates despite the state leaning Democrat by a 2 to 1 margin. (Furthermore, I can’t find any place that even has statements from each of the candidates like our elections usually do. Found it!)

I don’t know how likely the recall is to succeed, so it may be a non-issue, but I’m a little concerned that there could be some dumb situation where not enough people take it seriously and only people who are pissed that they have to wear masks vote and we end up with some far right talk show host as our governor for the next year and a half or more. Anyone else have a strategy here?

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.

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!

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?

Any answer in any scope is fair game: can be something very minor or something quite significant. It can be very domain-specific or very general.

Also the goal of the thread isn’t to judge people for their mistakes but more just highlight some common errors in hopes of bringing more awareness to them.