BEGIN:VCALENDAR PRODID;X-RICAL-TZSOURCE=TZINFO:-//Calagator//EN CALSCALE:GREGORIAN X-WR-CALNAME:Calagator METHOD:PUBLISH VERSION:2.0 BEGIN:VTIMEZONE TZID;X-RICAL-TZSOURCE=TZINFO:America/Los_Angeles BEGIN:STANDARD DTSTART:20121104T020000 RDATE:20121104T020000 TZOFFSETFROM:-0700 TZOFFSETTO:-0800 TZNAME:PST END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20121228T033953Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130110T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130110T185300 DTSTAMP;VALUE=DATE-TIME:20121228T033953Z LAST-MODIFIED;VALUE=DATE-TIME:20130108T215239Z UID:http://calagator.org/events/1250463281 DESCRIPTION:speaker: David Wheeler \;\n \;\n \;\nSQL change man agement is hard. Most “migration”-style implementations require opaque n aming conventions\, prefer DSLs that cover a fraction of SQL\, and requi re duplication of code for simple changes to existing functions. Such do es not have to be. And now it’s not \;\n \;\n \;\n \;\nIntro ducing Sqitch\, simple SQL change management that doesn’t suck. Sqitch d oesn’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 script s that target your database\, and provides a simple\, unintrusive interf ace for specifying dependencies\, so that it can run things in the prope r order. \;\n \;\n \;\n \;\nSo come to this talk to learn al l about Sqitch: How it works\, where to get it\, and how to get the most out of managing database deployments. \;\n \;\n \;\n \;\nDa vid Wheeler is Senior Data Architect at iovation and an associate at PGE xperts. He is responsible\, among other things\, for PGXN\, pgTAP\, Desi gnScene\, and way too many CPAN modules. He lives in Portland unless he’ s traveling with his family. \;\n \;\n \;\nAs usual\, the meeti ng will be followed by social hour at the Lucky Lab Brew Pub.\n\nTags: p erl\, sql\, pdx.pm\, DB migration\, postgresql\, database\n\nImported fr om: http://calagator.org/events/1250463281 URL:http://pdx.pm.org/kwiki/?January2013Meeting SUMMARY:Portland Perl Mongers – Sane Database Change Management with Sqit ch LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:3 END:VEVENT END:VCALENDAR