Re: [Wikitech-l] Guidelines for db schema changes

2012-06-13 Thread Asher Feldman
Hi all, I'd like to remind everyone involved in development that requires db schema migrations - please keep in mind the three related guidelines in our official deployment policies - http://www.mediawiki.org/wiki/Development_policy#Database_patches - especially the third, which is to make schema

Re: [Wikitech-l] Guidelines for db schema changes

2012-05-14 Thread Rob Lanphier
On Tue, Apr 24, 2012 at 5:52 PM, Rob Lanphier ro...@wikimedia.org wrote: Assuming this seems sensible to everyone, I can update this page with this: http://www.mediawiki.org/wiki/Development_policy And this is done now. In case you aren't using a threaded mail client, here's the original

Re: [Wikitech-l] Guidelines for db schema changes

2012-04-27 Thread Andrew Otto
Here's the migrations library I wrote. :) https://github.com/ottomata/cs_migrations -Andrew Otto On Apr 26, 2012, at 11:30 AM, Andrew Otto wrote: I once wrote a pretty decent schema migration tool that fits most if not all of these requirements. It was built for the Kohana PHP framework,

Re: [Wikitech-l] Guidelines for db schema changes

2012-04-26 Thread Andrew Otto
I once wrote a pretty decent schema migration tool that fits most if not all of these requirements. It was built for the Kohana PHP framework, but a lot of it is pretty independent of that. If someone ends up working on this I'd love to help and maybe share some code and ideas. -Andrew

Re: [Wikitech-l] Guidelines for db schema changes

2012-04-25 Thread Faidon Liambotis
On Tue, Apr 24, 2012 at 05:52:24PM -0700, Rob Lanphier wrote: As we do more frequent deploys, it's going to become critical that we get database schema changes correct, and that we do so in a way that gives us time to prepare for said changes and roll back to old versions of the software

Re: [Wikitech-l] Guidelines for db schema changes

2012-04-25 Thread Antoine Musso
Le 25/04/12 02:52, Rob Lanphier a écrit : 3. For anything that involves a schema change to the production dbs, make sure Asher Feldman (afeld...@wikimedia.org) is on the reviewer list. He's already keeping an eye on this stuff the best he can, but it's going to be easy for him to miss

Re: [Wikitech-l] Guidelines for db schema changes

2012-04-25 Thread Asher Feldman
I am generally in favor of all of this and in the meeting that proceeded Rob's email, proposed that we develop a new schema migration tool for mediawiki along similar lines. Such a beast would have to work in all deployment cases without modifications (stock single wiki installs and at wmf with

Re: [Wikitech-l] Guidelines for db schema changes

2012-04-25 Thread Asher Feldman
Thanks, hashar! On Wed, Apr 25, 2012 at 12:12 AM, Antoine Musso hashar+...@free.fr wrote: Le 25/04/12 02:52, Rob Lanphier a écrit : 3. For anything that involves a schema change to the production dbs, make sure Asher Feldman (afeld...@wikimedia.org) is on the reviewer list. He's already

[Wikitech-l] Guidelines for db schema changes

2012-04-24 Thread Rob Lanphier
Hi everyone, As we do more frequent deploys, it's going to become critical that we get database schema changes correct, and that we do so in a way that gives us time to prepare for said changes and roll back to old versions of the software should a deploy go poorly. This applies both to

Re: [Wikitech-l] Guidelines for db schema changes

2012-04-24 Thread Roan Kattouw
On Tue, Apr 24, 2012 at 5:52 PM, Rob Lanphier ro...@wikimedia.org wrote: I don't have a strong opinion about whether we need to follow rule #1 above through an iteration of our six month tarball release cycle, but we at least need to follow it through the two week deployment cycle. I think