priapus

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

SQLite doesnt require you to have any service running, the DB is just stored in a file which the program accesses through an SQLite library. I think its the best option for selfhosted software, as its very lightweight and more than performant enough for 99% of these use cases.

Do you know if it will work with SQLite? I’d like to try it but I hate spinning up more postgres instances