today | current | recent | random ... categories | search ... who ... syndication

Excerpted : Is that a database in your pants?




Friday June 13 2003



Montreal







The other day I finished importing five years of email into a database



so I could do full text searches on it.







Because I have a potty-mouth, I discovered that out of a possible 32,



000 messages fewer than 400 contain both the words "fuck" and "shit".







<snip />







Part of my struggle ... was trying to remember how to set the auto-increment



counter for a field in one of the database tables.







Would that I were able to find what I needed in the docs, but I knew



that the answer was buried somewhere in an old email message. So I



typed...







 $> findmail -date 2002 -term '(auto increment)'







...and, lo, there it was!







Some day, I'll make paintings about all this crap. You'll see...



This one's for Ed whose weblog is beginning to look more like an unindexed piece of email with each passing day.

meta

 
TODO : Image::Shoehorn::Gallery.pm ←  → Ed Bilodeau : Regarding the lack of RSS.