2 ms·
I just finished building an open-source project using SQLite, and this makes me a little nervous. Is SQLite generally considered a reliable system? I've only ha
by felix-the-cat 5mo ago
I just finished building an open-source project using SQLite, and this makes me a little nervous. Is SQLite generally considered a reliable system? I've only had one experience with the DB becoming corrupted and that was because I used the Task Manager to force kill the process while it was running under a heavy load, and I felt that was understandable.
- rnio 5mo ago[flagged]
- mattrighetti 5mo ago> Is SQLite generally considered a reliable system? It is arguably the most battle-tested piece of software on the planet. It's deployed basically on every single piece of tech out there.
- jurip 5mo agoAnd in many cases, multiple times. I wouldn't be surprised if the number of SQLite DBs on my phone was in the hundreds and the number of separately compiled copies of the library is in double digits.
- felix-the-cat 5mo agoThanks, appreciate it!
- listeria 5mo agokilling a process which is using SQLite shouldn't corrupt the database, same as pulling the plug.
- jimbokun 5mo agoIf you actually read this article it should give you even more assurance that SQLite is very robust and trustworthy. It mostly deals with all the edge cases where something other than the quality and reliability of the SQLite code base can bite you.