Sam Farmer

Growing up I never imagined I would play bass guitar for the Dave Matthews Band. And indeed it never happened.

But I have become passionate about making software.

DerbyCFC: New Project with createIfNotExists function for Derby Databases

January 20, 2008

I've just released version 0.9 of DerbyCFC on RIAForge which is designed to make it easier to work with the Derby database embedded in ColdFusion 8.

DerbyCFC comes with two functions; createIfNotExists which does pretty much what it says and will create a new Derby datasource and database. getDerbyDatasources returns all Derby datasources in either raw format (a collection of structures) or as a query with a slightly smaller set of attributes.

The download zip includes example pages for creating a datasource and listing of current datasources. Go to the DerbyCFC project page.

I'm debating whether to extend this to provide a UI that would list and edit tables in a Derby database so let me know your thoughts. My hope is that this will make it easier to create Derby databases for other open source projects.

No Comments

Some comments have been lost over the years due to moving hosts.


More blog entries that I have written.

Code coloring by PRISM.