The core idea here is: let SQLite run next to your application on the server; but have all features a client-server database give you.
What's the spec for this?
- SQLite runs next to server as production database
- That way, reads and writes are very fast
- In dev, some sort of worker auto-copies the prod DB to the local repo. Production bugs can be reproduced easily and code fixed quickly
- Have an interface that lets you access, view, and modify data in the production DB, kind of like Firebase. Might need a server of its own... or couldn't that just be the app server itself?
- SQLite auto-backs up to a bucket (like Litestream)
I kinda really want this, but haven't found anything quite like it. I've seen Turso, but it seems they focus more on global replication instead of the OSS developer experience I'm looking for.
What do you think? What am I missing?