3 ms·
SQLite is the most stable small DB there is, maybe even the most stable one at all. Our CTO made a cluster wide distributed configuration filesystem[0], starte
by tlamponi 7y ago
SQLite is the most stable small DB there is, maybe even the most stable one at all.
Our CTO made a cluster wide distributed configuration filesystem[0], started about 9 years ago. For that a local backing store was required, and a a small DB seemed to fit the bill as it should allow to worry less about data safety, when it's really written out, and it could be a general interface which could be swapped out rather easily if required one day.
He checked out lots of the then available options, sorry I only remember BerkleyDB and SQLite but there were more.
Anyway, only SQLite never crashed, had corrupt data when doing weird things with it and was still very fast, just great.
Almost 10 years later we still use it, never a single issue with SQLite as the cause - really impressive IMO.
[0]: https://git.proxmox.com/?p=pve-cluster.git;a=tree;f=data/src;h=67601f78bf53763092ead57e55ceb1a2428891a2;hb=refs/heads/master https://git.proxmox.com/?p=pve-cluster.git;a=tree;f=data/src...