Search the web
Sign In
New User? Sign Up
extremeperl · Extreme Perl
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
refactoring databases   Message List  
Reply | Forward Message #124 of 500 |
Hi Rob,

I was talking to some of my co-workers the other day about managing
changes to databases on a system that has a version in production
already. There was a thread I remember reading, possibly on the
mod_perl list, and possibly by you, about a technique for managing
schema changes by treating everything after the initial design as an
update script, i.e. always using ALTER TABLE and the like. I recall
someone complaining about how that would become hard to manage and there
was discussion of rolling up all the changes every now and then into a
new starting point.

Does this sound like something you posted? I can't seem to find it, and
I wanted to re-read it. Even if it wasn't you, any advice about
managing database changes would be welcome, since I remember you saying
you made lots of ongoing schema changes on your projects even after
launching them.

- Perrin




Fri Feb 18, 2005 5:09 am

consumer
Offline Offline
Send Email Send Email

Forward
Message #124 of 500 |
Expand Messages Author Sort by Date

Hi Rob, I was talking to some of my co-workers the other day about managing changes to databases on a system that has a version in production already. There...
Perrin Harkins
consumer
Offline Send Email
Feb 18, 2005
5:10 am

Hmmm, that sounds very similar to something I've done for awhile now (at 2 different jobs). I don't recall posting about it, but I (or one of my cow-orkers)...
Matthew Albright
MattAlbright
Offline Send Email
Feb 18, 2005
7:05 am

... That would be very interesting! This is my take: In my experience, doing this automatically is kind of dangerous. We use a strikingly similar approcach...
Johan Lindstrom
johan__l
Offline Send Email
Feb 18, 2005
9:51 am

... [snip] A "me too" from over here. Done similar on a couple of projects. We kept the schema change data outside the database - that way we could keep "build...
Adrian Howard
ajh65537
Offline Send Email
Feb 18, 2005
5:09 pm

Hi Perrin, It's good to hear from you. ... Probably. It's certainly something we do. I've included some thoughts below. ... This is like the code we have,...
Rob Nagler
robnagler
Offline Send Email
Feb 18, 2005
5:46 pm

... This is just my experience at $work. But you should know that we're not very mature on process at all, and currently there is no way to guarantee that...
Johan Lindstrom
johan__l
Offline Send Email
Feb 18, 2005
6:14 pm

... Yes, we try our best to automate everything. If we think there is going to be multiple upgrades, one of which is critical, we'll organize these in...
Rob Nagler
robnagler
Offline Send Email
Feb 20, 2005
1:00 am

... Yeah, we're on postgresql. ... We are actually shipping a software product, and we make the new releases available to our customers, but they don't have to...
Matthew Albright
MattAlbright
Offline Send Email
Feb 19, 2005
12:50 am

On 19 Feb 2005, at 00:50, Matthew Albright wrote: [snip] ... [snip] ... Amen. ... Just to clarify - I was talking about a /client/ DBA who tweaked the schema...
Adrian Howard
ajh65537
Offline Send Email
Feb 19, 2005
5:16 pm

... Yikes. Remember there's a clear separation of concerns between the customer and the programmer. Be sure to yell at your customer. ;-) ... Yup. I wonder...
Rob Nagler
robnagler
Offline Send Email
Feb 20, 2005
12:54 am

... Perhaps you should pay them to upgrade. :-) Yes, you've got a logistical problem, and it sounds like you have a good solution for it. ... Interesting you...
Rob Nagler
robnagler
Offline Send Email
Feb 20, 2005
12:56 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help