Re: Possible Future Extensions
Andre Wiethoff <[email protected]> Wed, 06 May 2015 14:22:48 +0200
| Newsgroups | gmane.comp.audio.musicbrainz.devel |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --===============1687563868== Content-Type: multipart/alternative; boundary="------------040907060100000908070901" This is a multi-part message in MIME format. --------------040907060100000908070901 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit Hello Tom, thanks for the links! (I didn't think of looking at the wiki...) I am rather new to the Musicbrainz database structure, so I am thankful for any insights. It seems that the rating tables are already as needed. There seem to be a small discrepancy between the two pages you mentioned though. One tells the rating is between 1-5, the other between 0-100 (I assume 0-100 will be used internally?) I finally found the editor scheme in the CreateTables.sql command on github. It also contains everything that is needed (I think the password field is only a hash and the name field is unique over the database (case insensitive)?). It might be a good idea to add a field with a hash of the name (e.g. in lower case), in order to export a shortened table with id and hashed name which can be used to find the user statistics anonymously in the downloadable database (even though for downloaded databases already the editor id would suffice). In future extensions it could be a thought to also add an option whether other pages can access the statistics using the username/namehash only. That means for the start we would need only 0-1 additional column in the editor table and a new table for scrobbling with 3 columns(e.g. editor, recording, date). Everything else could be added later... I would propose not to import existing scrobblings or ratings, but to start fresh over - hopefully the database populates at a decent speed. The key factor would be to get some audio player developers (commercial and non-commercial ones) to add support for such a feature... What do you think? Best regards, Andre Am 06.05.2015 um 12:39 schrieb Tom Crocker: > > > On 6 May 2015 11:08, "Andre Wiethoff" <[email protected] > <mailto:[email protected]>> wrote: > > > > Hello Daniel, > > > > thanks for your reply and your thoughts! > > > > I haven't found any information/description about the user in the > database scheme description on the homepage. > > Of course it would be nice to extend the users that also (quite) > anonymous users with a user token (and a password hash) could login > and store their information with Musicbrainz. > > > >> Musicbrainz also has a rating system that allows people to submit a > number between 1 and 5 for most entries but there is not a lot of > people that use this > > > > I also found no information about this on the webpage... I assume > that this data is stored in the derived data database? > > Hi Andre > > Info about the ratings is in > https://wiki.musicbrainz.org/MusicBrainz_Database/Schema#.2A_rating_raw_.26_.2A_meta_tables > and https://musicbrainz.org/doc/Rating_System > I think the editor tables are undocumented. > https://wiki.musicbrainz.org/MusicBrainz_Database/Schema#Undocumented_tables > > > > _______________________________________________ > MusicBrainz-devel mailing list > [email protected] > http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-devel --------------040907060100000908070901 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: 7bit <html> <head> <meta content="text/html; charset=windows-1252" http-equiv="Content-Type"> </head> <body bgcolor="#FFFFFF" text="#000000"> Hello Tom,<br> <br> thanks for the links! (I didn't think of looking at the wiki...)<br> I am rather new to the Musicbrainz database structure, so I am thankful for any insights.<br> <br> It seems that the rating tables are already as needed. There seem to be a small discrepancy between the two pages you mentioned though.<br> One tells the rating is between 1-5, the other between 0-100 (I assume 0-100 will be used internally?)<br> <br> I finally found the editor scheme in the CreateTables.sql command on github.<br> <br> It also contains everything that is needed (I think the password field is only a hash and the name field is unique over the database (case insensitive)?). It might be a good idea to add a field with a hash of the name (e.g. in lower case), in order to export a shortened table with id and hashed name which can be used to find the user statistics anonymously in the downloadable database (even though for downloaded databases already the editor id would suffice). In future extensions it could be a thought to also add an option whether other pages can access the statistics using the username/namehash only.<br> <br> That means for the start we would need only 0-1 additional column in the editor table and a new table for scrobbling with 3 columns(e.g. editor, recording, date). Everything else could be added later...<br> <br> I would propose not to import existing scrobblings or ratings, but to start fresh over - hopefully the database populates at a decent speed.<br> The key factor would be to get some audio player developers (commercial and non-commercial ones) to add support for such a feature...<br> <br> What do you think?<br> <br> Best regards,<br> <br> Andre<br> <br> <br> <div class="moz-cite-prefix">Am 06.05.2015 um 12:39 schrieb Tom Crocker:<br> </div> <blockquote cite="mid:CAHmUbmfR=DcFZ4TWbrPtCX78dxuQ9yqT4uBXfUMQ640EUR=F4w@mail.gmail.com" type="cite"> <p dir="ltr"><br> On 6 May 2015 11:08, "Andre Wiethoff" <<a moz-do-not-send="true" href="mailto:[email protected]">[email protected]</a>> wrote:<br> ><br> > Hello Daniel,<br> ><br> > thanks for your reply and your thoughts!<br> ><br> > I haven't found any information/description about the user in the database scheme description on the homepage.<br> > Of course it would be nice to extend the users that also (quite) anonymous users with a user token (and a password hash) could login and store their information with Musicbrainz.<br> ><br> >> Musicbrainz also has a rating system that allows people to submit a number between 1 and 5 for most entries but there is not a lot of people that use this<br> ><br> > I also found no information about this on the webpage... I assume that this data is stored in the derived data database?</p> <p dir="ltr">Hi Andre</p> <p dir="ltr">Info about the ratings is in <a moz-do-not-send="true" href="https://wiki.musicbrainz.org/MusicBrainz_Database/Schema#.2A_rating_raw_.26_.2A_meta_tables">https://wiki.musicbrainz.org/MusicBrainz_Database/Schema#.2A_rating_raw_.26_.2A_meta_tables</a> and <a moz-do-not-send="true" href="https://musicbrainz.org/doc/Rating_System">https://musicbrainz.org/doc/Rating_System</a><br> I think the editor tables are undocumented. <a moz-do-not-send="true" href="https://wiki.musicbrainz.org/MusicBrainz_Database/Schema#Undocumented_tables">https://wiki.musicbrainz.org/MusicBrainz_Database/Schema#Undocumented_tables</a><br> </p> <br> <fieldset class="mimeAttachmentHeader"></fieldset> <br> <pre wrap="">_______________________________________________ MusicBrainz-devel mailing list <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> <a class="moz-txt-link-freetext" href="http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-devel">http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-devel</a></pre> </blockquote> <br> </body> </html> --------------040907060100000908070901-- --===============1687563868== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ MusicBrainz-devel mailing list [email protected] http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-devel --===============1687563868==--