Hey! I am looking for advice on how to use the downloaded data from (http://ftp.musicbrainz.org/pub/musicbrainz/data/f…) So if I untar this, how do I establish a client to it? It doesn't seem to be SQL files...
2023-02-03 03414, 2023
derwin
if you're looking to run musicbrainz as a service, starting from the full export is probably not what you want to do
(to clarify, you want to use the dump at the appropriate step in the above process, instead of outside of that context)
2023-02-03 03414, 2023
Sum
Hey derwin! Nope just trying to sort and filter some data out. Yeah, there are some API clients which are probably better, but I am still trying to wrap my head around the ER model
2023-02-03 03459, 2023
derwin
if they're not SQL files, what *are* they? CSVs?
2023-02-03 03418, 2023
derwin
if they're CSVs, you would load them into a schema created by : "./admin/InitDb.pl --createdb --clean
2023-02-03 03439, 2023
derwin
yeah, looks like (T)CSVs
2023-02-03 03439, 2023
Sum
Ah, they didn't have an extension. Thank you :) I wanted to make a fan site and create a more accurate discography for a niche artist I like. I started scrapping (following best practices, tos, etc) for YouTube Music, Discogs, Deezer, Spotify, Genius, etc and then realized how unstandardized it is across providers and how much more complicated
2023-02-03 03440, 2023
Sum
music related data models (specifically for streaming services) are, especially in comparison to how people just think of it
2023-02-03 03412, 2023
derwin
yeah. and lots of services are ... badly modeled, or just plain don't model things
2023-02-03 03443, 2023
Sum
and the things "we" (or at least I) care about (songs, their lyrics and when they were produced) are second fiddle to things like link to the 10x versions of the album released in different markets (which I care less about, but is still kind of important). Not to mention, extended versions, alt versions, remixes, naming conventions "Track --
2023-02-03 03443, 2023
Sum
Extened" vs Track (Extended) vs "Track Ext" vs Extended Track, etc and it is painful
2023-02-03 03457, 2023
Sum
and here is MusicBrainz which I can use as a scaffold to map meta data from these streaming services too
2023-02-03 03459, 2023
Sum
maybe...
2023-02-03 03406, 2023
Sum has quit
2023-02-03 03417, 2023
kjoye joined the channel
2023-02-03 03437, 2023
kjoye
hi
2023-02-03 03410, 2023
kjoye
is it possible for any admin to check whether my userid is taken in https://musicbrainz.org/ database? I mean is there anyway to see it is taken other than the registration part telling me it is already taken?
not sure if this is the right place but i have a physical cd that i was going to rip to flac. the album is in musicbrainz but the discid wasnt associated with it so i submitted that. the problem is now that the artists real name is used rather than his performance/artist name. whats the best/correct way to change the artist name for an album?
2023-02-03 03451, 2023
}8]
specifically, the album is "The Second Coming" by "Roger Troutman II" (his artist/performer name), but in musicbrainz its listed at "The Second Coming" by "Roger Troutman Jr." (his real name)
2023-02-03 03425, 2023
outsidecontext
}8]: If that's how he is credited on the cover than the artist credit on the release should be changed to "Roger Troutman II" I think
2023-02-03 03438, 2023
outsidecontext
If you edit the release on MB you can click on the edit button next to the artist name. There you can enter a name how the artist should be credited (which can be different from the main display name of that artist)
2023-02-03 03408, 2023
}8]
yup, thats how hes credited on the cover. you can even see it in the artwork thats already uploaded for the album
2023-02-03 03409, 2023
}8]
for an edit note should i just put something like `these edits correct info to match the physical release`?
2023-02-03 03449, 2023
outsidecontext
}8]: most importantly I would reference the cover, especially if it is available for this release.
2023-02-03 03400, 2023
}8]
the cover/booklet is already uploaded so i didnt even have to scan it. should i just say `please refer to the albums artwork` or provide the actual url to the artwork tab?
2023-02-03 03453, 2023
ArjunM joined the channel
2023-02-03 03438, 2023
}8]
i submitted the edit and refreshed but its not fixed. do edits need to be approved by someone before they're `live` or??
edits can be approved early by so-called "autoeditors", but they'll also automatically apply after a week depending on the result of voting.
2023-02-03 03421, 2023
Sum
Anyone here familiar with musicbrainzngs client? I call
2023-02-03 03422, 2023
Sum
`aid = 'id of the person I am currently searching data for'`
2023-02-03 03422, 2023
Sum
`artist = mbz.get_artist_by_id(aid, includes=['works'])` and `artist['artist']['work-count']` yields 63
2023-02-03 03423, 2023
Sum
Then
2023-02-03 03423, 2023
Sum
```
2023-02-03 03424, 2023
Sum
paginated_work_search = mbz.search_works(
2023-02-03 03424, 2023
Sum
query='',
2023-02-03 03425, 2023
Sum
limit=100,
2023-02-03 03425, 2023
Sum
offset=0,
2023-02-03 03426, 2023
Sum
strict=True,
2023-02-03 03426, 2023
Sum
arid=aid
2023-02-03 03427, 2023
Sum
)
2023-02-03 03427, 2023
Sum
```
2023-02-03 03428, 2023
Sum
`print(paginated_work_search['work-count'])`
2023-02-03 03428, 2023
Sum
yields 57.
2023-02-03 03429, 2023
Sum
So what do I do... get_artist_by_id doesn't have a limit / offset option.... Adding `aliases` to `get_artist_by_id`, doesn't give me aliases IDs to check against...
2023-02-03 03440, 2023
}8]
thanks for the info kepstin. i only just created a musicbrainz login to submit the discid and correct the artist name so hopefully whoever votes on it will give it a look and a thumbs up.
2023-02-03 03422, 2023
petitminion joined the channel
2023-02-03 03434, 2023
outsidecontext
Sum: I'm not quite sure I understand what your question is. Your second query seems to be allright. Instead of a search query you could also do a lookup, e.g. https://musicbrainz.org/ws/2/work/?&artist=f6…
2023-02-03 03459, 2023
outsidecontext
Sum: but in general development questions are better asked in #metabrainz, that's the development focused channel
2023-02-03 03436, 2023
phw_ joined the channel
2023-02-03 03445, 2023
phw_ has quit
2023-02-03 03403, 2023
phw joined the channel
2023-02-03 03447, 2023
Krystof has quit
2023-02-03 03454, 2023
Sum
outsidecontext, hmmm I can try just using the python `requests` library to make the API calls. It is that there in the link you provided there is the `work-count":677` and calling, from the python module, `get_artist_by_id` (asking for works) vs `search_works` gets two different work-counts. Also the python api makes so that
2023-02-03 03454, 2023
Sum
`artist=<artist-name-as-str>` and `arid` is artist id. So a bit of a different mapping.
2023-02-03 03455, 2023
Sum
Regardless it is a good idea to try pop open the hood, check out what api call `get_artist_by_id` actually does, then compare to native API requests to see if there may just be an incorrect record somewhere. `work-counts` could be an aggregated variable that gets incremented / decremented upon update and in one place it could be out of sync vs
2023-02-03 03455, 2023
Sum
listing all work records with `arid=<id>`
2023-02-03 03412, 2023
Sum has quit
2023-02-03 03450, 2023
Sum joined the channel
2023-02-03 03440, 2023
ArjunM has quit
2023-02-03 03443, 2023
ArjunM joined the channel
2023-02-03 03405, 2023
ArjunM has quit
2023-02-03 03443, 2023
Cheezmo_ has quit
2023-02-03 03400, 2023
Cheezmo_ joined the channel
2023-02-03 03402, 2023
Sum has quit
2023-02-03 03437, 2023
petitminion has quit
2023-02-03 03434, 2023
petitminion joined the channel
2023-02-03 03432, 2023
petitminion has quit
2023-02-03 03405, 2023
otrocodigo[m]
hi. the variant (audio comentary, instrumental, symphonic, etc) of a track is placed in the same 'recording'?
2023-02-03 03417, 2023
reosarevok
No
2023-02-03 03441, 2023
reosarevok
Different recordings for different audio
2023-02-03 03452, 2023
reosarevok
Also for stuff like stereo vs mono
2023-02-03 03429, 2023
petitminion joined the channel
2023-02-03 03402, 2023
Sciencentistguy1 joined the channel
2023-02-03 03441, 2023
Sciencentistguy has quit
2023-02-03 03441, 2023
Sciencentistguy1 is now known as Sciencentistguy
2023-02-03 03403, 2023
petitminion_ joined the channel
2023-02-03 03408, 2023
petitminion has quit
2023-02-03 03458, 2023
Krystof joined the channel
2023-02-03 03426, 2023
trolley has quit
2023-02-03 03433, 2023
uniq joined the channel
2023-02-03 03432, 2023
uniq
Hey I am new here, I just recently tried to set up listenbrainz-sever on my local machine using docker while trying to solve LB-1011, I added a save data header to global props as well as to listen card in the front end but when I try to test the it out the localhost redirects me to actual MusicBrainz site whenever I click a song, I may be missing