New Music Database

hwahrmann · 2007-09-27, 16:29

rtv and me were working on a redesign of the music database over the last days.

The old design was not flexible anymore and it resulted in to many joins to retrieve simple data.

so we've decided to create a flat db style, with no normalisation.
The result is of course a larger file, but this size is still less than an album ripped into mp3.

The new design allows us to implement more things in th future.

For the beginning you have now support for multiple artists, genres and albumartists.
You could simply separate them by a semicolon (";") like WMP does.
for example:
U2;B.B. King

the song / album will then appear for both artists.
same goes for genre and album artists.

There may be still some errors / incompatibilities´, which we will fix over the next days.

needless to say, that a rescan of the shares is necessary.
thx,

Helmut

GoldenEye · 2007-09-27, 20:36

Quote:

Originally Posted by hwahrmann

rtv and me were working on a redesign of the music database over the last days.

[...]

For the beginning you have now support for multiple artists, genres and albumartists.
You could simply separate them by a semicolon (";") like WMP does.
for example:
U2;B.B. King

the song / album will then appear for both artists.
same goes for genre and album artists.

Thanks so much for this enhancement, which I was eagerly waiting for!

G.

zag2me · 2007-09-28, 09:22

Great news about the re-design. How about making it flexible so that any fields can be created in the database by the user. So they could add their own tags like band, or composer.

Also can other separators be recognised also? I know some other apps use the | to seperate multi items.

I don't think the increased size is a problem at all.

hwahrmann · 2007-09-28, 13:47

band (= albumartists) is already included
composer is already delivered by the Tagreader, i just haven't added it to the db yet. simply forgot it

the "|" is used as delimeter as well.

Please be aware, that we're still facing some issues to display those multiple artists in the views.
i hope we can fix that over the weekend.

geov · 2007-09-28, 16:38

Quote:

Originally Posted by hwahrmann

band (= albumartists) is already included
composer is already delivered by the Tagreader, i just haven't added it to the db yet. simply forgot it

the "|" is used as delimeter as well.

Please be aware, that we're still facing some issues to display those multiple artists in the views.
i hope we can fix that over the weekend.

Hi

I dont know if the issue that I'm experiencing is related to your "artist view" problem but I had to roll back to the previous SVN. After rebuilding my database I'm seeing multiple album entries, its as if an album is displayed for every song. Usually when I'm in Album view I only see one album, now with the latest SVN I see multiple entries...

hwahrmann · 2007-09-28, 17:49

already fixed it.
is included in the next public svn build

dicsv · 2007-09-28, 20:20

With the new Database design, will it be possible to have Albums
sorted by year for each artist. With the year listed in front of the album name.
(and a YearIndex for multiple releases/year).

geov · 2007-09-29, 08:46

Quote:

Originally Posted by hwahrmann

already fixed it.
is included in the next public svn build

Thanks...

Hawkeye · 2007-09-29, 19:53

Quote:

Originally Posted by hwahrmann

the "|" is used as delimeter as well.

Is this already implemented in yesterdays SVN (rev. 16049)? I ask because it adds the album (can see it in album view) but I cant see it in albumartist view... (example of albumartist/band: "Afrob|Samy Deluxe")

wortelsoft · 2007-09-30, 08:58

WoW! J
Just tried it and the speed improvement is huge!
Loading my playlist now took seconds instead of hanging MP for a minute.

2007-09-27, 16:29	#1 (permalink)
hwahrmann Portal Developer Join Date: Sep 2004 Location: Vienna, Austria Posts: 1,383 Thanks: 2 Thanked 61 Times in 39 Posts Country:	New Music Database rtv and me were working on a redesign of the music database over the last days. The old design was not flexible anymore and it resulted in to many joins to retrieve simple data. so we've decided to create a flat db style, with no normalisation. The result is of course a larger file, but this size is still less than an album ripped into mp3. The new design allows us to implement more things in th future. For the beginning you have now support for multiple artists, genres and albumartists. You could simply separate them by a semicolon (";") like WMP does. for example: U2;B.B. King the song / album will then appear for both artists. same goes for genre and album artists. There may be still some errors / incompatibilities´, which we will fix over the next days. needless to say, that a rescan of the shares is necessary. thx, Helmut

2007-09-28, 09:22	#3 (permalink)
zag2me Portal Member Join Date: Apr 2006 Age: 29 Posts: 183 Thanks: 5 Thanked 2 Times in 2 Posts Country:	Great news about the re-design. How about making it flexible so that any fields can be created in the database by the user. So they could add their own tags like band, or composer. Also can other separators be recognised also? I know some other apps use the \| to seperate multi items. I don't think the increased size is a problem at all. __________________ silent htpc, 3.6tb media server, samsung 32" lcd http://www.movie-xml.com <--join in please, it benefits everyone.

2007-09-28, 13:47	#4 (permalink)
hwahrmann Portal Developer Join Date: Sep 2004 Location: Vienna, Austria Posts: 1,383 Thanks: 2 Thanked 61 Times in 39 Posts Country:	band (= albumartists) is already included composer is already delivered by the Tagreader, i just haven't added it to the db yet. simply forgot it the "\|" is used as delimeter as well. Please be aware, that we're still facing some issues to display those multiple artists in the views. i hope we can fix that over the weekend. Last edited by hwahrmann; 2007-09-28 at 14:25.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Music Database Files	Batfink91	General Support	1	2007-07-24 13:30
Music Database	jimbruskalski	Support	3	2006-11-16 22:39
Any one know a good music database?	takingover	OffTopic	11	2006-09-20 18:57
Possible to disable the music database?	Stor-Anders	General Support	13	2006-03-31 00:17
Music Database	Bochi	Improvement Suggestions	0	2005-07-07 17:07

2007-09-28, 17:49	#6 (permalink)
hwahrmann Portal Developer Join Date: Sep 2004 Location: Vienna, Austria Posts: 1,383 Thanks: 2 Thanked 61 Times in 39 Posts Country:	already fixed it. is included in the next public svn build

2007-09-28, 20:20	#7 (permalink)
dicsv Portal Member Join Date: Aug 2007 Posts: 12 Thanks: 0 Thanked 0 Times in 0 Posts Country:	With the new Database design, will it be possible to have Albums sorted by year for each artist. With the year listed in front of the album name. (and a YearIndex for multiple releases/year).

2007-09-30, 08:58	#10 (permalink)
wortelsoft Portal Member Join Date: May 2005 Location: Rotterdam, The Netherlands Age: 32 Posts: 374 Thanks: 1 Thanked 1 Time in 1 Post	WoW! J Just tried it and the speed improvement is huge! Loading my playlist now took seconds instead of hanging MP for a minute.