Upcoming Dates:

Week 4 (Final) Update Thread -- Saturday, October 29
Timasomo Showcase Thread -- Saturday, November 5

November 1-4 are for putting finishing touches on the project to ready it for the showcase. We are quickly closing in on the end!

Update us on your progress so far!

What did/didn't you get done this week?

Anything go according to plan?

Anything go off the rails?

Any successes or struggles to share?

So I used to be quite a fan of Dr. Who, but life got in the way shortly after Smith ended his run. Hearing about Tennant's return, I'd love to catch up, but also don't have time to watch filler.

Do any tilderinos have some advice for an abridged viewing that minimizes the episodic filler without missing too much of the main plot?

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?

Hello everyone, I'm going to move to a new apartment and doing full time home office while my wife is doing part home office, so I'm looking to improve my internet connectivity. I already plan to get the 400 mbps down fiber cable plan. So, I have to be honest that routers is one of those topics that I should know more than I should but don't, so I'm not sure what should I expect and the features I want or don't need.

Some time ago, I discovered and bookmarked the amazing website smallnetbuilder which at the time I thought, I would just trust his thorough reviews and choose the best router within my budget. Sadly, the website seems abandoned now, so I'm not sure if there is something new on the market or if the routers on his "Best" rank, are still valid options. By the way, I don't really game online.

My requirements are:

• 150€ budget, but willing to go to 200€ if really worth it;
• Mesh compatibility, just in case I need it in the future;
• Hopefully very low packet loss maybe 0-0.5%;
• Compatibility/support with open source firmware;
• Maybe VPN support (not sure, if worth it);
• 2.5Gb LAN ports would be nice for future-proofing, but I think this is not possible without going over the budget;
• Something that I don't know and never heard about, but you would really recommend it to me :).

After a first glance, the Asus RT-AX58U looks nice. Just not sure about only having two 5GHz streams and no LAN port aggregation.

Bonus dumb question(s) (sorry): Will all the routers work with my ISP modem? Or is it normal to always check with the ISP first before buying?

It's difficult to talk about the UK at the moment because, and it's hard to give this enough emphasis, IT'S AN ENORMOUS CLUSTER-FUCK AND EVERYTHING IS AWFUL.

To give you some idea, Truss is currently less popular than Putin and is the least popular PM the UK has ever had (in the years that we measured).

There's a bill going through tonight about fracking. But it's been turned into a confidence motion on Liz Truss, and it has full hard /// three line whip, slips withdrawn. (basically, members of the Conservative Party have been instructed to vote in accordance with their party's wishes, and not doing so is serious, and can lead to the MP effectively being expelled from their party.) And the three line whip is against their 2019 manifesto pledge.

Normally, we'd expect to see MPs rebelling against this. Certainly, at the moment, a bunch of them are in the mood to do so.

There's an additional complication here though - a bunch of MPs have sent in letters of no confidence, and that could trigger Yet Another Leadership Race (they've already met the threshold, but they've raised the bar to be half the party needs to send the letters because lol who cares about rules). But, if an MP is expelled their letter no longer counts. So a bunch of MPs are openly saying they're only voting for this fracking bill because they think Truss is hopeless and needs to go.

https://twitter.com/BethRigby/status/1582672374369226753

https://twitter.com/IanDunt/status/1582762437954375680

Also, Suella Braverman (who managed to be a crueller home secretary than any who've been before her which is remarkable considering the list of utterly hateful cunts who've had the job) was sacked / resigned today.

So, if there's not much talk here from people in the UK it's because nothing makes any sense and everything's changing every day.

As far as I can make out, every country has public information films. They rarely pull punches, which is pretty important as their messages are usually important. I remember being terrified by Monolith as a child. I still think about It's Thirty For a Reason whenever I drive in suburban areas, and I've seen similar things from New Zealand, Canada and so on. Creative agencies love PIF gigs because you can do so much more than a normal advert/TV spot would allow. People can, and do, go all out on them. They're also ripe for parody

However, back in the seventies, that's when the UK government went a little... well.. overboard. Imagine showing Lonely Water to actual children. Or Stand Steady, or even Frisbee? I remember being shown films like these at school, from scratchy old VHS tapes on clunky old school TVs. I remember them being broadcast during children's programming time. I remember being irrationally terrified of old fridges even though I've never see a fridge with a lock in my entire life.

But sure, they're scary topics and sometimes you do need to scare people into not doing stupid stuff that might kill them. There are plenty of examples of scary short PIFs aimed at all ages from their invention right up to the present day. But then there are the longer form movies about safety for children. That's what this post is really about. Let's call these the "unholy trinity" of PIF terror:

There's the weird time-loop slaughter fest of Building Sites Bite (unfortunately the only copy I could find was a 'reacts' video but it's worth watching)

Ignoring the of-it's-time but now recognised as problematic "Cowboys and Indians" conceit, Apaches is utterly horrifying.

Then there's the dystopian awfulness of The Finishing Line

These films were rated PG (aka safe for kids). They were shown in schools. Not just high schools, but primary (elementary) schools. Although to be fair, someone did get a clue fairly quickly and The Finishing Line was banned and withdrawn in under a year because holy shit.

I'd be interested to see some of your favourite public information films, please do link them if you have any.

I found out about these types of games about three years ago. I attempted playing Zork I, as well as this other film where you’re trying to get inside something and apparently it turns into a time travel game where you meet The Beatles (and if someone knows the title of that game I would really appreciate it because I’ve forgotten).

I’ve been fascinated by some of these games. Big problem though, is that I suck at video games in general, and these text adventure games are particularly brutal. I saw some video about Zork, which were great, but for some of them (like the aforementioned time travel game) don’t have videos. So is there a way to just read it like a book. I’ve found guides on how to complete the games, but even those leave me lost and confused.

I currently have a hankering for diving into a really long book series, so was hoping to get some recommendations from fellow Tildes users.

The genres I enjoy most are scifi and fantasy, especially darkly themed ones with deep lore, but I'm open to trying anything. The only caveat is that I have absolutely no interest in starting to read a series that hasn't actually finished yet, since at this point I am honestly quite sick of waiting for the next ASOIAF and Kingkiller.

I was considering listing all the longest series I have already read in order to avoid them getting recommended to me again, but I decided against doing that so other people can use this as a resource in case they're also looking for similar recommendations.

p.s. Malazan Book of the Fallen would be my biggest recommendation, BTW. It's by far my favorite dark fantasy series, is a whopping ~3M words, ~11k pages, with hundreds of unique/memorable characters, and an insanely deep lore spanning thousands of years.

As part of a weekly series, these topics are a place for users to casually discuss the things they did — or didn't do — during their week. Did you accomplish any goals? Suffer a failure? Do nothing at all? Tell us about it!

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.

(Inspired by this conversation thread)

Any and all thoughts on visual novels are welcome. Some potential questions for jumping off points:

What are your thoughts on the VN genre/format?

What are some of the best VNs you’ve played/read?

What would you recommend to someone who’s new to VNs and wants to try one out?

How do you think VNs compare to games, literature, and other interactive fiction?

Question here is for any LGBT users:

What have you learned?
How did it change you?

In the Tildes-preferred spirit, "LGBT" here is used as an umbrella term that refers to all minority sexualities and gender identities.

Previous questions in series:

What have you learned from...
...being a parent?
...going through a breakup?
...moving to a new place?
...working in tech?
...going through a pandemic?

These threads remain open, so feel free to comment on old ones if you have something to add!

So, quite a few people don't like/watch video content, and don't like seeing the homepage filled with videos. Let's try something new, see if it sticks.

What are the best videos you have watched this past week/fortnight?