Twitter
- @andreypopp I couldn't get used to the matrix-based programming style in Python. I tried that, but I'm finding to like Matlab/Octave better. 1 week ago
- Playing with Matlab for the first time in my life. Why didn't I do this kind of stuff when I still was at the uni? http://t.co/rdQNfYLZ 1 week ago
- "What I found was your name all over the place!" is the best acknowledgement of your open source programming work I've ever heard. :) 2 weeks ago
- Please somebody say this is a joke. Firefox 9 apparently doesn't allow me to visit HTTPS sites with self-signed certificates. 2 weeks ago
- @uwwwx It can, but it's probably not particularly good at it (I've not tested though). Everything in there is heavily optimized for music. 3 weeks ago
Links
Categories
Archives
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- August 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- January 2010
- December 2009
- November 2009
- October 2009
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
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 Database, MusicBrainz, postgresql, python, replication
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
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 Database, plpgsql, postgresql, sql, uuid
Leave a comment