Note: This blog post is from 2007. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.Had you noticed that one of the many hidden gems in CF8 is the Apache Derby open-source, cross-platform database engine embedded in CF8. You're free to use it for production. Why would you? How does it differ from other free databases like MySQL?
To answer those questions and more, I've created a new resource called, "Getting Started with the Apache Derby Open Source Database in CF8". It's a resource compendium for those interested in using the DB with CF, pointing you to general resources to learn more, linking to many CF-specific articles and blog entries on it (from both before and after the final CF8 release), and lots more to help you get started--as well as respond to some common misconceptions.
It will continue to evolve, but for now, the sections are:
- General Resources for Learning More about Derby
- Is it a pure development only DB?
- Is this the same database engine that's embedded in Adobe Air?
- I've heard that Derby is a single-user DBMS
- How can we use it/enable it in ColdFusion?
- Are there any IDE or query tools for talking to Derby?
- Why use Derby database verses using something like MySQL?
- Where can I find a reference for supported SQL, etc.?
- Is there a way to automate creation of a new Derby Database in CF?
- Where else can I learn more from other CFers using Derby?
I'll also point out that those interested in Derby, especially in discussing it with others, will want to know that a couple of weeks ago I started a Derby "community" on the coldfusioncommunity.org site. Anyone may join in. I'll note that I rolled all my answers to questions there, prior to December, into the getting started page above.
Let me know what you think of it, and certainly any additions or corrections you'd suggest.