Show HN: rqlite – the fault-tolerant DB built on SQLite – v10.0 released
github.comMajor new release which improves clustering robustness, especially when dealing with slow Followers. New features include a built in web-based console (at localhost:4001/console) and comprehensive use of CRC32 for even strong data integrity guarantees. Lots of other bug fixes and improvements under the covers.
Full list of changes at at https://github.com/rqlite/rqlite/blob/master/CHANGELOG.md rqlite is very cool, but I have a hard time thinking of a real world use case. For a project where sqlite is good enough, just using it plus the amazing sqlite rsync command on a cron job gives you pretty amazing capabilities. When/if you outgrow that and/or need something more, like GIS capabilities, Postgres is the choice. rqlite sits somewhere between, and I'm not sure how I'd actually use it? You can learn about some known use cases here: https://rqlite.io/docs/features/#common-use-cases One application that comes up over and over again -- wanting relational modeling, along with HA, but with low operational costs. People sometimes start with Postgres, then need to set up HA, and find it's a lot of work. They realize that their data set requirements are not huge, don't need fancy features, so start to think Postgres is overkill. That's what Replicated found.