Blog

28May
2007
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).

Related Blog Entries

Comments (16)



  • barry.b

    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?

    #1Posted by barry.b | May 28, 2007, 09:47 AM
  • 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.

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

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

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

  • Mike Kelp

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

    #6Posted by Mike Kelp | May 28, 2007, 11:18 AM
  • 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

    #7Posted by Ben Forta | May 28, 2007, 11:41 AM
  • 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!

  • Peter Tilbrook

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

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

    #10Posted by Lola LB | May 28, 2007, 09:01 PM
  • Aaron Neff

    Yes, this is a great idea. Thank you!

    Derby links pertaining to sizes:
    http://db.apache.org/derby/docs/dev/devguide/devgu...
    http://db.apache.org/derby/docs/dev/ref/ref-single...

    Will SQuirreL be the recommended GUI?
    http://db.apache.org/derby/integrate/SQuirreL_Derb...

  • 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

    #12Posted by Ben Forta | May 29, 2007, 07:21 AM
  • Claudia Toner

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

  • Claudia Toner

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

    Thanks again, Ben.

    Claudia

  • 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 http://www-128.ibm.com/developerworks/edu/os-dw-os.... 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
    http://www.azzurri.jp/en/software/clay/screenshots...

    Also my Eclipse has decent DB support. Better than MySQL tools thats for sure.

    #15Posted by Robi Sen | Jul 1, 2007, 05:27 AM
  • Fraser

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

    #16Posted by Fraser | Apr 16, 2009, 01:59 PM