It would be interesting see in action all functions with a big table of artists.
If you want you can download MusicBrainz's artist JSON dumb (~ 400Mb) and the convert to CSV file with name column only (~1.5 Million artists) to import in PostgreSQL with COPY command.
Comment
Great article Peter.
It would be interesting see in action all functions with a big table of artists.
If you want you can download MusicBrainz's artist JSON dumb (~ 400Mb) and the convert to CSV file with name column only (~1.5 Million artists) to import in PostgreSQL with COPY command.
$ wget http://ftp.musicbrainz.org/pub/musicbrainz/data/json-dumps/20190227-001001/artist.tar.xz
$ xzcat artist.tar.xz | tail -n +112 | head -n -1 | jq '[.name] | @csv' > artist.csv