Database design for CDIndex

Robert Pearse (rpearse nospam at drkoop.com)
Tue, 9 Mar 1999 09:41:40 -0600

hey there,

I like this alot! How wonderful that a Escient's new license was posted
yesterday on ./ and today we have a GPL alternative!

However, I have some concerns about the choice of MySQL. Actually, it's not
the choice of MySQL, but it's the choice of *any* database. There database
schema should be simple enough to work on a multiple of databases. What if a
site wishes to be a node, yet has doubts about running MySQL. Or what if
they have tons of bandwidth, 20 daddy sun servers, and are running Oracle?
Becoming a node should be very simple -- in fact it should be even simplier
than CDDB's setup.

How about shooting me the schema and I'll take a whack at it? I'll also look
into the data replication issues. XML might be the answer. . .

cheers,

röbert eric pearse
www.drkoop.com