Tag Archives: Database

Acoustid database dump available

Posted on January 12, 2011 by Lukáš Lalinský

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

Posted on October 30, 2010 by Lukáš Lalinský

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…

Posted on June 16, 2010 by Lukáš Lalinský

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

Posted on October 21, 2009 by Lukáš Lalinský

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