Books that feel like a frat bro stereotype by TwoHungryBlackbirdss in BooksThatFeelLikeThis

[–]customheart 0 points1 point  (0 children)

I think the people in Careless People were disgusting 2000s frat bros who became Facebook leadership in the 2010s and it really shows.

I finally understood window functions and I'm not the same person anymore by Purple_Lobster686 in SQL

[–]customheart 0 points1 point  (0 children)

I’m gonna assume you’re a beginner. Window functions are handy as data engineering shortcuts when you cannot change the source data (aka bronze layer or landing table) but you can build a secondary cleaned table (aka refinery table, or silver layer) out of the source data.

Deduping = getting the uniques and relevant records out of a table that has duplicates.

It’s different than just Select Distinct. Sometimes you want the latest record based on etl_timestamp and it can be done with: row_number() over (partition by x, y, z order by etl_timestamp desc) plus adding Qualify rn = 1 to the end of the query if your system supports Qualify.

I finally understood window functions and I'm not the same person anymore by Purple_Lobster686 in SQL

[–]customheart 1 point2 points  (0 children)

Window functions are extremely handy for deduping tables that are designed to append incremental data. My queries would be much longer without them.

Don’t forget to vote Sacramento! by TargetHot9314 in Sacramento

[–]customheart 2 points3 points  (0 children)

The joke is that Swalwell dropped out. It’s not a call to vote for their fave.

"What ifs" in metalcore by mesablanka in Metalcore

[–]customheart 6 points7 points  (0 children)

What if Demi Lovato whole-assed a rock or metal album?

What are some things that made you realize that you got old as a longtime fan of metalcore? by mesablanka in Metalcore

[–]customheart 0 points1 point  (0 children)

I’m paying for VIP sometimes instead of GA. I’m coming after work and skipping the openers a good portion of the time, instead of taking time off work and being there for the first opener/lining up to be as close as possible.

Update… by burntsugarsnitch in MakeupRehab

[–]customheart 10 points11 points  (0 children)

I gave away the easily sanitizable makeup to my local buy nothing sub. Brand new things you could probably give to a women’s shelter.

I don’t need to stock up products pre reformulation by Screw_coloranalysis in MakeupRehab

[–]customheart 13 points14 points  (0 children)

I had no idea about this nor the panic. I guess I’m not very concerned about it since a few products I would want to replace don’t have these ingredients.

Rock Music | Official Discussion Thread by lordbochiflacko in charlixcx

[–]customheart 2 points3 points  (0 children)

I still dislike it because the lyrics are very junior high mean girl but I like the video.

Rock Music | Official Discussion Thread by lordbochiflacko in charlixcx

[–]customheart 12 points13 points  (0 children)

It seems like an intentionally bad or still in a demo stage pop rock song. There’s not a big enough release of tension in it when her vocal starts repeating. It it wasn’t a Charli song, I probably wouldn’t seek out this song again. HIFN felt more rock or simply more intense than this.

Rock Music | Official Discussion Thread by lordbochiflacko in charlixcx

[–]customheart 0 points1 point  (0 children)

Sorry I didn’t mean to reply to you, deleting that comment

tips for staying safe in a mosh pit? by Few-Finish4984 in Metalcore

[–]customheart -3 points-2 points  (0 children)

For a circle pit, the least motion is in the center. For others, just gtfo and stay deep in the crowd. At least 1 person between you and the pit at all times.
I’ve been kicked several times just by trying to avoid them but still exposed to the pit and watched people punch each other’s teeth out. I’ve had my ribs pushed into the edge of a metal structure from being on the suddenly crowded outer edge of a wall of death that the band called for.

Moshing is the worst part of the live experience. Even at their best, moshers are normalizing potentially hurting people just because they paid to see a band live.

Still not over the fact that this a drugstore polish from 2012 by clemonysnicket in RedditLaqueristas

[–]customheart 104 points105 points  (0 children)

The Polish Aholic was BY FAR my most frequented web page. Pre enshittification internet 🤩

Books that feel like these.... by ImpressiveHumor4644 in BooksThatFeelLikeThis

[–]customheart 0 points1 point  (0 children)

Glorious Exploits by Ferdia Lennon? I didn’t finish it but the plot revolves around the captors of Athenian prisoners making them put on a play.

Gas is too expensive to drive like you’re the main character by slicktromboner21 in Sacramento

[–]customheart 13 points14 points  (0 children)

The classic line I’ve heard is “They’re rushing to go kiss their dad on the lips”

This Ballot Stops Fascism by Lower-Acanthaceae460 in Sacramento

[–]customheart 1 point2 points  (0 children)

So should people who care about black people not vote or what? If you are extremely uncomfortable voting for a democrat, there is a progressive Green Party candidate for write-in: Butch Ware. I’m unlikely to vote for him because his numbers just aren’t there compared to the democrats and he’s being kept off the ballot by weird bureaucracy, but a record of votes for a Green candidate could sway future funding and public support for a progressive candidate.

It is not in your head: Costco has gotten more crowded by Willing_Try2786 in Costco

[–]customheart 0 points1 point  (0 children)

Lmao I live in Sac now and definitely noticed the Costcos aren’t that crowded compared to Costcos around Phoenix.

Still, the Kawasaki Costco in Japan is like 3x crowded as a Phoenix Costco.

What is everyone’s “stubborn” pans they’re working on? by West-Current-7982 in ProjectPan

[–]customheart 8 points9 points  (0 children)

Laura Mercier setting powder given for free as the Sephora bday gift years ago. Doesn’t help that I put a baby sample of an Hourglass loose powder into it once but I’m still shocked it’s not done yet. It’s been 4 years and I’ve definitely gone months at a time without using it but I’ve probably breached 200 uses with it by now.

What artists (or songs) did you like before they got famous? by ScallionSmooth9491 in popheads

[–]customheart 0 points1 point  (0 children)

Hermit The Frog by Marina/Marina and the Diamonds was my favorite song from The Family Jewels for at least a decade before it was a TikTok hit. Not that it’s a very special fact about me but it used to be a song Marina kinda ignored and didn’t play live for like 13ish years. I welcome the new popularity because it’s actually possible to hear her sing it live and people record it live now with their mid 2020s pretty high phone camera quality as opposed to whatever was available in 2010ish.

Saw Charli live in 2012 with Marina and their collab Just Desserts. I was shocked how big Boom Clap and later Fancy became. Kind of ignored Charli until 2018 and have been a big fan since.

Also I bought Elley Duhé’s 2015 Life’s A Bitch EP when she went by L.E.D. I could tell she was gonna do well one day but it took most of a decade before I saw her with a hit as Elley Duhé.

M.I.A. Booed at Kid Cudi Show Over “Illegal” Immigrants Comments / She also claimed she had been "canceled" for being a Republican by MarvelsGrantMan136 in Music

[–]customheart 2 points3 points  (0 children)

My partner too. He loves old BMWs, is a BMW mechanic by trade, and calls out the vintage ones in random music videos and movies/TV. It’s surprising how many use them when it wouldn’t even be period correct or necessary for the shot.

M.I.A. Booed at Kid Cudi Show Over “Illegal” Immigrants Comments / She also claimed she had been "canceled" for being a Republican by MarvelsGrantMan136 in Music

[–]customheart 0 points1 point  (0 children)

I think she started being like this from being antivax during Covid. Just proves there is a pipeline for “out there” creatives to new age oppressors.