db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Apache Derby Management Tool
Date Tue, 12 Aug 2008 13:32:14 GMT
Hi Øyvind and Håvard,

Welcome to derby-dev! What you have built sounds very exciting and 
useful. We are definitely in the business of building JMX support for 
tools like yours and we can certainly use your help. We get a lot of 
requests for GUI admin tools and it would be great to be able to point 
those people at your project. I suspect that some of those people would 
even be willing to study your code and help you extend it. I could see a 
community forming around your contribution.

Derby may be the wrong place for your tool itself, however. I don't want 
to discourage you but it seems to me that the Derby charter pointedly 
excludes "Database GUI tooling": 
http://db.apache.org/derby/derby_charter.html#Database+Technology I hope 
that someone will correct me here if I am mis-interpreting that part of 
our charter. I don't know why the charter excludes GUI tools. I suppose 
the community could consider changing that clause.

Another approach might be for you to incubate your code as a separate 
Apache DB subproject. Let me know if that's an appealing option. If it 
is, I can start a conversation about this on the incubator mailing list.

Another option would be to open-source this code outside Apache but keep 
us informed so that we can point people at your project. Once your code 
develops a community, it will be more attractive to Apache.

Does anyone else have ideas about how we can help Øyvind and Håvard 
develop what sounds like a very useful tool?


Øyvind Jensen wrote:
> Introduction
> We're two graduates from South Trøndelag University College (Høgskolen I
> Sør-Trøndelag, HiST) in Norway. We've developed an administration tool for
> Apache Derby as a student project and would like to open it to the
> community process and continue working on it.
> Why we choose this project
> For a number of reasons actually. All of the database management systems
> (DBMS) out there has some sort of utility which enables you to administer
> the system. Apache Derby has no such thing, not officially that is. We see
> the demand for such a tool and we're going to try to fill that gap.
> We're setting it free both because we're big fans of free and open source
> software, and because Apache Derby is released under the Apache License we
> have adopted the same for our code.
> Finally because of the challenge. Trying to get the code accepted and to
> gain acceptance as developers from a large community is a great challenge.
> Especially when trying to make a user interface good enough and functional
> for everyone which is a challenge in itself.
> Basic functionality
> Application programming interface (API)
> -Start/Stop database (DB)
> -Change port and DB default directory
> -Run Apache Derby as network server and embedded
> -Create tables and retrieve data
> -Show server parameters and monitoring information
> -Logging (client and server)
> -Manage multiple instances of Apache Derby
> Graphical user interface (GUI)
> -Using above functionality
> -Easy access to SQL query tool (ij)
> -Tray icon (Gnome panel on *nix and task bar on Windows)
> Status
> Almost all of the functions in the API works and the GUI is coming close
> to something usable.
> Target users
> Everyone! But especially new Apache Derby users and those who tries Apache
> Derby out for the first time. To have such a tool easily available to
> users makes it less probable for them to run away when they read CLI only
> somewhere, and in the long run this may encourage more people to
> participate in the Community.
> Technologies and tools used
> -Apache Derby
> -Java Management Extension (JMX)
> -Swing
> -NetBeans IDE
> We have set forth a goal to use as little outside of the JRE as possible
> when running the tool. No need to install additional software and thus
> make it easier to get started using it. The reasoning behind using JMX is
> to ease the sharing of information between the running instance and the
> client side API. A lot in Apache Derby has been instrumented as manageable
> beans and we would like to leverage these capabilities.
> We've chosen NetBeans as our IDE because we're both familiar with it, it's
> easy to make a good looking GUI with NetBeans, and because there is a good
> amount of developers out there using it.
> Calling out to all Derby developers
> We would like to know your opinions on including a graphical management
> tool into Apache Derby. We're aware of the project details when it comes
> to GUIs, but we believe there is no better place to host the code. It will
> ease development and the tool will in turn potentially benefit the
> community.
> Our email addresses:
> Øyvind Jensen - oyvindje AT tihlde.org
> Håvard Barkhall - haavaba AT tihlde.org
> Thanks,
> -Øyvind J.

View raw message