Entries from January 2008

Thursday, January 17th, 2008

Mass E-mailing, worth paying for a service

Most of us have written little mass e-mailing scripts in the past. No big deal, connect to SNMP, loop through our subscriber list, do our thang. But then the requirements come in: “ “Hey, I need to know what person is clicking on that link, and what time they opened it.” “How does it look [...]

2 Comments

Filed under email, review

Wednesday, January 2nd, 2008

Postgres select replace with regular expression

Postgres seriously kicks ass, here's a quick way to do a substring based on a regular expression. A Co-worker wanted to get the first word out of a column that contained a sentence. If we were using something lame like oracle we'd have to do gymnastics to do that. It's a one-liner in postgres. SELECT [...]

No Comments

Filed under postgres, sql, Uncategorized