Wouldn't it be cool to have a Supabase for SQLite?
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?
> - SQLite runs next to server as production database
Embedded Replicas[1]
> - 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
Maybe not exactly this, but you can replicate a DB from another with the CLI tool. Then just use that as a dev db.
> - 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?
I don't use their web interface, but I think it does allow this? I don't know for sure though.
> - SQLite auto-backs up to a bucket (like Litestream)
Turso does have point-in-time recovery[2]
[1] https://docs.turso.tech/features/embedded-replicas/introduct... [2] https://docs.turso.tech/features/point-in-time-recovery