3 ms·

Even trivial projects become non-trivial when they reach the scale of Wikipedia or Facebook. I am a bit surprised that nobody mentioned MySQL lacking transacion

Even trivial projects become non-trivial when they reach the scale of Wikipedia or Facebook. I am a bit surprised that nobody mentioned MySQL lacking transacion support in this thread, because otherwise a lot of comments sound "I don't really try to use/learn it, but I heard it is a toy db, and PG is real DB". Well, ok.

MrBuddyCasino 13y ago
MySQL lacks transaction support? Unless you use MyISAM tables, that isn't true since like forever. For the record, I prefer Postgres over MySQL any day.
- Xylakant 13y ago
  There's a couple of things that you can do with PGs transactions that don't work in MySQL, for example transactions around DDL statements. That can leave you with quite a mess at your hand when you have to rollback half a database migration.
  - jhh 13y ago
    That's a rather unique feature of postgres though. Not even Oracle has DDL transactions.
    - jeltz 13y ago
      PostgreSQL, Sybase, DB2, Informix, Firebird all support transactional DDL.