I made a little CLI app for backing up my tildes comments / topics.

$ pip install xklb
$ library tildes -h
usage: library tildes DATABASE USER

    Backup tildes.net user comments and topics

        library tildes tildes.net.db xk3

    Without cookies you are limited to the first page. You can use cookies like this:
        https://github.com/rotemdan/ExportCookies
        library tildes tildes.net.db xk3 --cookies ~/Downloads/cookies-tildes-net.txt

It creates a SQLITE file with HTML text in one of the columns. Nothing super fancy. Let me know what you think?

So... a friend did this for me a long time ago, but I've replaced my computer since then, and I don't know how to do it for myself.

I know how to find the MAME executable. I don't know whether I need to download the .exe file or the .zip file, but I assume the .exe file is the better option.

I know how to run an executable file, and I'm assuming it installs itself.

I know how to find a copy of the antique video game I want.

However...

The .zip file I download for the game contains a lot of files with names like "a26-13.109" - and I don't know what I'm supposed to do with those, to get them inside the MAME and make the game playable.

I'm running Windows 10 on a 64-bit operating system, if that's relevant.

Is anyone feeling charitable and willing to help someone who's not computer literate to do this?

Have you watched any movies recently you want to discuss? Any films 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.

My spouse and I went to dinner with my parents in law tonight. Father-IL can be hard in Mother-IL generally speaking, often picking on her and 'teasing' her. Mostly criticism. It can make things pretty uncomfortable, but as mid-westerners do, rarely my spouse or the other family people speak up unless it's to rib back in order to deflect or make it stop. FIL and MIL are both in their late 70's, so aging, and conservative catholic, so daily drinkers. We went to dinner tonight to celebrate my MIL's birthday. FIL is generally stressed out due to drama with his siblings/health issues/he's just a super stressed out person, and he ordered something in a wrap and asked for no onion. Meal came and there was onions. FIL complains passively to us and we say he should say something. He says, "no, no, no."

Server came and asked, "how is everything?"

FIL says "it's fine, it's fine"

MIL starts to say, "well..."

FIL interrupts with, "shut your mouth, MIL!"

Awkward silence...eat dinner when it comes...everyone is trying to act like nothing happened.

We finish dinner and we're finishing our drinks and MIL asks, "myspouse, are you okay?"

My spouse says stilted, "yeah, I'm fine."

MIL says, "world, are you okay?"

And out of me erupted, sternly but not with a yell, towards my FIL, "it's not okay to say 'shut your mouth' yo your wife."

Everyone got quiet. Then FIL tried to defend himself and say, "I've rarely ever said that, something something, I don't need this."

Then he shut me down so I just said, "heared, heard" and left.

He said in the car on the way home, "maybe I over reacted, but..."

And I said, "I shouldn't have said anything, I know you're under a lot of stress."

Now everything is awkward and strained and quiet. I don't need to be adding more to an already stressful life situation for older folk whom I do care about, but I couldn't hold my tongue. How does one strike balance in a situation like that?

So, this is something I discovered last night that is just blowing my mind: for most of the past year, the channel TeenNick is showing only Henry Danger.

I cannot emphasize how literal I am being with that. Usually "a channel is only showing X" is an exaggeration, but for once, no. As far as I can tell, 99% of TeenNick's programming has been Henry Danger or its spin-off, Danger Force, for the past year. At most, there are brief "respites" where it will have a block with another show. For example, from July 27 to 31, it aired Zoey 101 from 11 PM to 1 AM. Two hours late at night, and then back to Henry Danger. Similar story with some new Nickelodeon show called Erin & Aaron: it showed periodically starting on April 22, and was apparently last aired on July 4.

Otherwise? Most days are JUST Henry Danger. Even Wikipedia lists Henry Danger and Danger Force as the only current shows. (Along with Nick News, which apparently only airs once a month.)

This is just honestly stunning to me. For those unfamiliar with TeenNick, it's a sub-channel of Nickelodeon. As far as I can remember, it pretty much never had original programming, but would air reruns of mostly live-action shows from Nickelodeon (either older finished shows or currently airing), some older Nickelodeon cartoons (Hey Arnold and Rugrats), or shows picked up through syndication (namely Degrassi, and more recently America's Funniest Home Videos and Wipeout for some reason...?).

What I'm saying is there is no reason for them to ONLY air this one, single show. It can't be blamed on any production issues, since it primarily airs reruns. TeenNick SHOULD have access to all the other shows from Nickelodeon's library, so it can't be a licensing issue either. As stated earlier, it aired episodes of a show that premiered this year on Nickelodeon. And Henry Danger is fairly recent, ending in 2020, so I don't know if it's a matter of residuals.

The only reason I can think of is that they want to push people to get Paramount+. Except even with that logic, this channel is currently a waste of money. Henry Danger has a total of 128 half-hour episodes (though I think some are part of a one-hour special, so Wikipedia counts 121 episodes...?), so that's basically 5 days' worth of content before airing the same thing again. That's not enough to justify a dedicated channel—not for viewers or advertisers.

From a cursory internet search, they average 66,000 viewers, with a peak of 99,000 on January 1, 2023. I can't imagine that would appeal to advertisers. I feel like the costs of running the channel outweigh any potential profits. This feels like it's just a money sink.

I just... I can't wrap my head around it. What the heck??

Anyone have any thoughts on this? Or just want to join me in boggling over this weirdness? This feels like it could be a symptom of cable's overall degradation (I've seen people comparing it to Cartoon Network's limited programming in recent years), but... It almost feels like this channel is being sabotaged? Deliberately set up for failure and closure? Just, I can't wrap my head around a year-long nonstop "marathon".

I had triple jaw surgery 6 months ago, but things went wrong around a wisdom tooth and one of the implants, so I had a revision last month. As a consequence of that, I have not been allowed to chew since my jawbone needed peace and quiet to grow back together.

The suffering is soon over, though. On August 17 I can eat normally again! I have had multiple dreams of eating and chewing things normally, and I have even had unquiet dreams/nightmares of eating but then remembering that I'm not allowed to eat.

For reference, I have eaten nothing but mashed potatoes, soups, overcooked pasta, yoghurts... for the past month. Last time around, my first solid meal was a cheeseburger from McDonald's but that was definitely not very satisfying. So please help! What should my first real meal in a month be!?

PS: my frustration is expertly expressed in this moment in this video. I WANNA CHEW!

I have seen the vibe I am looking for in the Best Little Whorehouse in Texas, Oh Brother Where Art Thou, the Hunt for the Wilderpeople, The Birdcage and I am hoping to find more. Making fun of the characters who see themselves as morally superior. Thank you.

I have seen the vibe I am looking for in MASH and in the Dukes of Hazard among other comedies. Basically significant subplots making fun of the characters who see themselves as morally superior. Thank you.

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.

For cooking I mean like making it largely from scratch. Eating out (or dining in) is hopefully self-explanatory. By premade meals I mean like ramen bowls, cans of soup, Stoufers or Banquet meals, frozen pizzas, etc. Throwing something together is like a sandwich, cereal, a box of Mac and cheese/ hamburger helper or a ramen packet where you add a boiled egg, leftover pork and some chives, etc-- stuff where it's mostly finished food that just requires a little bit of work.