DerbyCFC: New Project with createIfNotExists function for Derby Databases
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.