Derby Datasource: Embedded or Client
I attended CFUnited 2009 last week and I had a really great time. The last presentation that I attended was "Using Apache Derby, the Open Source Database Embedded in ColdFusion 8" by Charlie Arehart. I went to this presentation partly because I am interested in learning more about Apache Derby and partly because I try to catch at least one Charlie Arehart presentation per ColdFusion conference.
As usual for Charlie, the whole presentation was well delivered and packed with useful information. Most significant for me, however, was the difference between the two kinds of Derby datasources.
So what do you use to create your tables in a Derby database? The question came up during the presentation and I could only think of: DataMgr, ColdFusion 9 ORM, write SQL DDL by hand. Did I miss any good options?
I wish I could make it to CFinNC to see you present!