Re: xplmedianet database

["Personal Netgreen.biz" <neilturley@xxxxxxxxxxxx>]

Hi,

>From a lurker on this board.

Compatibility with mysql should be an option as I think mysql will be a
powerful player in the future, as it the open source database.

Even if other people are using different protocols for control and general
automation they will still be able to get involved with an xpl application
because they have a remote or local database in common.

Just a thought.

Regards
Neil Turley
www.netgreen.biz
www.netgreensolar.com

----- Original Message -----
From: "Tony Tofts" <tony@xxxxxxx>
To: <ukha_xpl@xxxxxxx>
Sent: Wednesday, March 16, 2005 10:56 AM
Subject: [ukha_xpl] xplmedianet database


>
> 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
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 3/11/05
>
>



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 3/11/05



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