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: postgresql
Easier MusicBrainz NGS database setup
Some time ago I wrote a couple of tools that help me set up and update a mirror of the MusicBrainz database on the Acoustid server. It turned out to be work really well. Recently I’ve seen a few people … Continue reading
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
Acoustid
After asking for fingerprint test data in my last post about Chromaprint I received about 270k fingerprints from. This helped me to perform some larger tests on the proof-of-concept lookup server I had implemented using Java and PostgreSQL. I had … Continue reading
Posted in Acoustid, Announce, Programming
Tagged acoustid, audio, chromaprint, fingerprinting, java, MusicBrainz, postgresql
5 Comments
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