3 ms·
SQLite succeeded because Berkeley DB files sooner or later always become corrupted, and it doesn’t hurt that SQL is a more useful interface than a simple key-va
by teddyh 4y ago
SQLite succeeded because Berkeley DB files sooner or later always become corrupted, and it doesn’t hurt that SQL is a more useful interface than a simple key-value store.
- giantrobot 4y agoThis was my path to SQLite. I used Berkeley DB which worked fine for me until it didn't. I also had to massage everything into a KV model which meant I had to implement search logic. SQLite was a nice local DB but gave me all the capability of SQL. I reduced the boilerplate I had to write in my code and I had a SQL front end I could use on my data stores.
- chasil 4y agoIt is not difficult to corrupt a SQLite database if it is not treated with proper care. https://sqlite.org/howtocorrupt.html https://sqlite.org/howtocorrupt.html