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.
[ Parent
| on HN ]
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.
That's a rather unique feature of postgres though. Not even Oracle has DDL transactions.