Isn't this what http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Schema/Versioned.pm is for? Or am I missing a key piece of the conversation?
On Tue, Nov 6, 2012 at 8:11 AM, Thomas Klausner <d...@cpan.org> wrote: > Hi! > > On Tue, Nov 06, 2012 at 07:21:00AM -0800, Bill Moseley wrote: > >> Schema changes are frequent, but it's not like the volume of code changes. >> Maybe a few new columns every week or so. The problem is when there's a >> mistake it's potentially a big problem. The trick, like always, is >> finding a solution that fits the problem size -- that doesn't introduce >> just as much risk or is overly complex. > > We're using (and wrote...) DBIx::SchemaChecksum, which calcs a checksum > of a current DB schema using DBI introspection. You can than build > upgrade trees based on those checksums. It works good enough for us > (using Postgres), but there are some issues (mainly downgrades, which > are not supported (yet); and changing data together with the schema > (though there are workarounde..)) > > The version currently on CPAN is quite out of date. Maros and me started > an update effort on the train back from YAPC, which is nearly done. I > plan to finish/release it for Austrian Perl Workshop (where I'll also do > a talk on DBIx::SchemaChecksum). > > EOADVERTISING > > greetings, > domm > > -- > #!/usr/bin/perl http://domm.plix.at > for(ref bless{},just'another'perl'hacker){s-:+-$"-g&&print$_.$/} > > _______________________________________________ > List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class > IRC: irc.perl.org#dbix-class > SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ > Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk -- Thanks, Rob Kinyon _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk