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 in a [...]

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 substring('this is [...]

No Comments

Filed under Uncategorized, postgres, sql