Friday, March 30, 2007

What's next...

Just a few thoughts about what I intend to do next with SQLTools++:

First I need to do a bit more cleanup to the items installed by the Installer. In particular the "history" file has not been updated yet and the link to the Homepage added to the Explorer menu still points to the old homepage (the link in the application has already been updated). Just cosmetics, so when I find some time this will be updated, too.

Next I'll try to finish the 9i emulation of the 10g DBMS_XPLAN.DISPLAY_CURSOR functionality. The query to V$SQL_PLAN_STATISTICS_ALL is already done, and I'm currently working on a big anonymous PL/SQL block which is supposed to parse and format the query output similar to the DISPLAY_CURSOR function. This PL/SQL block will then be executed by SQLTools++ to get the output to display. Probably the PL/SQL block will reside in a separate text file so you will able to change and/or extend it if you are willing to.

Next thing on my list would be the interface to DBMS_METADATA. This is pretty straightforward and I hope that it won't take too much effort to get it in.

May be in parallel I'm going to revisit the "Online visual match" issue again, but that's definitely low priority, as the "Find Matching Brace" functionality works very well for me.

Ah, yes, and by the way: Now that I've released SQLTools++ to public I expect some bugs will come up which need to be fixed...

Thursday, March 29, 2007

First public release

Finally I made it... The VPS server is installed, the homepage is available here:

http://www.sqltools-plusplus.org:7676/

For quite a while I was thinking about whether I should publish this release at all. I won't have the time to provide adequate support in case someone really starts to use this version extensively. Since this is a C++/MFC application and the only one who has tested it yet is me, myself and I, there are probably a lot of bugs left to discover.

But on the other hand, may be someone will find the enhancements useful, and likes to use this version.

So I decided to publish and wait for things to come. If it starts to bother me, I can cancel my VPS on a monthly basis :-))

By the way, the VPS is hosted by Host Europe. I can really recommend their services so far, you can choose a minimum contract term of just four weeks and their support has been turned out to be for free of charge (at least basic inquiries are) and reasonably competent, even for my "lowest-end" VPS version, which costs only 10 EUR per month.