The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

Re: xplmedianet database


  • Subject: Re: xplmedianet database
  • From: "Personal Netgreen.biz" <neilturley@xxxxxxxxxxxx>
  • Date: Thu, 17 Mar 2005 07:18:52 -0800


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

xPL Main Index | xPL Thread Index | xPL Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.