Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

I would not want to be the one on-call for a million row SQLite database!


I would. That's a pager that's never going off.


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




Consider applying for YC's Winter 2026 batch! Applications are open till Nov 10

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: