Steven Hawkins wrote:
It doesn't seem like we have yet reached a consensus, but it does
seem like:
1. people do like having a SQL oriented interactive command line tool.
2. most see the SQL functionality as separable from the admin/test.
Agreed?
I'd also like to relay a local discussion with Ramesh. His basic premise was that if
we decouple the admin/test aspects and promote an alternative command line SQL tool, then
we should just forgo offering any built-in environment for administrative scripting. In
this case the approach would be to just document which class/classes could be imported (as
shown in the previous Groovy example with the static import of AdminShell methods) into
your java scripting language of choice.
I think this falls short on "out-of-the-box" experience. I like the
idea of a Groovy-based shell for Admin and a separate utility for ad-hoc
SQL without the user being required to configure their environment. Of
course, it would be nice if we *also* provided the option to
import/extend your java scripting environment of choice.
----- Original Message -----
From: "Ramesh Reddy" <rareddy(a)redhat.com>
To: "John Doyle" <jdoyle(a)redhat.com>
Cc: "Steven Hawkins" <shawkins(a)redhat.com>, "teiid-users"
<teiid-users(a)lists.jboss.org>, "teiid-dev"
<teiid-dev(a)lists.jboss.org>, "Paul Nittel" <pnittel(a)redhat.com>
Sent: Tuesday, April 13, 2010 9:41:49 AM GMT -06:00 US/Canada Central
Subject: Re: [teiid-users] [teiid-dev] Alternative scripting envrionment for AdminShell
On Tue, 2010-04-13 at 09:27 -0400, John Doyle wrote:
> You nailed my concern Steve. I've never actually used AdminShell for
> admin tasks, I use it like
> SQL*PLUS. I think there are probably more reasons to separate these
> concerns than to combine them. I haven't looked at either of the two
> tools you linked to, but if we can validate that one of them works
> well enough then I think that should be sufficient for a query tool
> for Teiid.
>
> I think the added verbosity of the groovy solution is more acceptable
> for an admin tool than for a query tool, and is worth it given the
> added capabilities that multiple connections offer.
>
Please take integration test and write using this tool, and you will see
the reasons for this added verbosity.
Ramesh..
_______________________________________________
teiid-users mailing list
teiid-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/teiid-users
--
Ken Johnson
Sr. Product Manager
JBoss Middleware Business Unit
Red Hat, Inc
978.392.3917
ken.johnson(a)redhat.com