News for hackers. Stuff that matters.
Re:Why doesn't Quora use PostgreSQL by masklinn on Monday July 26, 2010 @02:37AM (#1547322)
> Transactions can't roll back schema changes

That's a feature of postgres rather than a limitation of mysql however. As far as I know the SQL Standard doesn't ask for transactional DDL, Oracle has pretty much no support for transactional DDL (in 10g anyway, each DDL statement is executed in its own transaction and any pending transaction is COMMITted before a DDL), I have no idea about SQL Server.

Re:Why doesn't Quora use PostgreSQL by masklinn on Monday July 26, 2010 @04:41AM (#1547483)
(and don't get me wrong, it's a totally awesome feature and it should be praised to high heaven, but it's an additional feature nonetheless, rather than a limitation of the concurrence)
Re:Why doesn't Quora use PostgreSQL by gxti on Monday July 26, 2010 @09:29AM (#1547950)
MSSQL supports it because it was inherited from Sybase. SQLite also supports it as well. You're right that it's a feature, but frankly I can't live without it -- there's no way to write safe schema migrations!