Apache Derby is an open source relational database implemented entirely in Java – it has a tiny footprint (2MB or so), includes an embedded JDBC driver, and supports both simple local access as well as client-server type access.
So what does this have to do with ColdFusion? Well, Jason Delmore mentioned this in passing at cf:Objective (and few picked up on it), but we plan to include Apache Derby in ColdFusion Scorpio. The practical implication of this is that if you have to distribute an app that needs a database, you’ll now have one that will work consistently on all platforms (no more having to tinker with different databases on different platforms).

16 thoughts

  1. this is good, esp for a quick bit of ad-hoc development. I’m sorry I downloaded MySQL for my Mac now, I hardly use the flamin’ thing…
    just thinking out loud…. (and for client use, not server)
    I wonder if this brings the idea of an embedded database closer to Apollo?

  2. That’s very cool. If for no other reason that there would be a standard for all sample aps so people wouldn’t have to avoid this db or that db if they didn’t have it installed.

  3. Great news Ben, I have been keen to use Derby in the past for ColdFusion applications. It provides great potential, especailly in local access mode.

  4. Adam, agreed, and I intend to use it for the examples in the next CFWACK.
    Sam, I don’t have lots of experience with it, but, we do support two modes … a local access mode which is a lot like Access, and a client-server mode where CF connects to a remote server (much like MySQL or other server DBMSs). As for db size, I don’t know, but I have heard that there are some pretty big .com sites running it. I won’t share names as I don’t know this as a fact.
    — Ben

  5. Now… this is defitely another move in the right direction. (I had not even considered asking for this because CF works so great with databases to start with!) KUDOS Jason and the Scorpio team!

  6. This is great news . . . will definitely give me some ideas. I hope this is going to be well documented for those of us who may be doing something like this . . .

  7. Aaron, ther is no reccommended UI at this point, use whatever you want, or just use <CFQUERY> tags. I am indeed using SQuirreL, which is decent, but not great. I also have the Derby Eclipse plug-in which is ok as a command-line tool. Honestly, I’ve not seen a great Derby GUI client yet.
    — Ben

  8. Ben,
    Team Technology Inc. is located in Charlotte, NC. We have a client who needs a Cold Fusion developer for 3 months. They have 14 active URLs and their web person has gone on maternity leave. Do you know anyone that might have an interest in a 3 month gig?
    I am a senior recruiter for Team and have been here for 7 years.
    We thought we had someone lined up from Atlanta and he accepted a position closer to his home.
    Thank you in advance for your help.

  9. I have been using Derby since it was cloudscape and in my experience Derby is fine for most small to medium sized web applications. It performs relatively well, has a small foot print, and in general is easy to work with.
    I wrote a article for IBM years ago on using Azzuri Clay Eclipse Plugin and SQLExplorer for DB development see http://www-128.ibm.com/developerworks/edu/os-dw-os-ecldbint-i.html. With Azzuri (which is free) you can reverse generate DB’s, generate a ERD, Validate your DB model, and Edit your DBS.
    See screen shots here
    Also my Eclipse has decent DB support. Better than MySQL tools thats for sure.

  10. Any one requiring a free GUI tool for Java DB that enables you to view your database schema, edit, insert and delete data, run queries, add tables, views, triggers, procedures etc, perform backups and scheduled backups please email me fwilliams@intelilink.co.uk. We had an issue of supporting one of our applications with an embedded Java DB and with no sign of any GUI tools we created our own tool that is instantiated with a Connection and away you go….

Leave a Reply