3 ms·
I’ve been using SQLite on GCP for a few small projects and it seems to work well. I use docker volumes to write to disk. I pass the disk directory to my proces
by emadda 6y ago
I’ve been using SQLite on GCP for a few small projects and it seems to work well.
I use docker volumes to write to disk. I pass the disk directory to my process via a CLI arg.
When running on a VM these disk writes are replicated between zones (this is default for regional GCP disks). So you get zero config high availability (if you can tolerate down time during a reboot).
- rhencke 6y agoYou might find DQLite of interest. https://dqlite.io/ https://dqlite.io/
- emadda 6y agoThanks I have seen this, but would prefer to use the data center provided replication at the disk level as I do not need to have real time failover (I just need to make sure I can recover data in case of a single zone failure). Also incremental disk snapshots are nice to have.