LyricWiki + Pedlr = Awesome!

February 22, 2007

LyricWiki has now been rolled into the same design as Pedlr.

Pedlr is a social marketplace, meaning that musicians can sell their content directly from their profiles! By blending traditional networking with these ecommerce features, bands now have the power to take their act to the next level even if they aren’t signed!

The site will be officially… formally… um… publicly launching on February 26th. We need as many bands and users on there as we can get! The value of a network grows exponentially with the number of nodes (that’s you!).

The same way that LyricWiki used ÜberBot to crawl the internet and build a critical-mass of lyrics… now I’m counting on the LyricWiki community to sign up, and bring your friends! If the thousands of LyricWiki users join the site, Pedlr is going to be an amazing place full of great content!

Pleeeeease join Pedlr!


Server is… wow, that’s fast!

February 12, 2007

The site is back up now, and dang is it fast!

I expected that moving the database to a special server with a ton of RAM would make it faster during peak times, but I’ve never seen a MediaWiki run anywhere near this fast even on a localhost.

And for loyal LyricWiki fans, I’ll point you to Pedlr.com where our new site has just soft-launched. I went on a leave of absence from school and I’ve been working fulltime on Pedlr for the last 4.5 months. I’m really proud of it and I hope you dig it!

Pedlr is the first “Social Marketplace” which means that it works like a social networking site except that content creators (namely musicians to start) can sell their content directly through their profiles and keep the vast majority of the revenue. Pedlr is commercial in nature, and it’s the money from Pedlr that’s going to be paying for that rediculous server upgrade… I can’t get over how fast it is! *is overly excited*

Anyway, the site is soft-launched which means that it’s up, but we’re not telling the press just yet (you can still tell your friends). I’d really appreciate it if you took a second to swing by Pedlr and give me your thoughts. Thanks!
– Sean Colombo


Currently moving database… (site will be down)

February 12, 2007

I’m going to move the database to the new server now, so LyricWiki will be temporarily unavailable for a couple of hours.

Please feel free to pass the time on the just-launched <a href=’http://www.pedlr.com’>Social Marketplace</a>, <a href=’http://pedlr.com’>Pedlr</a&gt;.  It’s just the soft-launch and has only been live for like 2 hours now, so it is in drastic need of members!

LyricWiki will be back up shortly…


Pedlr is coming soon :)

February 8, 2007

I’ve mentioned a couple of times before that LyricWiki will be merging with another, equally über site in a short time.

Well, now it’s a really short time. If you would like to be informedwhen the site’s soft-launch is ready, go to Pedlr.com and enter your email address. As always, we will never sell or give away your email address.


Survey Results

February 1, 2007

Many of you may have noticed that there was a link to a quick 3-question survey on the lyrics site for a little more than a week.

There was a decent response (for a survey), and we ended up getting 610 valid responses before I took it back down to start processing it.

The survey asked for age, gender, and favorite genre of music.

Here are the highlights:

  • 75.08% male, 24.91% female.
  • Average age of 21.57 years old
  • Median age was tied between 17 and 18 years old (see below)
  • People whose favorite genre is Metal are 94.83% male, but otherwise the genres are fairly evenly balanced.

How the stats were processed…

Results with entirely impossible ages were removed (the oldest person alive is 113 right now, so no LyricWiki users are 1,000 years old). There were only a couple of them, and the 610 results is the number that were left after removing these results.

Genres were combined – so “Rock”, “rock”, and “R0ck!!!!” were all treated the same. Some of the genres are close to each other, but not enough that I combined them (“East coast hip-hop” versus “hip hop” and “Everything” versus “None”).

Below are stats on the most popular genres, and a link to the mySQL data file of the results (after grouping genres together)…

NOTE: The number of items shown in each list are not nice round numbers, but they were chosen so that there was a “clean cutoff” meaning that if two genres were tied with 4 votes, either both were shown or neither.

Top 29 Genres

mysql> select genre,count(*) from quickSurvey
group by genre order by count(*) desc,genre
limit 29;
+------------------+----------+
| genre            | count(*) |
+------------------+----------+
| Rock             |      148 |
| Metal            |       58 |
| Alternative      |       46 |
| Indie            |       44 |
| Pop              |       35 |
| Punk             |       22 |
| Hip hop          |       17 |
| Classic rock     |       12 |
| R&B              |        8 |
| Electronica      |        7 |
| Everything       |        7 |
| Gothic           |        7 |
| Hard rock        |        7 |
| J-pop            |        7 |
| Progressive rock |        7 |
| Ska              |        7 |
| Country          |        6 |
| Jazz             |        6 |
| Trip hop         |        6 |
| Christian        |        5 |
| Japanese Rock    |        5 |
| Electronic       |        4 |
| Emo              |        4 |
| Folk             |        4 |
| Grunge           |        4 |
| Heavy metal      |        4 |
| None             |        4 |
| Soundtracks      |        4 |
| Trance           |        4 |
+------------------+----------+
29 rows in set (0.00 sec)

Top 9 Genres for Males

mysql> select genre,count(*) from quickSurvey where
gender='M' group by genre order by count(*) desc,genre
limit 9;
+--------------+----------+
| genre        | count(*) |
+--------------+----------+
| Rock         |      109 |
| Metal        |       55 |
| Alternative  |       31 |
| Indie        |       28 |
| Pop          |       19 |
| Punk         |       18 |
| Hip hop      |       14 |
| Classic rock |       11 |
| Ska          |        7 |
+--------------+----------+
9 rows in set (0.01 sec)

Top 7 Genres for Females

mysql> select genre,count(*) from quickSurvey where
gender='F' group by genre order by count(*) desc,genre
limit 7;
+-------------+----------+
| genre       | count(*) |
+-------------+----------+
| Rock        |       39 |
| Indie       |       16 |
| Pop         |       16 |
| Alternative |       15 |
| J-pop       |        5 |
| R&B         |        5 |
| Punk        |        4 |
+-------------+----------+
7 rows in set (0.00 sec)

Ages

mysql> select age, count(age) as numUsers from
quickSurvey group by age order by numUsers desc limit 17;
+------+----------+
| age  | numUsers |
+------+----------+
|   18 |       65 |
|   17 |       65 |
|   15 |       52 |
|   16 |       49 |
|   19 |       42 |
|   21 |       37 |
|   20 |       33 |
|   14 |       27 |
|   25 |       25 |
|   22 |       25 |
|   13 |       25 |
|   23 |       22 |
|   26 |       17 |
|   24 |       15 |
|   27 |       11 |
|   28 |        7 |
|   29 |        7 |
+------+----------+
17 rows in set (0.00 sec)

If you want to run your own tests on the data, you can grab a copy of the mySQL dump of the stats.