Tag Archives: Database

Acoustid database dump available

I’ve finally written a script to take a consistent dump of the Acoustid database in the PostgreSQL tab-separated format used by the COPY command. I do not have any tools for importing it into PostgreSQL, so it has to be … Continue reading

Posted in Acoustid | Tagged , , | Leave a comment

MusicBrainz database replication

I wanted to work on the Acoustid lookup web service and for this I needed to setup a MusicBrainz replicated database slave. Normally I’d use the Perl code from mb_server, but I didn’t want to mess up the setup I … Continue reading

Posted in MusicBrainz, Tools | Tagged , , , , | 1 Comment

Oracle…

Working with Oracle is always an adventure. The error messages are usually not very helpful, so you have to guess a lot. What I’ve seen today is an extreme though. Oracle allows you to create a table with a column … Continue reading

Posted in Database, Rants | Tagged , , | Leave a comment

UUID generator in PL/pgSQL

While writing an SQL script to upgrade the MusicBrainz database for the last release, I needed a way to generate new UUIDs from SQL. PostgreSQL has a native UUID data type and a contrib module for generating UUIDs since version … Continue reading

Posted in Database, MusicBrainz, Programming | Tagged , , , , | Leave a comment