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.
nerd alert: all my lyrics in a word cloud
- 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
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
Nur Ein Archives | The New Ugly Podcast
- 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
Yeah, we have a thread here with that and multiple people made one. I think it was back when the interwebz was invented. 
- 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
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
Nur Ein Archives | The New Ugly Podcast
- 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
You can also bet I don't know what SQL means. 
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.
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.
- 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
Neither does this one.Manhattan Glutton wrote:I can bet that thread did not include such an awesome SQL statement.