Archive for 2007/07

I’m sitting here watching Kevin Hoyt’s FlexCamp preso at about 9:40pm. This event is pretty nice… although security here at the Adobe building south of Market in San Francisco is absolutely nazi, this is definitely a cluetrain event. It’s a conversation with 300-something customers here all toying with beta software trying to build [...]

Based on my geocoded zip code database research, I wound up purchasing the ZipList Can-USA GeoCode database. Here’s what I did to get their 848,000-record CSV file into a PostgreSQL database table. First, create a table to hold the data:
CREATE TABLE tblLookupZipCode (
vchCity varchar(33) DEFAULT ” NOT NULL
,booDST boolean DEFAULT false NOT [...]

Anyone else going to FlexCamp on Friday? I’ll be there… look me up. I’ll have a yellow motorcycle helmet with me. And an IBM Thinkpad, in case there are two nerds with yellow motorcycle helmets.
This has been a busy week of camping for me… I spent Saturday at WordCamp 2007 [...]

Since they launched, I’ve used Mailroom to handle customer support email for my company. Mailroom is awesome because it learns your replies and automatically suggests them to future inquiries. After a couple of major upgrades and some mismanagement on our part, the service had broken down for us and we went back to [...]

I’m preparing to migrate my application to a framework like Model-Glue. Because I have 70 tables and a large API already, I’m afraid of the cutting and pasting required to migrate my code to a Bean/DAO/Gateway structure. Brian Rinaldi’s Illudium PU-36 Code Generator would solve my problem except it didn’t support Postgres 8.x [...]

For the past 7 years, archives for the Bay Area ColdFusion User Group mailing list have been private to protect list members from having their addresses harvested.
Today we switched to using ezmlm-www which hides email addresses and provides RSS feeds. By publishing this post, Google and everyone else should pick up on the archives. [...]