Oddbean new post about | logout
 Which one is worse, Postgres or SQLite? 
 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