> SQLite, by default, offers strict SERIALIZABLE Isolated transactions which is the strongest isolation guarantee
It's not. SQLite is READ COMMITTED at best. Yes, it serializes writes, but it doesn't imply it serializes corresponding reads. Transactions could be easily interleaved and lead to races.
It's amazing how this falsehood is prevalent among devs.
It's not. SQLite is READ COMMITTED at best. Yes, it serializes writes, but it doesn't imply it serializes corresponding reads. Transactions could be easily interleaved and lead to races.
It's amazing how this falsehood is prevalent among devs.