Sunday, October 28, 2007

SQL*Plus alternatives (at InOUG)

I spoke last Thursday at the Indiana Oracle Users Group on "The Command Line Lives: SQL*Plus and Alternatives".

I still need to get the full, S5 format presentation posted somewhere; for now, you can see the raw text of the presentation here.

It's an interesting topic, and one I'd like to get drawn more deeply into. Some nice things have been done in producing open-source command-line alternatives to SQL*Plus, includingUnfortunately, the only one whose development currently seems to be active is sqlpython, and there's just me and Luca Canali working on that. I've just added functionality to sqlpython to let it fail over to sessions of the other tools (when "set failover true" is issued; doesn't work on Windows). That way, the exciting features of Senora and YASQL can be used from within sqlpython, instead of trying to remember which tool has which feature. It's quirky, though, since a full-fledged independent session of each tool is actually maintained "under the covers".

I'm dreaming of expanding sqlpython to the point where it incorporates all Senora and YASQL's features natively. Tragically, my dreams cannot yet be downloaded from the Cheese Shop.

3 comments:

Bernd Kriszio said...

I' surprised that are no comments yet. SQL*Plus just cries for alternatives. It would be nice to have a small comparison of the different tools regarding the main imperfection of sql plus:
* Linelength restrictions
* need of ref cursors
* conditional indluding of scripts
* finally the supported platforms.
At first glance sqlpython seems to be the most interesting when your platform is Windows. Does it run with pathon 2.4?

Martin said...

Hi Catherine, I just found your review of Senora. Since I am the author, I am quite pleased with your judgement. I really should publish the latest version soon. And yes, python is way cool.

Martin said...

Hi Catherine, I just found your review of Senora. Since I am the author, I am quite pleased with your judgement. I really should publish the latest version soon. And yes, python is way cool.