Forta.com - Blog

Comments

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?

# Posted By barry.b | 5/28/07 9:47 AM

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.

# Posted By Adam Fortuna | 5/28/07 10:03 AM

This is great news.

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

# Posted By Sam Farmer | 5/28/07 10:06 AM

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

# Posted By Sammy Larbi | 5/28/07 10:25 AM

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.

# Posted By Mike Baker | 5/28/07 11:11 AM

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

# Posted By Mike Kelp | 5/28/07 11:18 AM

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

# Posted By Ben Forta | 5/28/07 11:41 AM

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!

# Posted By John Farrar | 5/28/07 2:41 PM

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

# Posted By Peter Tilbrook | 5/28/07 8:58 PM

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

# Posted By Lola LB | 5/28/07 9:01 PM

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

# Posted By Aaron Neff | 5/29/07 3:40 AM

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

# Posted By Ben Forta | 5/29/07 7:21 AM

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

# Posted By Claudia Toner | 5/29/07 2:19 PM

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

# Posted By Claudia Toner | 5/29/07 2:23 PM

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.

# Posted By Robi Sen | 7/1/07 5:27 AM

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

# Posted By Fraser | 4/16/09 1:59 PM

[Add Comment]

Scorpio And Apache Derby