I talked with Andrus and Cris recently about post-1.2 building a DBEdit style capability into the Cayenne Modeler. For those unfamiliar with it, here is the link:
http://www.rubicode.com/Software/DBEdit/
(Even if you don't have OS X or WebObjects on Windows, you can still see the screen shots.)
In a nutshell, DBEdit reads an EOModel (similar to the Cayenne XML files) and then allows you to browse and query the database, even using dotted path notation, etc. It is also aware of relationships and you can follow them. You can also edit the data and insert/delete rows.
It is a great tool when doing development and production support. I think it would be far more useful as part of CM than as an Eclipse plugin. One of the benefits of CM is it is IDE agnostic (you can use Eclipse, NetBeans, Idea, etc). Also, I can give CM to a business analyst and they can at least look at the schema without firing up a complete IDE tool. If they could also browse the DB, even sweeter.
Any thoughts?
Thanks,
/dev/mrg
PS. Yes, I know this would be a pretty big project improvement effort ...
-----Original Message-----
From: Øyvind Harboe [mailto:oyvind.harbo..ylin.com]
Sent: Monday, May 29, 2006 7:51 AM
To: cayenne-de..ncubator.apache.org
Subject: Re: Cayenne Eclipse Plugin
More wishes:
- Browse database
- Execute Cayenne queries in database browser.
Can Eclipse DTP offer anything helpful?
http://www.eclipse.org/datatools/
-- Øyvind Harboe http://www.zylin.com
This archive was generated by hypermail 2.0.0 : Tue May 30 2006 - 09:13:44 EDT