Yeah. No significant software is bug-free, but if there was one, SQLite would be a good candidate.
Especially having looked at how thorough their test suite is.
That's what I'm talking about. What other database tests against power outages and hardware failure?
I'm sure many do...
Do they do it for every release? What about OOM error testing? IO error tests? fuzz tests? UB tests? Fuzz tests? Malformed DB tests? Valgrind analysis? Memory leak checking? Regression tests?
SQLite does all of that and more with every release (https://sqlite.org/testing.html). There's a reason I consider their test coverage impressive...
I don't know. I remember reading that other DBs use SQLite's test suite
Huh. Well, I learned something new today.
I've seen MySQL tested against power outages and hardware failure on a dozen occasions. If I got paid overtime for dealing with the results I'd probably own half of Vancouver by now.
I'm curious why you think SQLite is a database technology that somehow can't handle a million rows.
Thousands of customers, millions of rows, 0 DB issues. All bugs are mine. And the damn thing even does JSON querying now.