Email or username:

Password:

Forgot your password?
Esprit de Vore

I cannot emphasize enough how fucking awful the SQL standard's definition of isolation levels is. Ambiguous in like three different ways, fundamentally broken, and we've known it for TWENTY FIVE YEARS. Every time I talk about an SQL database I have to explain the N different interpretations of the standard and show how a rules lawyer would try to defend batshit behavior. I cannot wait for it to be hurled into the sun and replaced with something that actually makes sense.

6 comments | Expand all CWs
Emily S

@aphyr "SQL: as much of a standard as the English language"

crows call me breadlady

@aphyr i am extremely interested in your take on what "something that actually makes sense" would resemble. would you mind sharing more about that? 🤓

Rob

@aphyr Honestly you are one of the few people who could really make that happen. You know this stuff better than anyone I've ever known.

Tim Clicks

@aphyr SQL's semantics make implementations' divergent choices look sensible

Tim Bray

@aphyr I forget who originally said it… “Every time the SQL committee was faced with a choice, it took both paths.”

Philippa Cowderoy

@aphyr SQL is bad pain, dammit! But I'll admit I'm glad to not have to find out exactly how much...

Go Up