I love SQLite, and I really want to run it in production, but my clients expect minimal data loss and downtime when one of my servers goes down.

The answer to that being running it on top of LiteFS or LiteStream seems like starts to make the setup a lot less simple and lot less battle tested, which kind of starts to negate the advantages over just running Postgres.

▲

jbverschoor 6 hours ago | parent [-]

all clients think they're google

▲

mikeocool 6 hours ago | parent [-]

I dunno, not losing data and minimizing unnecessary downtime is table-stakes for a pretty significant class of businesses.

If for no other reason, dealing with these at any scale often distracts from running your actual business.

	▲	andersmurphy 4 hours ago \| parent [-]
		Sqlite with litestream has a smaller default window of data loss than RDF. 1s vs 5 minutes.