Which one is worse, Postgres or SQLite?
SQLite I think is worse. Postgres has proven the test of time. You don't like?
Agreed
Postgres. I won't explain myself
SQLite is just a small SQL database, what's to hate about it tho? it doesn't work at scale, that is where the LITE part comes in Postgres is just the open source version of an ancient RDBMS from the mid 90s that is utterly obsolete, but still useful, but shit
They are both bad. Sqlite is slow and can't do threads, postgres is an academic experiment that never got hardened enough and eventually the fancy features that lured the devs there break in ways they can't fix because they're not database engineers. MySQL only.
Since my brother works for EnterpriseDB on commercial extentions and support for Postgres, I'm gonna have to say SQLite is worse. I'm sure you understand.
Whichever one is being used with an ORM.
Postgre is great. It's free and works fine for me on Production environment with some milions of records.