3 ms·
I would not want to be the one on-call for a million row SQLite database!
by matt_wulfeck 10y ago
I would not want to be the one on-call for a million row SQLite database!
- regularfry 10y agoI would. That's a pager that's never going off.
- qwertyuiop924 10y agoYeah. No significant software is bug-free, but if there was one, SQLite would be a good candidate.
- jschwartzi 10y agoEspecially having looked at how thorough their test suite is.
- qwertyuiop924 10y agoThat's what I'm talking about. What other database tests against power outages and hardware failure?
- cheez 10y agoI'm sure many do...
- qwertyuiop924 10y agoDo 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 https://sqlite.org/testing.html). There's a reason I consider their test coverage impressive...
- cheez 10y agoI don't know. I remember reading that other DBs use SQLite's test suite
- qwertyuiop924 10y agoHuh. Well, I learned something new today.
- danudey 10y agoI'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.
- theseoafs 10y agoI'm curious why you think SQLite is a database technology that somehow can't handle a million rows.
- cheez 10y agoThousands of customers, millions of rows, 0 DB issues. All bugs are mine. And the damn thing even does JSON querying now.