Which one is worse, Postgres or SQLite?

Reply to this note

Please Login to reply.

Discussion

i'm so old i remember when there was Ingres

SQLite I think is worse. Postgres has proven the test of time. You don't like?

Agreed

Postgres. I won't explain myself

PostgreSQL. Too complicated.

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

this 💯

SQLite but only because it’s slower than speed of light

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.

I really like both

Like everything, it depends

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.

both are great!

Whichever one is being used with an ORM.

what is that?

Postgre is great. It's free and works fine for me on Production environment with some milions of records.

MySQL