Re: [Grip-users] Re: grip/ddj database format change

[Rick N. <ri...@ri...>]

Ok, it took a bit longer than I thought, but I think I've got the
upgrade script ready.  It requires perl and two perl modules
(DBI and DBD::mysql). You can find it at:

http://www.rickjenn.net/grip

I ran it on my existing grip/ddj database and DigitalDJ version 0.6 
was able to use the converted database afterwards.  Run it without
any arguments to get a usage message.

Send questions, bugs, etc. to this list or me (ri...@ri...).

Good luck!


-Rick

Thus spake Rick Nicoletti (ri...@ri...):

> If the only change to the database schema is to add a column to the database,
> I think it should be feasible to write an upgrade script (which I'd be 
> willing to do, being in the same boat). Something like:
> 
> 1) add new column to existing grip DB
> 2) populate new column based on existing data in DB
> 
> Mike, can you confirm the change in the DB schema?
> 
> 
> -Rick Nicoletti
> 
> Thus spake Mike Oliphant (oli...@mp...):
> 
> > The main change to the database format was the switch to using a filename
> > stored in the DB instead of calulating it from Grip's encode file format.
> > 
> > Unfortunately, there is no migration tool. I should have provided one, but
> > I was too lazy.
> > 
> > There is a solution short of re-ripping, however. If you delete your ddj
> > database, you can reconstruct it by inserting each of your cds and having
> > Grip do an "MP3 DB Scan". This is a pain, but at least you don't have to
> > re-rip.
> > 
> > I'll be sure to be more careful about any future database format changes.
> > 
> > Mike
> > 
> > On Tue, 14 Nov 2000, Neal E. Young wrote:
> > 
> > > 
> > > Mike, first, thanks for a ddj and grip, I really like them.
> > > 
> > > This must be a FAQ, but I can't find anything on it.
> > > 
> > > I was happily using ddj 0.5 and grip 2.6.
> > > Through helixcode I got a new grip (2.95).
> > > This grip failed to enter songs into the SQL database.
> > > 
> > > My understanding now is that this is because the database
> > > format changed (so mp3insert provided by ddj 0.5 doesn't work
> > > with grip).  Took me some work to figure that out.
> > > 
> > > As I understand it, I have two options:
> > > a) use ddj 0.5 and grip 2.6 (this is what I have resorted to);
> > > b) use ddj 0.6 and grip 2.95 (with the new database format).
> > > 
> > > The obvious question is, for users that have a database in the
> > > old format, is it feasible to convert the old format into the new one?
> > > 
> > > Is there a script?  If not, what are the obstacles to writing one?
> > > I would be willing to learn a little SQL programming to do it.
> > > 
> > > Thanks very much for your time.
> > > 
> > > If you reply to this message, please send a copy to 
> > > ne...@cs..., as I am not subscribed to the grip-users list.
> > > 
> > > Neal Young
> > > 
> > 
> > --
> > Mike Oliphant                                      oli...@mp...
> > MP3.com - The Premier Music Service Provider       http://www.mp3.com
> > 
> > 
> > _______________________________________________
> > Grip-users mailing list
> > Gri...@li...
> > http://lists.sourceforge.net/mailman/listinfo/grip-users
> 
> -- 
> 	Rick Nicoletti	ri...@ri...
> 
> 
>          "Creativity is more important than knowledge" -- Albert Einstein
> _______________________________________________
> Grip-users mailing list
> Gri...@li...
> http://lists.sourceforge.net/mailman/listinfo/grip-users

-- 
	Rick Nicoletti	ri...@ri...


    "It's okay to be wrong temporarily." --Larry Wall