Re: Possible Future Extensions

--===============0540503961==
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="O5XBE6gyVG5Rl6Rj"
Content-Disposition: inline


--O5XBE6gyVG5Rl6Rj
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Mon, May 11, 2015 at 11:16:12AM +0100, Tom Crocker wrote:
> On 11 May 2015 at 11:08, Andre Wiethoff <[email protected]>
> wrote:
>
> >
> > I have read through it and I even analysed the tables in a current
> > snapshot of the Musicbrainz DB.
> > I found the following:
> >
> > All tables called "_rating_raw" are empty!
> > But on the other hand, the "_meta" tables does contain information!!
> >
> > artist_meta: 25215 ratings
> > recording_meta: 219029 ratings
> > work_meta: 1419 ratings
> > label_meta: 602 ratings
> > release_group_meta: 65150 ratings
> >
> > Most probably the "_rating_raw" tables are aggregated and then deleted
> > afterwards?
> > I assume that the exact editor/rating values are lost forever? This
> > would really a pity to loose so many recording rating information
> > (groupable to editors/users)...
> >
> > Would it be possible to not delete the rating information in the future?
>
>
> Editors can get / set their individual ratings on the site and (I think)
> through the webservice. So they aren't 'lost'.
> As I understand it, user data like this gets removed from the downloadable
> database. I think it's seen as a privacy issue.

They can be gotten for individual things in the webservice with
inc=user-ratings (and user-tags), though there isn't a bulk export. See
http://tickets.musicbrainz.org/browse/MBS-4948 for that.

> _______________________________________________
> MusicBrainz-devel mailing list
> [email protected]
> http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-devel


--O5XBE6gyVG5Rl6Rj
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iEYEABECAAYFAlVQiDsACgkQq+0avXExp29cwQCgn2BCACvV5ZUZyKz+Do/xE7Cd
xxYAnigQHqGBs9V/8itZ/G5KqFvjG8IL
=u+KN
-----END PGP SIGNATURE-----

--O5XBE6gyVG5Rl6Rj--


--===============0540503961==
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
--===============0540503961==--