[Ijsql-devel] Re: Tasks and the like

[<ww...@ts...>]

Quoting Peter Kasson <pk...@ho...>:
> When you say "switchable", what does that infer ?

It means that you can have connections open to multiple
databases, and can switch between them; in a console,
for example, I might be connected to an Oracle db, then
hit a hotkey combination to get a new connection and
connect to my Sybase db; once they're both open, I can
switch back and forth between them.

> I was thinking of the x-db query in more depth and
> need to peruse the JDBC 2.0 specs.  I am
> hoping it supports such a beast, else, it may be a bit
of a conundrum.

Could we implement it manually, also, by defining a
cross-db join syntax, then preprocessing the query?  The
preprocessor would have to be able to determine how to
retrieve the info from each database, then merge the
results ... yes, a bit of a beast, perhaps.  Fun,
though!   ;-)

> Certainly, the data extraction and transformation is
what I'm interested in 
> possibly more than x-db.  I have done this in things
like SQL-Server DTS
> and manually, but am envisioning a GUI like DTS which
would allow for this to
> happen -- it has real awesome possibilities.

Sounds like a great area for you to be working on  
;-)   and I agree that it would be awsome.

> I did build the [Swing gui] app ok and run it - but
haven't donated a lot of time to
> it.  Were you looking to leverage this front end?  If
so, it needs a bit of
> clean up and polishing (and as I say, if one suggests
something, they 
> should be willing to do it) so I could take that on if
no one else wants to.

I would like to leverage the front end; yes, it needs
clean up (Stefan was a bit sheepish about donating the
code, since he knew it needed the cleanup, too   ;-)

You're welcome to work on it, but it sounds like you're
more interested in the DTS-like functionality;  let's
see if someone else who just LOVES Swing work wants to
help ... If noone on the project currently wants to do
it, I'll place another job add specifically for Swing
GUI help.

>Part of this front-end would encapsulate
> the "console" mode if desired - but using a "GUI"
console.  This would give
> the console more functionality and you could switch
between GUI and
> console. Have you seen Oracle 8i's "SQL-Plus"
worksheet? Kind of like that.

I have seen it, but I also want to keep a pure
character-based console view available, like SQL*Plus. 
That way, there's a nice, advanced cross-db query tool
available to me to open in an Emacs shell when I'm doing
development, or for when I'm working outside of
X-Windows.  The pure gui/gui console version you
describe would be great!  and I hope we get that, but I
do want to keep the text-mode console as well.  This
should be very easy, once we do the MVC.

> Definitely.  I don't want to get into a religious
debate when we suggest
> certain standards or coding conventions.  Javadoc is a
must and it would be
> nice if at the class level, have an example of usage.

Right.  I don't want religious wars, but would like some
standards so that the code has some consistency.  I have
a few ideas I'll post separately a bit later, then we
can hash things out and agree on some standards.

> This is all good.  Tell you what, I will do a couple
of high-level docs and
> email them to you and Jukka and let's discuss.  Sooner
we get consensus, we
> can get cooking !

Great! Thanks once again for all the ideas and input!

Regards,
Bill Graham



=========================================
This mail sent through Sinclair's WebMail
      http://mail.sinclair.net