Not really. Setting a few sqlite options and enabling litestream for backups is much easier than setting up Postgres with reliable backups.

Should you do this for all apps? No. Do you have read heavy applications? Consider SQLite