Open Sourcing Personal ColdFusion Projects
CURRENT NAME: cfOto (see-ef-oh-toe)
SUMMARY: Digital Camera Photo Manager
DETAILS: I have this ColdFusion script that is automatically launched by WindowsXP when my digital camera is plugged in (or SD Card is inserted into my media bay). The script pulls all the photos off the card an organizes them into folders based on Month/Year the photo was taken. Thumbnails are automatically generated (using a separate open source project, looking into the details of how to handle using this in my own project, several options are available, I will use which ever is easiest to distribute/install, Scorpio will make the 3rd party project obsolete). Then you are given an administrator to view all your photos, title them, rotate, delete, all the basics. You can re-organize the photos into sub folders based on events within your month (or however you like). You can select photos to FTP to a remove server, where a public/non-administrator version of the photo browser is automatically created on the fly. You can also select photos and have them sent to your Flickr account. No database required. XML is used for all the data storage. This project will be a major example of using XML as a data storage in my upcoming CFUNITED 2007 presentation this June.
OPEN SOURCE GOALS: I have a long list of new features I would love to add to the project (photo cropping and other adjustments, multiple templates, Flex/Flash front-end options, etc).
REQUIREMENTS: You need a local ColdFusion server running on your machine you are plugging your camera into. ColdFusion MX (6 should be good enough).
CURRENT NAME: cfQueryParam Tools
SUMMARY: Tool set for analyzing debugging output from queries using CFQUERYPARAM tags
DETAILS: Debugging output for queries using CFQUERYPARAM tags can be a little obfuscated since the SQL and the param values are separated. I have a series of simple tools I have built where you paste in the debugging output and it spits out the generated SQL statement, ready to throw into MySQL Query Browser or MS SQL Query Analyzer. There are also tools that give you the lengths of all the params so you can track down your truncation error culprit.
OPEN SOURCE GOALS: A) Improve the current tools, and B) Expand the tool set to include other tools that CF developers would find useful.
REQUIREMENTS: ColdFusion MX (6 should be good enough).