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.