User:Jokipii: Difference between revisions
From MusicBrainz Wiki
Jump to navigationJump to search
No edit summary |
(Added link to my new userscript that tries to make voting on Discogs links easier) |
||
Line 4: | Line 4: | ||
== Currently working with == |
== Currently working with == |
||
I have both MusicBrainz and Discogs databases installed on PostgreSQL. I am currently trying to improve linking between those. |
I have both MusicBrainz and Discogs databases installed on PostgreSQL. I am currently trying to improve linking between those. |
||
== Userscripts == |
|||
[http://userscripts.org/scripts/show/121381 Here] is userscript that makes voting for Discogs links easier. |
|||
== Bot queue == |
== Bot queue == |
||
Line 11: | Line 14: | ||
== Possible future sets == |
== Possible future sets == |
||
Set descriptions and |
Set descriptions and number of links |
||
* Artist (type:group) name with exact (case insensitive) match, have members with Discogs links, all members found that way have been also market as members in Discogs entry. |
* Artist (type:group) name with exact (case insensitive) match, have members with Discogs links, all members found that way have been also market as members in Discogs entry. |
||
** 2083 |
** 2083 |
Revision as of 22:39, 25 December 2011
Who am I?
MusicBrainz editor Jokipii and operator of Jokipii_bot.
Currently working with
I have both MusicBrainz and Discogs databases installed on PostgreSQL. I am currently trying to improve linking between those.
Userscripts
Here is userscript that makes voting for Discogs links easier.
Bot queue
- Artist Discogs links
- Exact name match. Have release(s) with Discogs links. All releases found that way point on same artist at Discogs.
- 4074
- Exact name match. Have release(s) with Discogs links. All releases found that way point on same artist at Discogs.
Possible future sets
Set descriptions and number of links
- Artist (type:group) name with exact (case insensitive) match, have members with Discogs links, all members found that way have been also market as members in Discogs entry.
- 2083
- Artist name with exact (case insensitive) match, is member of groups with Discogs links, all groups found that way have same Discogs artist as member.
- 8692
- Release links identified by exact match on catalog number, release name and linked label. See example
- 32704
- Artist that have Discogs link, and not have type(person/group) set, and have multiple members in Discogs (indicating type:group)
- 1309
- Artist that have Discogs link, and not have type(person/group) set, and have Discogs realname without characters "&,/+" and word "and" (indicating type:person)
- 1699
Bot programming tasks
- Merge bot code to musicbrainz-bot
- Start using discogs-xml2db to produce Discogs database
Some stats
MusicBrainz Total | Discogs Total | Links (all these are not unique) | Percent done (compared to smaller total) | Sum of unique MusicBrainz releases connected to linked entities | Percent of all MusicBrainz releases | Sum of unique Discogs releases connected to linked entities | Percent of all Discogs releases | ||
---|---|---|---|---|---|---|---|---|---|
Releases: | 988301 | 2720810 | 171170 | (17%) | |||||
Release groups: | 822442 | 365081 | 47387 | (13%) | 106445 | (11%) | 277207 | (10%) | |
Artist: | 626598 | 2100250 | 110825 | (18%) | 606737 | (61%) | 1738474 | (64%) | |
Label: | 55844 | 245988 | 16004 | (29%) | 414436 | (42%) see note | 1542803 | (57%) |
note: In MB only 567392 releases have label information, and 420909 don't have.