[claytongulick]

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?

[otoolep]

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.