One last point: When governments talk about "age verification," they also mean "identity verification"

So even if you're 55 years old, you will be virtually carded and all your social media activity will be linked to your identity. That means no online anonymity and raises privacy issues for adults

I have a lot of relatives in Alberta. "it's just Alberta/Texas is not different from "it's just marginalized people in THOSE places that don't matter" and listen: it's a very easy slide from those people THERE don't matter to those people don't matter *anywhere*

a man and a woman standing across from each other stripping down to their underwear in the exact same position

so 1. the protag of the video is a boy even though the song is only ever addressed to a girl, and 2. it features THIS scene where protag is meant to be seeing love interest girl but is CLEARLY imagining herself as the girl like logically, people, logically

I’d never seen the video to this and, my god, does it hit the feels when you come at it from this perspective.
youtu.be/oKsxPW6i3pM

It's fuckin adorable that they think the left wants to stop at mere "censorship."

But maybe they correctly identify that that's most likely the farthest most elected Democrats will ever go.

But if they think that's the limit of VOTERS voting left?

Sweet summer children. What sights to show you.

Machines make mistakes.

In 1983, 5 nuclear missiles from the United States were headed towards the USSR.

Stanislav Petrov had this information. It was his job to inform superiors who would launch a counterstrike.

It was the start of what would have been the Last War.

He pressed X to doubt.

Just in case you thought you’d slip the most subtle of bangers out there and nobody would see….

So it turns out this is my one year tranniversary. Hard to believe, really.

Thanks to @pengarr.postes.club and @synapsid.bsky.social for tolerating egg me and welcoming me into the fold.

I didn’t accomplish a ton, but I made it this far. Onward and upward. :)

We’ve been living through 72 nonstop hours of this exact tweet

Charlie Kirk: "god's perfect law says gay people should be stoned to death" REGISTER AT COMIACICO HOUGHTCRIME 0:09 ARLIE KIRK & JACK POSOBIEC MS. RACHEL'S PRIDE MONT *

This is the person they are suspending people over btw

screenshot of someone trying to post from trans.bsky.social. “if i was bluesky, i would simply not ban the 45k follower account “trans.bsky.social” for not caring that a transphobic nazi died.”

if i was bluesky, i would simply not ban the 45k follower account “@trans.bsky.social” for being apathetic that a transphobic nazi died.

free @trans.bsky.social
free @dly.bsky.social
free @halfbakedrhymes.bsky.social
free @cockremover.bsky.social

am i missing anyone

frustrating to have been, as a community, speaking up about the far-right radicalisation vector that is transphobia — and specifically the communities that form around transphobia — and to have been ignored, only for cis people finally to notice when their guy expands his hatred to cover more groups

oh no it felt really good to have people at work call me Julia maybe I was just harming myself like a dummy for years by staying closeted at work

pink polka club when

I blame Dave for his lack of foresight.

Hand finally healed from the last button and now there’s another one?

Should have done it in Quebec. 18 there.

I don’t think they’re calling me back. I’d save them too much money.

Interviewed with a place that listed “big data and analytics” as being among the responsibilities of the position. They track about 20K events per year. You could run their entire operation out of Excel.

*young me, developing a strong sense of justice*

This is gonna be great, what an asset, this will never drive me insane

Ok - had to look that up. I’m an Old. :)

I’d see whether there’s a way to convince it to return the record with the max timestamp that meets your criteria. If you know you only want one and it’s always the newest, it might work better.

Could also select the record from that memory table with the max timestamp and avoid the limit altogether.

I think if your basic query would be relatively selective in prod (say 5k rows or less), you’re probably faster overall to just select * from (select whatever uses your index order by timestamp desc) limit 1.

Not as pretty but likely uses your index and executes faster.

What is the value of the count vs the limit?

“Get an explain plan for the query….”

Question will be whether that limit value is too high for whatever is receiving your files.

Ok - so you’re pulling data based on a set of indexed values but the query is opting to scan the PK because of the limit.

Maybe start doubling that limit and get an explain plan to n the query. There has to be a point where it’s cheaper to use the index.

Other option - if the LIMIT is monkeying with the optimizer (docs suggest it does), what happens with a larger value?

Another thought - if you are exporting only a subset of the table, create a memory table based on your index columns and then export from that?