LOL, I never thought about any of this. I need to educate myself a lil better here. Of course it’ll all be vibes in a few months, so maybe I’ll just play video games instead.
sodapopcan
garrison
Of course even if you’re using Postgres it’s still quite likely that you will miss the race conditions during development unless you test aggressively. Which is why I am so against weak consistency guarantees. I actually have a pretty good idea of how databases work and yet I still constantly find myself confused as to whether something is safe in Postgres because so many of the “guarantees” are actually confusing implementation details about how locks are taken and such.
Strict-serializable is wonderful because you don’t have to know anything about the implementation to have a good mental model of what’s safe. Unfortunately the SQLite tradeoff is that there’s no concurrency control at all, but it’s still fast enough for plenty of stuff!
1