[teiid-users] [teiid-dev] Alternative scripting envrionment for AdminShell

[John Doyle]

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.

~jd  
----- "Steven Hawkins" <shawkins at redhat.com> wrote:

> As a separate tool it is focused enough to support features such as
> sql command completion and other much beyond what we can offer :) 
> 
> Integration with Groovy isn't really the right path coming from this
> direction.  You would rather see us support more functionality through
> sql, like the old admin vdb - which could be added back easily with
> the reduced admin logic and admin objects that map to xml (sqlxml). 
> We should even support in line definition of procedures, which may
> require changes in the tool to support, but would mitigate the need
> for introducing another language.
> 
> ----- Original Message -----
> From: "Ramesh Reddy" <rareddy at redhat.com>
> To: "Steven Hawkins" <shawkins at redhat.com>
> Cc: "Paul Nittel" <pnittel at redhat.com>, "teiid-users"
> <teiid-users at lists.jboss.org>, "teiid-dev"
> <teiid-dev at lists.jboss.org>
> Sent: Monday, April 12, 2010 6:31:27 PM GMT -06:00 US/Canada Central
> Subject: Re: [teiid-dev] Alternative scripting envrionment for
> AdminShell
> 
> On Mon, 2010-04-12 at 17:22 -0400, Steven Hawkins wrote:
> > Even with those limitations I understand that it does serve as a
> > reasonable approximation to something like SQL*Plus.  I question
> > whether we need to support specialized tooling for this purpose
> (over
> > just using what's available in Groovy).  We could just as well
> promote
> > the use of http://sourceforge.net/projects/sqlshell/ or the older
> > http://henplus.sourceforge.net/.
> 
> As separate tool it seems verbose and fragmented offering. If we can
> integrate these tools into groovy or add missing features  as pulgins
> into these tools seems like the right path. The both tools above have
> their own shell environments, integrating with them or into groovy,
> both
> may be challenging. 
> 
> Henplus, seems to have extensive features, and seems to have the
> simultaneous name based connections, so it definitely gets my vote if
> we
> decide go this route.
> 
> Ramesh..
> 
> _______________________________________________
> teiid-users mailing list
> teiid-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/teiid-users