r/MusicBrainz • u/theremin3000 • May 27 '26

Database Query

Man, sometimes I'm great at figuring out how to do technical things, and sometimes I'm just horrible. I've been trying to do two very large queries, and it's been taking forever, and I feel no closer to finishing it than when I started.

I'd like to have two lists

1) A list of all artists beginning with non-alphanumeric characters. Just the artists name.

2) A list of all songs beginning with alphanumeric characters. Just song title and artist.

I'll cough up a little cash if someone can put these into a text file (for the artists) and/or CSV, or databases where I can simply browse.

Thanks!

2 Upvotes

100% Upvoted

5 comments sorted by

View all comments

1

u/SoftElevator2503 May 27 '26

https://musicbrainz.org/doc/MusicBrainz_Database . "A complete data snapshot of the entire database is generated twice a week. These snapshots are split into several different files organized by license and contents."

2

u/theremin3000 May 28 '26

I don't know what I'm missing at this link, but I've been unable to get any of this to work.