Twitter
- @brianfreud Probably not, but Acoustid will be the default option in the next version so I will definitely see some more usage from Picard. 3 weeks ago
- I'm pretty impressed with Windows 8. Wouldn't use it on my dev machine, but it works perfectly on a TV. 4 weeks ago
- Very interesting talk about copyright protection. http://t.co/4HvmMQ2N 1 month ago
- Oh, it's finally here. New GMail look without an option to go back. :( 1 month 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