Comment by felix-the-cat

7 days 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.

6 comments

felix-the-cat

Reply
mattrighetti  7 days 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  7 days ago

    And 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.

jimbokun  6 days ago

If 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.

listeria  7 days ago

killing a process which is using SQLite shouldn't corrupt the database, same as pulling the plug.