Recently I've been rewatching GIRLS for the umpteenth time. When the series finale originally aired, it was a mini “Game of Thrones finale” situation. Fans were largely disappointed by the final episode, many disliking season 6 in general. It's one of my favorite shows, but usually when I rewatch it I either skip the very last episode, or I skip the entire final season, instead pretending that the season 5 finale was the ending of the show.

The finale of GIRLS hit a lot of marks for controversial finales. A few beloved characters were largely missing from the final episode/season or didn't get closure that people expected. The ending for the main character seemed to come out of nowhere (magically landing a dream job after struggling with employment the whole show,) and her overall arch didn't seem to align with her personality or anything that had happened up to that point. No one really got a happy ending, and the overall message or theme of the show seemed unclear, since many of the characters experienced very little growth over the course of the show, or they did actually experience some growth that was ignored when their conclusions were written.

I thought it might be fun to see if any of you have similar thoughts about any TV shows that didn't end the way you expected, or what you imagine would happen in fantastic shows that never even got an ending due to being canceled early. A few examples that come to mind:

• The obvious - How would you salvage the disaster conclusion of GoT? (I've seen so many takes online that manage to make it more satisfying.)
• I haven't seen Dexter, but I've heard that the ending was unsatisfying and clashed with what people expected from the main character.
• How could HIMYM have ended if the whole show wasn't instantly tranformed into a bait and switch with the finale?
• What would've happened with the characters on Freaks and Geeks, had that amazing show been allowed to continue for another season or two?

I intended to write about how I would want my example show to have ended, but honestly I'm stumped. Writing is hard! Especially if you don't have the luxury of planning the ending ahead of time, which I imagine was the issue for the writers of many of the classic "controversial finales." I'll probably add a comment about it after I come up with something.

Edgedancer (a stormlight archives novella) came out a few years ago, but since there's little Cosmere discussion in Tildes and I just finished reading it a few days ago, I figured it would be worth posting my thoughts on this. The only book of relevance to this which I haven't read is Dawnshard, so please mark any discussion about that with spoilers.

I've seen a lot of complaints about Lift on reddit, and I can see where people are coming from. But I always liked the way Lift think and is written. I feel like Lift's stories would make great bed time stories because of how sweetly they end. In the first interlude where Lift appears, the people of Azir are having trouble picking a "king" because they keep getting assassinated. Lift's involvement solves this problem that we're introduced to at the start of the story. And now in Edgedancer, Nalan is still hunting down budding Radiants because he doesn't believe that the Everstorm has really come back. But at the end of the story Lift swears the third ideal "I will listen to those who have been ignored" and shows Nalan the truth. Which feels like a very fairy tale ending, compared to them getting involved in some epic battle. I honestly expected Szeth to intervene and team up with Lift against Nalan.

The moment at the end where she hugs Nalan to comfort him as he's crying was touching. It got me crying! I didn't expect to feel any sympathy for Nalan, but at the end it feels like a fog is lifting off of him and he's been in a haze this whole time. Which I suppose is true of all the Heralds at this point.

I kept trying to guess who the Radiant in Yeddaw was. Of course it had to be a minor character that we've already seen. So I was thinking it would be that guard we met earlier, since they mentioned trading to get some spheres with stormlight so that she can read. I thought this was a lie, with the real reason being using the stormlight to practice some surgebinding. The other candidate was the old man, but that turned out to be a very interesting misdirect that I'm hoping to learn more about in Dawnshard. (The actual radiant was the woman at the orphanage)

The description of the city of Yeddaw was very interesting and new. I wish there was more art to go along with the descriptions, but I feel like I don't really understand the layout of the city. I feel like it would be dark all the time (except noon) if it was carved into the ground like I imagined. Also I wonder if there's more to the story than it just being created with loaned out shardblades. We know that the total number of shardblades in Roshar is very small. Even assuming something like 5 shardblades that were loaned out, how is it possible to create a whole city with that in a reasonable amount of time. Feels like it would take many decades.

September's Humble Choice is now available with the following eight Steam games:

Does anyone have experience with any of the games and, if so, would you recommend them? Is there anything in here that you're particularly excited to play?

Hello... looking to hang a 100lbs heavy bag in my basement (with regular wood-stud walls). I've researched various options and have gone down all sorts of engineering rabbit holes, including pull-out strengths of various sized lag bolts, horizontal load maximums of different kinds of wood, etc. I've perused various marketplaces for various types of mounting solutions and such. The problem with standard DIY wall mounting is that it doesn't come off the wall far enough.

I'm wondering though -- and it seems simple enough of a solution -- why the following wouldn't work:

An 8-foot span of 2x6, turned "vertically" so that the top and bottom faces are the 2" edge, affixed 45 degrees to the studs. ASCII art not-withstanding, it's just an isosceles triangle, where the 8-foot hypotenuse is the lumber, and the "height" of the triangle is 4-feet. It would seem 2 brackets (the kind used in making decks) on each end, screwed into the studs would be suitably strong.

The "Sagulator" (google it!) seems to think that such a setup would only experience a total 0.01in sag in the center of the span.

The heavy bag would just hang from this with a strap that loops over the beam.

An 8-foot span basically means I have a lot of clearance on either side.

I suppose I could just go right into the ceiling joists, but with my proposed setup I can slide the bag to one end or the other and create a bit more of a dynamic setup (albeit it looks a bit more unsightly).

Thoughts or suggestions? Or am I crazy?

I make playlists every so often because I hear such cool music and compile it into playlists not freely based on genre but rather on feeling and also similarity. Tastemaking, more or less.

The problem is... these playlists are promotional, to promote the music of my band. You can listen to these playlists without the context of that, but I think it's important as I don't want to self-promo any more than I have to.

So yeah. Is it ok if I post playlists here, and... would y'all be fine with that?

I want to finally try NixOS and build a desktop OS from the ground up with sway, iwd, waybar, foot terminal, cmus, etc.

I'm not a developer, but I'm a seasoned Linux user. Used Gentoo for years, Void Linux and now I'm on OpenSUSE TW.

I'm finding all sorts of guides and it seems confusing. In the past there wasn't any mention of home-manager and flakes, now it seems there are these things. Those are all things I need to care about? Is it all configured in one file?

What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started a new diet or have a new recipe you want to share? Anything else health and wellness related?

As of late, I've decided to introduce my dad to video games. It's his birthday upcoming in a few days, and I'm leaning towards getting an Xbox of some kind. I haven't been in the world of vidya for quite some time, so I'm hoping to lean on other opinions to make the right decision.

The main question I have is: if I'm buying used, is it worth it to try and find a Series S/X or would I be fine at entry level with an Xbox One? I figure I'll get GamePass and figure out what sorts of games he'd like to play before investing. I only really have $200 to spend, which puts a Series more or less out of the question. Would an Xbox One be a decent introduction to gaming for someone who doesn't have much of a standard for graphics / gameplay etc.? Also: what games should I add to the library?

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?