I'm fairly sure you can just tweak the Url field in the Track table to point
at whatever file you want.
I'm not sure I understand your soundtrack problem, but I can make a guess.
I have some mix cds with each track by a separate artist. The tactic I've
taken to prevent the tracks from being scattered across multiple albums is
to tag them all with the same album name and artist name (I use the DJ as
the artist), and then tag the song name with the individual track artist, in
the form "artist - song title". This is the approach that CDDB uses for
some albums, but I have to patch the database after the fact for those that
it doesn't.
The only gotcha I can think of with filenames is that they're not
consistent, so automatic cataloging becomes difficult, if not impossible.
Would be nice to update to using id3v2 tags so long names don't get clipped,
though.
You can browse the DB using mysql directly. You just need a few basic SQL
statements to find albums, artists, and matching tracks. Still, graphical
editing is easier. I'm using the mysql ODBC driver so I can connect a Win98
machine running Access. There are also several graphical client programs
available for X, although I haven't tried any of them out. Find all of this
over at http://www.mysql.com
* Eradicator *
Once you learn a bar chord, the musical world is your oyster.
-----Original Message-----
From: Showalter, Frank [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 01, 1999 10:22 AM
To: '[EMAIL PROTECTED]'
Subject: couple o' questions
okay, i must admit i love the program.. however there are a couple of
changes i'd like to make and was wondering if anyone had already tried this
and/or if anyone knows why it would/wouldn't work:
i really don't like the renaming scheme it enforces. what i'm hoping is i
that this is only stored in the sql tables and not hard-coded so in theory i
could just change the tables to point to filenames formatted the way i like
and all will be okay?
secondly, as it stands it really doesn't handle soundtracks very well
(thinks they're upteen diffrenet albums of the same name for each artist) so
again i'd like to just manually edit the sql table to correct this. this one
i'm relatively sure will work.
finally, does anyone know why the choice was made to use id3 tags instead of
file names for indexing purposes? is there somekind of gotcha with filenames
i don't know about? id3 tags are annoyingly small and i'd much rather have
it read the info from a filename for indexing purposes...
oh and also, does anyone know an easy way to get in and actually modify the
data in the tables (preferably a gui option) i suppose i could just
dump-edit-and import but i would think there would be an easier way to get
in and browse around and edit the entries i need to...
any comments/advice/guidence would be appreciated.
-frank
