[Phpmyadmin-devel] feature: mysqldiff
Hi everyone, Sorry for the intrusion in your daily development, but I've been lurking the list for quite a while, just out of interest in phpmyadmin and its continous forthcoming. However, I have a feature request or pieaces to a possible idea. I first thought about creating the whole thing from scratch, but it would be nice to have it integrated with phpmyadmin, so if this is interesting I could add some hours to this function and others as well, if wanted. Well, a short description of the idea, I develop various sites using php/mysql on a daily basis, and use cvs for the php sourcefiles and also for mysqldumps of the database which changes from time to time. And when Im finally done with modifications I'd like to make diff two databases/tables and get a resulting alter query which would perform the changes. Today I log all alter queries and then apply them to the target database. This works of course, but the diff seems much nicer and wouldnt need a examination of the target table for any versions mismatch and so on. So, does anyone find this interesting and is it a thing that could be good for phpmyadmin as you see it? Looking forward for input and answears. Eric
Eric, are you talking about diffing the structure of tables, or the data? Marc Eric Persson a écrit:
Hi everyone,
Sorry for the intrusion in your daily development, but I've been lurking the list for quite a while, just out of interest in phpmyadmin and its continous forthcoming.
However, I have a feature request or pieaces to a possible idea. I first thought about creating the whole thing from scratch, but it would be nice to have it integrated with phpmyadmin, so if this is interesting I could add some hours to this function and others as well, if wanted.
Well, a short description of the idea, I develop various sites using php/mysql on a daily basis, and use cvs for the php sourcefiles and also for mysqldumps of the database which changes from time to time. And when Im finally done with modifications I'd like to make diff two databases/tables and get a resulting alter query which would perform the changes. Today I log all alter queries and then apply them to the target database. This works of course, but the diff seems much nicer and wouldnt need a examination of the target table for any versions mismatch and so on.
So, does anyone find this interesting and is it a thing that could be good for phpmyadmin as you see it?
Looking forward for input and answears. Eric
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Marc Delisle wrote:
Eric,
are you talking about diffing the structure of tables, or the data?
Marc
I just had the structure in mind, but others might be interested in diffing the data, however that is available elsewhere as I can see. Actually there is a similar tool available that diffs the structure, but its made in perl and that I dont like. :) And have something similar integrated in phpmyadmin would rock... If your interested in the perlbased variant the url is: http://adamspiers.org/computing/mysqldiff/ //Eric
Eric, If you can submit a patch, please do! If not, please enter this in the features request. Marc Eric Persson a écrit:
Marc Delisle wrote:
Eric,
are you talking about diffing the structure of tables, or the data?
Marc
I just had the structure in mind, but others might be interested in diffing the data, however that is available elsewhere as I can see.
Actually there is a similar tool available that diffs the structure, but its made in perl and that I dont like. :) And have something similar integrated in phpmyadmin would rock... If your interested in the perlbased variant the url is: http://adamspiers.org/computing/mysqldiff/
//Eric
participants (2)
-
Eric Persson -
Marc Delisle