3 ms·
Yeah, that's a good point. Well, like I said, I am firmly in the Postgres camp in any case. I've never enjoyed discovering things about Mysql like the fact th
by davidw 18y ago
Yeah, that's a good point. Well, like I said, I am firmly in the Postgres camp in any case. I've never enjoyed discovering things about Mysql like the fact that even InnoDB doesn't allow you to modify the DB transactionally.
- ruby_roo 18y agoWait... what? Looks like InnoDB supports transactions, no? http://dev.mysql.com/doc/refman/5.1/en/innodb-transaction-model.html http://dev.mysql.com/doc/refman/5.1/en/innodb-transaction-mo...
- davidw 18y agohttp://adam.blog.heroku.com/past/2008/9/3/ddl_transactions/ http://adam.blog.heroku.com/past/2008/9/3/ddl_transactions/ "MySQL doesn’t support DDL transactions;" Meaning you can't change the schema transactionally. InnoDB handles data transactions ok, but I hadn't realized that it doesn't handle schema changes. It seems like I'm always discovering some little nasty about Mysql when I am forced to use it.