Looking for a few good database users

[David Van Couvering <da...@vancouvering.com>]

Hi, all.  As Sun's database architect for NetBeans, part of my role is
to understand what database tooling features we should add to NetBeans
to help make it a rad, awesome tool for developers using databases.

Rather than try and guess or assume that I have any real knowledge
about this, I want to talk to folks who have spent lots of time
buliding database apps and using database tools.

So, I'm conducting a series of interviews.  If you're interested and
would like to help out, please contact me off-list and I can give you
more details.

Thanks,

David

Re: Looking for a few good database users

[Craig L Russell <Cr...@Sun.COM>]

Hi Robert,

On Jun 3, 2007, at 12:18 AM, robert burrell donkin wrote:

> On 6/1/07, David Van Couvering <da...@vancouvering.com> wrote:
>> Hi, all.  As Sun's database architect for NetBeans, part of my  
>> role is
>> to understand what database tooling features we should add to  
>> NetBeans
>> to help make it a rad, awesome tool for developers using databases.
>
> one general observation i have on this is that very tight tooling
> integration between IDEs and data-access is a missing bit of the
> jigsaw ATM. when i see developers grappling with data access issues,
> they have to cut bits of SQL from logs and then paste into an IDE.

I totally agree. It's far too hard to figure out what your ORM is  
doing for you.
>
> perhaps it might be possible to develop a monitor logging API which
> would allow interested tools to observe the SQL as it is being
> executed.

That's one of the things that's missing for sure. The other is  
performance metrics and helpful hints like "turn on connection  
pooling" if it's not already on.
>
> this would be an ideal complement to being able to jump from a data
> access object to the mapped database tables etc within a debugger etc.

And a tool bench to execute the JPAQL just like you would execute the  
SQL with a live connection.

Craig
>
> - robert

Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!

Re: Looking for a few good database users

[robert burrell donkin <ro...@gmail.com>]

On 6/1/07, David Van Couvering <da...@vancouvering.com> wrote:
> Hi, all.  As Sun's database architect for NetBeans, part of my role is
> to understand what database tooling features we should add to NetBeans
> to help make it a rad, awesome tool for developers using databases.

one general observation i have on this is that very tight tooling
integration between IDEs and data-access is a missing bit of the
jigsaw ATM. when i see developers grappling with data access issues,
they have to cut bits of SQL from logs and then paste into an IDE.

perhaps it might be possible to develop a monitor logging API which
would allow interested tools to observe the SQL as it is being
executed.

this would be an ideal complement to being able to jump from a data
access object to the mapped database tables etc within a debugger etc.

- robert