As a data engineer, I'd be interested in hearing more about the SQL troubleshooting.

EDIT: It looks like !lemmyperformance@lemmy.ml is a good place to subscribe to for more technical info on some of these performance improvements.

Also the Lemmy GitHub of course contains more information on bugs/enhancements/etc.

This is fascinating

My biggest takeaway from reading through the GitHub comments though is that it seems like no one actually knows where much of the SQL comes from? As in it's possible that the bug in question is just one manifestation of old, handwritten Postres code that may or may not be optimized (Or even logical?).

I don't mean this in a critical way, as things like this are bound to happen in an open-source, federated world. However, I would think a comprehensive audit of the Lemmy Postgres triggers, queries, etc could potentially save us all from some future headaches.

I've never seen this format reversed, but I'm here for it.

You seriously made a post just to say Meg Ryan was Beautiful?

Upvotes

Momma said I was a sith but I'm trying REAL hard to be the Jedi

Will those added to the Jedi Council be granted the rank of master?

I burst into flames at least once a week

“The Dark Light Side of the Force is a pathway to many abilities some consider to be... unflattering”

This movie looks so stupid. I'm 100% going to see it.

I never skip it. It's too much fun to watch and sing along to.

The traffic is coming from... inside the house!

"What Vader's really doing in his meditation shell"

100 points to whoever finds Ahsoka in this image

Lemons

UNO, but it's a Yu-Gi-Oh style anime movie.

You had me in the first half, not gonna lie.

"They do so by breaking the law in multiple countries and further contributing to a system where creators don't get paid!"

How can they prove this though? I don't think they'd have any way to. Unless OpenAI straight up admits it. But like the article mentions, the data could still have been obtained legally.

You misspelled "D-d-d-d-d-duel"

Fear will keep them in line

How my prom photo turned out