4 ms·
There's no hard formula. It's basically forming a habit to never use file I/O and use SQL queries instead. Bonus points for the `lsm1` extension of sqlite3 whi
by pdimitar 7y ago
There's no hard formula. It's basically forming a habit to never use file I/O and use SQL queries instead.
Bonus points for the `lsm1` extension of sqlite3 which allows you to use it as a key-value store, which I used with mixed success (if I could remember the key names that seemed the most logical thing in the world last week, lol).
There's nothing to it, really. sqlite3 is a very mature software and save for a mechanical failure of your storage drive, the odds of it losing your data are practically zero.
For even more bonus points, encrypt your sqlite3 storage. That way you can freely distribute it on Git hosting services.