Blog

Monthly Archives

Categories

Search

Subscribe

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

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.

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

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 herehttp://www.azzurri.jp/en/software/clay/screenshots...

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