Hacker News Reader

https://www.reddit.com/r/PHP/comments/59na74/sqlite_as_the_o...

There's a writeup here about scaling issues in moving NetBSD pkgsrc to Fossil:

http://fossil-scm.org/index.html/event?name=be8f2f3447ef2ea3...

But that was, like, 2011, so I have no idea if it's still valid or not.

To be honest, I'm very wary of using SQLite for storage for anything long term. Over the years I've had a few SQLite databases become corrupt in various software I use. Always a headache.

SQLite has had corruption bugs but they have been exceeding rare. Far more often it has been other factors that caused SQLite to become corrupt (ie it is a victim not the cause).

https://www.sqlite.org/howtocorrupt.html

https://www.sqlite.org/testing.html

Just curious, were you running with ECC RAM on the box?

Indeed, what are the consequences of that choice, vs. git and hg?