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

Excerpted : Is that a database in your pants?

Friday June 13 2003


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


 $> 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.


TODO : ←  → Ed Bilodeau : Regarding the lack of RSS.