Archive for the 'Web/Internet' Category » Page 19

RSESSION is a database-backed session management system I built for ColdFusion 4.5 when there was no support for failover and serious issues with locking. It’s been six years since its last release. Last year, Jason Baker provided a CFC-based implementation which I have rolled into the package. I’m releasing this for completeness [...]

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

Announced today, Sunbird and Lightning, the Mozilla Calendaring project (one standalone, one integrated) has released a major update. Time to throw this into the mix with my end-to-end synchronization project and see how it fares.
First 30 second impressions are slightly nicer UI and it’s a little bit faster. Uninstalling 0.3 and installing 0.5 [...]

Thanks to Dan, I took a look at jQuery today. Although Alex Russell convinced me at a 106 Miles meeting some 18 months ago to use Dojo, I’ve grown tired of waiting for the API to stabilize and have been looking for something else that I could use to Get Things Done. What [...]

Quick tip – if you use PostgreSQL, you should look into the INTERVAL data type. It’s a great way of expressing periods of time without using actual dates and makes things like calendaring and recurring events very easy.
Unfortunately, ColdFusion’s CFQUERYPARAM doesn’t have support for the INTERVAL type so I had to hack around to [...]