Yeah, I wasn’t trying to say SQLite is universally better. I shouldn’t have said best option, I really meant best default. I don’t think the majority of users are running a central db, most will just spin-up docker compose files for each service and end up with multiple SQL versions running.

I’ve had a lot of problems in the past from software crashes that left sqlite files in a corrupt state

I have had this issue, but it was always easily recoverable. I haven’t had the same issues with backups, although a lot of the software I use that’s running SQLite has a builtin backup feature, then I just backup that directory to a cloud service.

Besides that SQLite really doesn’t play nice with NFS, which is the basis for quite a few cloud storage providers.
Also a good point, I just don’t think the majority of users are using NFS for their DBs.

When an app is using an ORM already, I think they might as well make sure it supports both SQLite and a hosted DB like Postgres