Heroku: Up and Running by Neil Middleton & Richard Schneeman

Author:Neil Middleton & Richard Schneeman
Language: eng
Format: epub, pdf
Tags: COMPUTERS / Systems Architecture / Distributed Systems & Computing
ISBN: 9781449341343
Publisher: O’Reilly Media
Published: 2013-11-07T05:00:00+00:00

Transactional DDL

If you’ve ever made a change to your database and have had something fail mid-way, either due to a constraint or some other means, you understand what pain can come of quickly untangling the resultant mess. Typically, changes to a schema are intended to be run holistically and if they fail, you want to fully roll back.

Some other databases, such as Oracle in recent versions and SQL Server, do support this. PostgreSQL, however, supports wrapping your DDL inside a transaction. This means if an error does occur, you can simply roll back and have the previous DDL statements rolled back with it, leaving your schema migrations as safe as your data, and your application in a consistent state.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.