4 ms·
SQLite usage makes me wonder how will it behave over time with millions of commits. Also makes me wonder how will it handle distribution.
by maxpert 10y ago
SQLite usage makes me wonder how will it behave over time with millions of commits. Also makes me wonder how will it handle distribution.
- mixmastamyk 10y agoIndeed, what are the consequences of that choice, vs. git and hg?
- alvil 10y agohttps://www.reddit.com/r/PHP/comments/59na74/sqlite_as_the_only_database_for_website/ https://www.reddit.com/r/PHP/comments/59na74/sqlite_as_the_o...
- BeetleB 10y agoTo 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.
- rogerbinns 10y agoSQLite 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/howtocorrupt.html https://www.sqlite.org/testing.html https://www.sqlite.org/testing.html
- planteen 10y agoJust curious, were you running with ECC RAM on the box?
- david-given 10y agoThere's a writeup here about scaling issues in moving NetBSD pkgsrc to Fossil: http://fossil-scm.org/index.html/event?name=be8f2f3447ef2ea3344f8058b6733aa08c08336f 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.