On Tue, Sep 11, 2012 at 3:01 PM, Josh Berkus
<josh@agliodbs.com> wrote:
All,
http://blog.planetargon.com/entries/2012/8/14/rails-hosting-survey-2012-results-are-in
Quite a turnabout, eh?
Having been reading the discussions surrounding my comparison of MySQL vs PostgreSQL (which appears to have been well received on both sides, interestingly) is that a lot of Rails users are sold on one feature, namely transactional DDL. They are getting sick and tired of back up, upgrade, oops it didn't work, time to restore from backup routine. Expecially in an agile environment where db schemas may change frequently, transactional DDL is a killer feature.
As a slight aside, I was talking with an Oracle DBA about edition-based revision features and he pointed out that it is not at all like transactional DDL because 1) it only addresses code in stored procedures and functions, and not table schemas etc, and 2) Editions are designed to be able to be rolled out in stages. We might want to update the wiki to remove that comparison.
Best Wishes,
Chris Travers