SQLite is so much better than people think. https://www.twilio.com/blog/sqlite-postgresql-complicated
Discussion
nostr:npub108pv4cg5ag52nq082kd5leu9ffrn2gdg6g4xdwatn73y36uzplmq9uyev6
it was so bad with Nextcloud that they stopped supporting it and made people use MySql or Postgres
That link doesn't support your case. PostgreSQL beat SQLite on every metric he tried. And he kept PostgreSQL's hands tied behind it's back by using only the intersection of features via an ORM and barely touching performance tweaks.
SQLite is a weird mutant. It is an RDBMS SQL database designed to be a persistence layer of a single application. It doesn't work as the former (not a server) nor is it well suited for the latter (kv databases work better as I have recently learned through experience). I think they did a great job of building the mutant to be the best mutant possible, but I don't see the use case anymore.
The advantage of SQLite is its maturity and stability. It famously has no bugs and has 100% test coverage. I’d say that’s a reason it’s still so ubiquitous