On Mon, Aug 08, 2011 at 01:03:59PM +0000, VE4PER/Andy wrote: > Alternatively, you might be able to download the musicbrainz DB and > connect it to your access as well as the RD DB, use the user defined > field to hold a linking key field to the MBID field in the music brainz > db and generate a report from that query that includes what you need. > > Again the MBID would have to be obtained from the musicbrainz db and > input into the RD DB. > > Advantage here, is you can also use a copy of music brainz db that is > linked and updated by their master db.
I believe musicbrainz provides instructions for setting up mirrors of their database. Thinking further ahead than reporting, the cart table in the database could use MBIDs to store artist and album related metadata in tables of ther own, deduplicating that data from carts, and making artist names consistant. At one point I did remove my cart table from a database and replaced it with a view of multiple tables that used MBIDs as keys, but it slowed cart searches tremendously. I was working on converting the rippper to musicbrainz lookups before I left for vacation and will probably get back at it in the next few weeks. Emery
pgpyYKRfrHREC.pgp
Description: PGP signature
_______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
