News for hackers. Stuff that matters.
Re:MySQL is to SQL like MongoDB to NoSQL by rimantas on Wednesday October 02, 2013 @08:34AM (#6482006)
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.
Re:MySQL is to SQL like MongoDB to NoSQL by MrBuddyCasino on Wednesday October 02, 2013 @08:43AM (#6482039)
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.
Re:MySQL is to SQL like MongoDB to NoSQL by Xylakant on Wednesday October 02, 2013 @10:11AM (#6482459)
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.
Re:MySQL is to SQL like MongoDB to NoSQL by jhh on Wednesday October 02, 2013 @11:26AM (#6482962)
That's a rather unique feature of postgres though. Not even Oracle has DDL transactions.
Re:MySQL is to SQL like MongoDB to NoSQL by jeltz on Friday October 04, 2013 @05:20PM (#6498085)
PostgreSQL, Sybase, DB2, Informix, Firebird all support transactional DDL.