Turso: Globally Replicated SQLite with Glauber Costa
Data Archives - Software Engineering Daily
00:00
SQLite: A Great Fit for Small Databases
SQLite is not known to have very heavy right throughput, but you also don't need it. It's a real SQL database allowed in like up to 26 regions. We can support potentially even millions of reads a second with compute and cost scale with that as well. Your data can be a couple of whatever latency hundreds of milliseconds old, but you're never going to break a transaction boundary if you transact that something that that is guaranteed to be consistent. So there's that. But then what you lose is again the complexity of Postgres Postgres has incredible amount of extensions allows you to do like plugins and whatnot functions.
Transcript
Play full episode
