Re: xplmedianet database

["Mal Lansell" <mlansell@xxxxxxxxxxxxxx>]

I can't really comment on the detail of this, since I don't have
enough experience of databases.  However, since I already run a
MySQL database server, it would be nice if I could use it and not
have to install another.

Mal


--- In ukha_xpl@xxxxxxx, "Tony Tofts" <tony@x> wrote:
> Hi all,
>
> More thoughts please...
>
> The current media.dll uses the same database structure as
xplrionet did.
> i.e. a relational database using different tables for artist,
album, track,
> genre etc and requiring various queries (stored procedures) for
various
> actions due to the complexity of some queries.
>
> This has the advantage of being disk space efficient, but on the
downside is
> not suitable for mysql/mssql.
>
> I think we should change the database to contain only 2 tables and
no
> queries (excluding the possibility of storing playlists).
>
> A statistics table as currently (as this is keyed on md5 it can
also be kept
> up-to-date by files played via browse, query, playlist which
return a
> filename rather than a md5 key - as the tags.dll supplies exactly
the same
> info as it does for media that is scanned so a matching md5 key
can be
> created)
>
> And a track table where each record stores all the info for a
track (like
> genre, artist, track name, album, md4 hash etc) in a flat rather
than
> relational format.
>
> I also want to limit the path to 255 characters, excluding
filename, rather
> than using the wasteful (and messy to process in a query) memo
field type...
>
> Thoughts/comments please?
>
> Thanks
> Tony





xPL Links: http://www.xplproject.org.uk http://www.xplhal.com http://www.xpl.myby.co.uk
To Post a Message: ukha_xpl@xxxxxxx
To Subscribe:  ukha_xpl-subscribe@xxxxxxx
To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx