StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Quoting Jeff Atwood in the excellent <a href="http://www.codinghorror.com/blog/archives/001050.html" rel="noreferrer">Get Your Database Under Version Control</a> post:</p> <blockquote> <p>...</p> <p>I was thinking about this again because my friend and <a href="http://www.codinghorror.com/blog/archives/000971.html" rel="noreferrer">co-author</a> K. Scott Allen just wrote a brilliant five part series on the philosophy and practice of database version control:</p> <ol> <li><a href="http://odetocode.com/Blogs/scott/archive/2008/01/30/11702.aspx" rel="noreferrer">Three rules for database work</a></li> <li><a href="http://odetocode.com/Blogs/scott/archive/2008/01/31/11710.aspx" rel="noreferrer">The Baseline</a></li> <li><a href="http://odetocode.com/Blogs/scott/archive/2008/02/02/11721.aspx" rel="noreferrer">Change Scripts</a></li> <li><a href="http://odetocode.com/Blogs/scott/archive/2008/02/02/11737.aspx" rel="noreferrer">Views, Stored Procedures and the Like</a></li> <li><a href="http://odetocode.com/Blogs/scott/archive/2008/02/03/11746.aspx" rel="noreferrer">Branching and Merging</a> </li> </ol> <p>...</p> </blockquote> <p>Really, the whole series is worth the read even if many of you seems to be specially interested by the 3rd part. And BTW, have a look at the <a href="http://haacked.com/archive/2006/07/05/bulletproofsqlchangescriptsusinginformation_schemaviews.aspx" rel="noreferrer">Bulletproof Sql Change Scripts Using INFORMATION_SCHEMA Views</a> article mentioned in the 3rd part too. You may already be aware of that but it explains amongst other good practices why writing <a href="http://en.wikipedia.org/wiki/Idempotent" rel="noreferrer">idempotent</a> change scripts is important.</p> <p>Regarding tooling, you might want to check out <a href="http://uptodater.sourceforge.net/" rel="noreferrer">UpToDater</a> (code centric), <a href="http://www.liquibase.org/" rel="noreferrer">LiquiBase</a> (xml based) or... <a href="http://dbdeploy.com/" rel="noreferrer">dbdeploy</a>, a little <strong>gem</strong> based on real-world experiences of software development in ThoughtWorks. It's not that the 2 first one are not good but this one is my preferred (and is available for Java, PHP or .NET).</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload