The way these things go the 5% that you need postgres or otherwise for will account for 95% of the data.

>95.0%: SQLite

I'm a bit late to the party (also, why is everyone standing in a circle with their pants down) but, does no one care about high availability with zero data loss failover, and zero downtime deployments anymore?

Do you think more than 5% of projects really need to have HA & zero downtime deployments?

(and litestream exists for sqlite if needed)

How do you ensure fault tolerance on SQLite?

In one instance I did that by storing the file on a fault tolerant NAS. Basically I outsourced the issue to NetApp. The NAS was already there to match other requirements so why not lean on IT.