thijs Posted May 12, 2003 Report Share Posted May 12, 2003 well... i am going to redo the database structure. and would like some feedback of the ideas i have. for now i was thinking of the next list of elements for the tracks table, which will contain information which is unique for that single track. id (unique key for linking to releases, internal)producer_1producer_2producer_3producer_4vocal_1 (aka featuring)vocal_2track_namesub_titleremix_nameremixer_1remixer_2remixer_3yearreal_mediaengineertimegenre remember that this 'update' is way more extended than needed. but to covers all those exceptions it is nice to have things ready :wink: bit of explaining:never mind the id, that is pure database stuffthe producer fields, there are 2 in the database which is used now, plus one featuring. but i have noticed several occasions which this is not enough. i took the worst case which to my knowledge is bios-fear, stakka, skynet, rob data and kemal (forced to put konflict in the database because of the lack of fields). therefore four producer fields is my next option. since the mc's are being used more often a second field for vocals is definitely needed as well. track_name is obvious, but the sub_title might not be. what i mean with it is: 'Manix - Oblivion (Head In The Clouds)', the head in the clouds part. which for instance could also be used for things like '31 seconds' to be added to 'valley of the shadows'. remix_name... the name of the remix. most of the time a remix is just called [artist name] remix, but more creative people actually give it a name of their own. like twisted individual's 'smelly finger mix' of sticky fingers. this brings me to another question, but i'll make a seperate thread for that. remixers, well the artist names of the remixers. used to be two, but had several occasions in which three were needed. year. the year a track was released (retail). for now the scripts does a bit of a trick at this. (all tracks already have a year attached to them, was done for a script for tagging real media files...). right now the oldest year is used of the release on which the track is on. engineer.. we already talked about this. just want to know whether one is enough or a second should be added. time. playing time of the track.. bit in doubt whether this will work, but want to be open for all ideas. genre. at first releases will have genres added to them. and the tracks on the release can inherit from the release. if you think a field is missing or think a field should be removed.. lemme know Quote Link to comment Share on other sites More sharing options...
mi:t Posted May 12, 2003 Report Share Posted May 12, 2003 very thorough. some comments: don't see much point in the 'time' element. but very much support the 'engineer'. it's sometimes very essential understanding something (d product for full cycle etc.) i miss the most of searching by release names (albums, ep names). Quote Link to comment Share on other sites More sharing options...
thijs Posted May 12, 2003 Author Report Share Posted May 12, 2003 i miss the most of searching by release names (albums, ep names) don't worry.. that'll be taken care of.. there will be a complete new way of searching for track-, ep, lp and cd names.. should be muchos faster :mrgreen: Quote Link to comment Share on other sites More sharing options...
Guest Guest Posted July 4, 2004 Report Share Posted July 4, 2004 Im guessing you already have a table of artists with correlating ID's... sooooo to save on overhead: use a character seperated string of artist ID's in one column (producer and remixer) rather that have 4 columns dedicated to a repeating artist name Quote Link to comment Share on other sites More sharing options...
Guest Guest Posted July 4, 2004 Report Share Posted July 4, 2004 or perhaps something like this (sorry, im a bit of a nerd) : table for storing track id's against remixer/producer id's (could hold multiple identical rows for ID ((SELECT DISTINCT) etc).. ID Producer Remixer1 59 60 then subsequently a table for artist names: ID 1st_name surname etc59 Rupert Parkes60 etc etc perhaps to save on indexing you could have all other track info in a seperate table. Quote Link to comment Share on other sites More sharing options...
root Posted July 4, 2004 Report Share Posted July 4, 2004 ^ sry i forget to sign in Quote Link to comment Share on other sites More sharing options...
thijs Posted July 5, 2004 Author Report Share Posted July 5, 2004 root: drop me an email with yer IM contacts plz 8) Quote Link to comment Share on other sites More sharing options...
haste Posted July 5, 2004 Report Share Posted July 5, 2004 you'll need multiple genres for some releases. there are loads more things that need including in the db structure but i'm not sure how they fit in with this table. root is right though, there's no need for separate fields for remixers etc. it's all about link tables & all that, will make it all much easier...i though it was done like this already, but obviously not! Quote Link to comment Share on other sites More sharing options...
Phokus Posted July 5, 2004 Report Share Posted July 5, 2004 Will we be able to search by producers' real names? Quote Link to comment Share on other sites More sharing options...
thijs Posted July 5, 2004 Author Report Share Posted July 5, 2004 Will we be able to search by producers' real names? technically that is a piece of cake. however i can imagine people finding that intrusive. one possible solution is to give moderators the right to do so, when people ask for a certain person on the forum, they can help out. not sure about this yet though. Quote Link to comment Share on other sites More sharing options...
Phokus Posted July 5, 2004 Report Share Posted July 5, 2004 Fair enough! Just wanted to do it sometimes when I can't remember someone's alias(es) but know their real name! Quote Link to comment Share on other sites More sharing options...
thijs Posted July 5, 2004 Author Report Share Posted July 5, 2004 just pm me and i'll sort you out for now :wink: Quote Link to comment Share on other sites More sharing options...
Phokus Posted July 5, 2004 Report Share Posted July 5, 2004 Hehe - nah, it's cool, it was a while ago, and I've found out subsequently. Just thought at the time it'd be a useful feature, but I can understand why it may be undesirable. Quote Link to comment Share on other sites More sharing options...
Frodo Posted July 5, 2004 Report Share Posted July 5, 2004 Maybe a bit off-topic, but what the heck.. Would be cool if you were looking at label info, and you could somehow press the artist's name and see his releases just on that label.. Hope I'm making myself clear :oops: Quote Link to comment Share on other sites More sharing options...
root Posted July 6, 2004 Report Share Posted July 6, 2004 Maybe a bit off-topic, but what the heck.. Would be cool if you were looking at label info, and you could somehow press the artist's name and see his releases just on that label.. Hope I'm making myself clear :oops: How about when you click an artist it shows at top what labels they have resleased on and clicking on would bring up the list of tunes for that artist + label Quote Link to comment Share on other sites More sharing options...
Frodo Posted July 6, 2004 Report Share Posted July 6, 2004 How about when you click an artist it shows at top what labels they have resleased on and clicking on would bring up the list of tunes for that artist + label Even better 8) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.