tag:calagator.org,2005:/events/searchCalagator: Events tagged with: DB migration2013-01-08T13:52:39-08:00tag:calagator.org,2005:Calagator::Event/12504632812012-12-27T19:39:53-08:002013-01-08T13:52:39-08:00Portland Perl Mongers – Sane Database Change Management with SqitchThursday, January 10, 2013 from 6:53-8:30pm at Free Geekhttp://calagator.org/events/12504632812013-01-10T18:53:00-08:002013-01-10T20:30:00-08:00<div class="vevent">
<h1 class="summary">Portland Perl Mongers – Sane Database Change Management with Sqitch</h1>
<div class='date'><time class="dtstart dt-start" title="2013-01-10T18:53:00" datetime="2013-01-10T18:53:00">Thursday, January 10, 2013 from 6:53</time>–<time class="dtend dt-end" title="2013-01-10T20:30:00" datetime="2013-01-10T20:30:00">8:30pm</time></div>
<div class="location vcard">
<a href='/venues/202389965' class='url'>
<span class='fn org'>Free Geek</span>
</a>
<div class="adr">
<div class="street-address">1731 SE 10th Avenue</div>
<span class="locality">Portland</span>
, <span class="region">OR</span>
<span class="postal-code">97214</span>
<div class='country-name'>US<div>
(<a href='https://maps.google.com/maps?q=1731%20SE%2010th%20Avenue,%20Portland%20OR%2097214%20US'>map</a>)
</div>
</div>
<div class="description">
<p>speaker: David Wheeler</p>
<p>
SQL change management is <em>hard.</em> Most “migration”-style implementations require opaque naming conventions, prefer DSLs that cover a fraction of SQL, and require duplication of code for simple changes to existing functions. Such does not have to be. And now it’s not
</p>
<p>
Introducing <a href="http://sqitch.org/">Sqitch</a>, simple SQL change management that doesn’t suck. Sqitch doesn’t care what programming language your app is written in. It has no opinions as to what database to use or what its schema should look like. And it doesn’t require sequentially-named migration scripts or the use of any DSL other than SQL. Sqitch lets you to write SQL migration scripts that target your database, and provides a simple, unintrusive interface for specifying dependencies, so that it can run things in the proper order.
</p>
<p>
So come to this talk to learn all about Sqitch: How it works, where to get it, and how to get the most out of managing database deployments.
</p>
<p>
David Wheeler is Senior Data Architect at iovation and an associate at <a href="http://www.pgexperts.com/">PGExperts</a>. He is responsible, among other things, for <a href="http://pgxn.org/">PGXN</a>, <a href="http://pgtap.org/">pgTAP</a>, <a href="http://www.designsceneapp.com/">DesignScene</a>, and way too many <a href="https://metacpan.org/author/DWHEELER">CPAN modules</a>. He lives in Portland unless he’s traveling with his family.
</p>
<p>As usual, the meeting will be followed by social hour at the Lucky Lab Brew Pub.</p>
</div>
<h3>Links</h3>
<ul>
<li><a class="url" href="http://pdx.pm.org/kwiki/?January2013Meeting">Website</a></li>
</ul>
<div class="tags">
<h3>Tags</h3>
<p><a class="p-category" href="/events/tag/DB migration">DB migration</a>, <a class="p-category" href="/events/tag/database">database</a>, <a class="p-category" href="/events/tag/pdx.pm">pdx.pm</a>, <a class="p-category" href="/events/tag/perl">perl</a>, <a class="p-category" href="/events/tag/postgresql">postgresql</a>, <a class="p-category" href="/events/tag/sql">sql</a></p>
</div>
<div class='single_view_right'>
<a href='http://calagator.org/events/1250463281.ics'>Download to iCal</a>
<div id='edit_link'>
<p>You can <a href="http://calagator.org/events/1250463281/edit">edit this event</a>.</p>
</div>
<div id='metadata'>
This item was added directly to Calagator <br /><strong>Thursday, December 27, 2012 at 7:39pm</strong> and last updated <br /><strong>Tuesday, January 8, 2013 at 1:52pm</strong>.
</div>
</div>
</div>
45.5103 -122.6559