cfsilence - Apache Derby

Aqua Data Studio 7.0 Released

Wed, 15 Oct 2008 20:32:00 -0400

I just got an email from AquaFold announcing the final release of version 7.0 of their popular Database query tool Aqua Data Studio. I've used ADS for a while on and off (thanks to a program that offers free licenses to Open Source developers) and I have to say it is a pretty good application. Here is a list of features for 7.0 - which includes full support for Apache Derby databases. Download Page

Exploring Your DB With Eclipse 101 - Part 3

Wed, 21 Nov 2007 09:47:00 -0400

I wanted to throw together a quick summary for this short series to recap. Part 1 showed you how to install the Eclipse Data Tools Platform (DTP) and set it up to explore Apache Derby Embedded databases by pointing it at the proper Derby JDBC driver. This post also showed how to create a new Derby database from DTP. Part 2 showed you how to introspect the newly created database, create a new table, run an SQL query and create a ColdFusion DSN pointing to the new db. I wanted to also point out that DTP is not limited to Apache Derby DBs. If you can get your hands on your favorite DB platforms JDBC driver you can follow the same steps in this series to point DTP at your database. I haven't fully tested this yet, but I intend to. It is very very cool to be able to do just about all of my development tasks within a single IDE. I'm loving Eclipse more every day. Hope this short series was helpful to some folks out there. Drop a line if you have any suggestions.

Exploring Your DB With Eclipse 101 - Part 2

Tue, 20 Nov 2007 08:10:00 -0400

In my last post I showed you how to download, install, configure and connect the Eclipse Data Tools Platform to an Apache Derby Embedded database. Now I'll show you how to use the tool to create a table and do some basic queries. I'll also show how to set up your ColdFusion DSN to point to this new DB. [More]

Exploring Your DB With Eclipse 101 (Including Derby DBs!)

Mon, 19 Nov 2007 08:51:00 -0400

I started looking into the Apache Derby Embedded database late last week as an alternative for future open source projects. The first major issue I had with them was the lack of a GUI tool for managing my schema. I feel pretty comfortable with SQL but I still like having a query browser/server administrator that lets me quickly edit/add tables and columns with a graphical user interface. [More]