Brainzers around the world

Nikki and I are randomly hacking on MusicBrainz when I became curious about the distribution about brainzers around the world. One SQL query later we have: country | count ———+——- fr | 1664 de | 1498 uk | 1031 dk | 746 ru | 670 nl | 454 pl | 409 ca | 348 au … Continue reading “Brainzers around the world”

Nikki and I are randomly hacking on MusicBrainz when I became curious about the distribution about brainzers around the world. One SQL query later we have:

country | count

———+——-

fr | 1664

de | 1498

uk | 1031

dk | 746

ru | 670

nl | 454

pl | 409

ca | 348

au | 271

it | 270

This is compiled from email addresses of registered users that use their country top level domains. This obviously cuts out all the .net, .com, .org addresses, which is a lot of people. But this gives a decent idea of the reach that MusicBrainz has into the nooks and crannies of the planet. It turns out that we have members from 105 countries, which if we’re counting 238 country tlds, that comes to 44%. Wow!

Read on for the complete list…

Continue reading “Brainzers around the world”

Trackback spam — no more.

I really removed trackback support from this blog (the trackback cgi is not executable anymore — take that!). I also removed all the trackback links from the templates… Thus, no more trackbacks which is sad, but no more spam, which is good.

I really removed trackback support from this blog (the trackback cgi is not executable anymore — take that!). I also removed all the trackback links from the templates…

Thus, no more trackbacks which is sad, but no more spam, which is good.

New servers purchased

Great news folks! We just purchased two new servers: Dual 2.4Ghz Xeon Supermicro 1U servers 4GB RAM SCSI III support 1 server has 1 72GB hot swap drives and the other has 2 Each one was a whopping $950 — a really awesome deal! Now I need to purchase a RAID controller and we can … Continue reading “New servers purchased”

Great news folks! We just purchased two new servers:

  • Dual 2.4Ghz Xeon Supermicro 1U servers
  • 4GB RAM
  • SCSI III support
  • 1 server has 1 72GB hot swap drives and the other has 2

Each one was a whopping $950 — a really awesome deal! Now I need to purchase a RAID controller and we can give the TRM server its own machine, which should alleviate some of the bottlenecks we’ve been seeing.

mb.org

Jamie Munro suggested looking into purchasing the mb.org domain, so I put in a (joking) offer of $50. The owner replied telling me that he paid over 20 times that and that he would not go for it. No surprise there. So, next time we have $1000 to splurge on a nice shortcut domain, we … Continue reading “mb.org”

Jamie Munro suggested looking into purchasing the mb.org domain, so I put in a (joking) offer of $50. The owner replied telling me that he paid over 20 times that and that he would not go for it. No surprise there. So, next time we have $1000 to splurge on a nice shortcut domain, we could consider doing this.

Thus, chances of this happening are next to nil. At least we tried. πŸ™‚

Unwrapping the thanksgiving present

whicken sent MusicBrainz a Thanksgiving Day present that consisted of nearly 3000 AR relationships, and I finally had the chance to import the data and play with it. A few of URLs to check out: 2Pac Bono The Rolling Stones I didn’t know that 2Pac == Makavelli — I’m getting excited about AR. Can you … Continue reading “Unwrapping the thanksgiving present”

whicken sent MusicBrainz a Thanksgiving Day present that consisted of nearly 3000 AR relationships, and I finally had the chance to import the data and play with it. A few of URLs to check out:

I didn’t know that 2Pac == Makavelli — I’m getting excited about AR. Can you tell? If you want to see the data whicken sent our way, look here.

Thanks tons Wendell!! (whicken)

Back to Advanced Relationships I trudge…

The last two weeks were pretty much dedicated to trying to make ends meet. Fortunately I managed to get some contract work that paid fairly well and was somewhat related to my spare time projects like MusicBrainz and XSPF. In the last two weeks I managed to earn 1/4 of what I earned all of … Continue reading “Back to Advanced Relationships I trudge…”

The last two weeks were pretty much dedicated to trying to make ends meet. Fortunately I managed to get some contract work that paid fairly well and was somewhat related to my spare time projects like MusicBrainz and XSPF. In the last two weeks I managed to earn 1/4 of what I earned all of last year. That speaks highly of the last two weeks and poorly on the last year.

The upshot is that I have time to get back to MusicBrainz hacking. That means I’m back on the project that won’t die: Advanced Relationships. Every time I think I am done, someone points out 2-3 new problems that set me back another week. Its been like this since the end of December, and its getting a bit frustrating. The positive thing about this is that I’m doing AR right — no ‘lets put this out there and we’ll make if work really well later‘. Besides, every-time I’ve half-assed a feature on the server, everyone has always let me know what they think, and its never pretty. πŸ™‚

Continue reading “Back to Advanced Relationships I trudge…”

TRM Database Pruned

It’s TRM pruning time again.

At about 2300hrs UTC on January 25th the TRM database
was “pruned” again. 
As we did last time, we removed all TRMs apart from the ones attached to
MusicBrainz tracks, this time using the additional criterion that
the TRM had to have been looked up at least twice. 

Just before the prune we had about 3633572 TRMs; after the prune we had about 1898435. 
For pretty pictures illustrating this, check out our
MRTG pages.

See also prune 1,
prune 2
and prune 3.

Server Made Simple

In the past, installing a MusicBrainz server has always been a testing and lengthy task, without any clear-cut set of instructions to follow. Over the last few days I’ve been putting together a method of installing mb_server, starting from scratch, using Debian. Installing the server just got a lot easier.

In the past, installing a MusicBrainz server has always been a testing and lengthy task, without any clear-cut set of instructions to follow. Over the last few days I’ve been putting together a method of installing mb_server, starting from scratch, using Debian. Installing the server just got a lot easier.

Continue reading “Server Made Simple”

AR todo list

If you’ve been lusting for the new Advanced Relationships feature in MusicBrainz, take a look at our AR Todo list. We need to complete this list of tasks before we release AR on the world. We’re now officially done with the features, but we still need to do some performance tweaking and behind the scenes … Continue reading “AR todo list”

If you’ve been lusting for the new Advanced Relationships feature in MusicBrainz, take a look at our AR Todo list.

We need to complete this list of tasks before we release AR on the world. We’re now officially done with the features, but we still need to do some performance tweaking and behind the scenes futzing.

If you’d like to play, please go to the test server!

But keep in mind that the relationships on the test server will change! (They should be more complete and suck less for the first release.)