Scorpio And Apache Derby

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 responses to “Scorpio And Apache Derby”

  1. barry.b Avatar

    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. Adam Fortuna Avatar
    Adam Fortuna

    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. Sam Farmer Avatar
    Sam Farmer

    This is great news.
    How big a database can Derby support? In short is this a comparable option for Access, MySQL/SQLServer or Oracle?

  4. Sammy Larbi Avatar
    Sammy Larbi

    That’s sweet. I was thinking it might be fun to try and implement a tinyDB, but Adobe’s done it for me – awesome.

  5. Mike Baker Avatar
    Mike Baker

    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.

  6. Mike Kelp Avatar
    Mike Kelp

    That is great news indeed.
    Thanks for mentioning this one again as I had definitely not heard it.

  7. Ben Forta Avatar
    Ben Forta

    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

  8. John Farrar Avatar
    John Farrar

    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!

  9. Peter Tilbrook Avatar
    Peter Tilbrook

    That is a great idea! I know ColdFusion contains all sorts of technologies (like Verity) but this would be an excellent addition.

  10. Lola LB Avatar
    Lola LB

    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 . . .

  11. Ben Forta Avatar
    Ben Forta

    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

  12. Claudia Toner Avatar
    Claudia Toner

    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.

  13. Claudia Toner Avatar
    Claudia Toner

    Guess I should include my contact information. if anyone would like to submit a resume and your all inclusive hourly rate for 3 months in Charlotte, NC.
    Thanks again, Ben.

  14. Robi Sen Avatar
    Robi Sen

    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 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.

  15. Fraser Avatar

    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 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