nerd alert: all my lyrics in a word cloud

Links and other hanky panky that doesn't have to do with anything in particular.
Post Reply
User avatar
Manhattan Glutton
Niemöller
Posts: 1530
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

nerd alert: all my lyrics in a word cloud

Post by Manhattan Glutton »

So there's a website that turns lyrics into a word cloud. http://www.wordle.net/
It analyzes the word frequency and places them in a random design where the bigger words are more frequent and the tiny words less.

Additionally, I have all of my lyrics on a private wiki because I'm a crazy person. To grab all of the pages texts I ran this SQL query:
select CONVERT(wiki_page.page_title USING utf8), CONVERT(wiki_text.old_text USING utf8)
FROM wiki_page
INNER JOIN wiki_revision
ON wiki_page.page_latest=wiki_revision.rev_id
INNER JOIN wiki_text
ON wiki_revision.rev_text_id=wiki_text.old_id

And then proceeded to clean up the result.

Well, here's one of the images it generated.
lyriccloud.png
lyriccloud.png (91.6 KiB) Viewed 1892 times
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
User avatar
Billy's Little Trip
Odie
Posts: 12090
Joined: Mon Nov 13, 2006 2:56 pm
Instruments: Guitar, Bass, Vocals, Drums, Skin Flute
Recording Method: analog to digital via Presonus FireBox, Cubase and a porn machine
Submitting as: Billy's Little Trip, Billy and the Psychotics
Location: Cali fucking ornia

Re: nerd alert: all my lyrics in a word cloud

Post by Billy's Little Trip »

Yeah, we have a thread here with that and multiple people made one. I think it was back when the interwebz was invented. :geek:
User avatar
Manhattan Glutton
Niemöller
Posts: 1530
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: nerd alert: all my lyrics in a word cloud

Post by Manhattan Glutton »

I can bet that thread did not include such an awesome SQL statement.
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
User avatar
Billy's Little Trip
Odie
Posts: 12090
Joined: Mon Nov 13, 2006 2:56 pm
Instruments: Guitar, Bass, Vocals, Drums, Skin Flute
Recording Method: analog to digital via Presonus FireBox, Cubase and a porn machine
Submitting as: Billy's Little Trip, Billy and the Psychotics
Location: Cali fucking ornia

Re: nerd alert: all my lyrics in a word cloud

Post by Billy's Little Trip »

You can also bet I don't know what SQL means. :D

Either way, it's cool how it does that. Now I can scratch that off my "they can put a man on the moon, but they can't make song lyrics into a collage" list.
User avatar
jast
Niemöller
Posts: 1339
Joined: Tue Jul 29, 2008 7:03 pm
Instruments: Vocals, guitar
Recording Method: Cubase, Steinberg UR44
Submitting as: Jan Krueger
Pronouns: .
Location: near Aachen, Germany
Contact:

Re: nerd alert: all my lyrics in a word cloud

Post by jast »

Manhattan Glutton wrote:I can bet that thread did not include such an awesome SQL statement.
Neither does this one.
Post Reply