Colin,
As you have suggested I will wait for your changes to appear in CVS. I would
like for the sql worksheet to be in their own frame rather than on the tab
with the object view, is that what you have in mind?
What I was able to do so far is to create SessionListener plus associated
classes that can be added to the SessionManager class, and created a
combobox that listens for the "active" session plus session creations and
removals. Are you interested in a patch containing these (fairly trivial)
changes.
Jason
-----Original Message-----
From: Colin Bell [mailto:Colin.Bell@...]
Sent: Monday, 20 October 2003 9:20 AM
To: squirrel-sql-develop@...
Subject: RE: [Squirrel-sql-develop] My suggested changes
Hi Jason,
> I use Oracle databases at work. I have had difficulty in the past with
squirrel
> because it doesnt allow me to have multiple SQL worksheets without
creating new
> connections. I find the interface cumbersome that i need to re-login just
to
> have another sql worksheet.
In 1.2 I'm going to be adding the ability to be able to open multiple
worksheets for a connection as well as allowing the choice of a SDI type UI
as well as the existing MDI one. Some of the base infrastructure for this
has already been done although there is a lot more to do. Take a look at
net.sourceforge.squirrel_sql.client.session.SessionWindowManager and
net.sourceforge.squirrel_sql.client.session.SessionManager.
> Dont take this the wrong way, but am i wasting my time by trying to do
this? It
> seems that i am doing things against the current concepts in squirrel so
if i
> supply a patch will it get applied? Is anyone else interested in this kind
of
> ideas? (this is pretty how TOra or Toad do things)
Probably, but only because its already being done. What I'd suggest is to
wait and see how my implementation turns out and you may then want to fine
tune what I've done.
> I haven't got this far but I plan to add additional functionality to the
SQL
> worksheet so that when the Oracle plug-in is used "Explain Plans" (instead
of
> results) can be generated. I don't know if this has already been done.
Different
> database plugins could add their own performance information.
You may not need to change the worksheet to do this. If you can generate the
explain plan via SQL and display it via a result set then you should be able
to modify the Oracle plugin to add an "Explain Plan" item to the session
menu. This menu item could retrieve the currently selected SQL via
ISQLPanelAPI.getSQLScriptToBeExecuted(), wrap the explain plan SQL around it
and then execute it via ISQLPanelAPI.executeSQL(sqlToBeExecuted). If the
explain plan SQL returns its results in a result set then it will be
displayed in a tab just like any other SQL execution.
If you're interested in working on SQSC and you have Oracle skills, the
Oracle plugin would be an obvious place to look. It only has very basic
functionality. Theres a lot of functionality in Oracle that it doesn't
address (such as showing explain plans, showing source for stored procs that
are within packages, editing, executing and debugging stored procs etc.).
Oracle seems to be the most commonly used DBMS with SQSC (or maybe I just
get more feedback from Oracle people) so adding functionality to the Oracle
plugin is high on my list of priorities but I don't have either the Oracle
skills or the time to do so. If you'd be interested in working on this you'd
be doing me a very large favour. Let me know if you're interested.
Col
-----Original Message-----
From: Jason Height [mailto:jheight@...]
Sent: Friday, 17 October 2003 19:32
To: squirrel-sql-develop@...
Subject: [Squirrel-sql-develop] My suggested changes
Hi All (esp Colin),
I use Oracle databases at work. I have had difficulty in the past with
squirrel because it doesnt allow me to have multiple SQL worksheets without
creating new connections. I find the interface cumbersome that i need to
re-login just to have another sql worksheet.
In the true spirit of open source i have started to modifying the squirrel
source code so that i can have SQL Worksheets that are independant of the
session. So far i have created a SessionManager class (and more!) that will
be able to track sessions being added, removed etc. I have a combo box on
the toolbar that tracks the current sessions as well as the current "active"
session.
I am almost at the stage where i have created a Action that can create
multiple SQL worksheets (detached from the Object tree) against the current
"active" session.
My plans are to completely seperate the "object" view from the sql
worksheets. Unfortunately without realizing i have been making my changes
against the squirrel 1.1 source ;-( (so my patch wil be delayed).
Dont take this the wrong way, but am i wasting my time by trying to do this?
It seems that i am doing things against the current concepts in squirrel so
if i supply a patch will it get applied? Is anyone else interested in this
kind of ideas? (this is pretty how TOra or Toad do things)
I haven't got this far but I plan to add additional functionality to the SQL
worksheet so that when the Oracle plug-in is used "Explain Plans" (instead
of results) can be generated. I don't know if this has already been done.
Different database plugins could add their own performance information.
Anyhow just let me know if I am heading down the right track.
Jason
-------------------------------------------------------
This SF.net email sponsored by: Enterprise Linux Forum Conference & Expo
The Event For Linux Datacenter Solutions & Strategies in The Enterprise
Linux in the Boardroom; in the Front Office; & in the Server Room
http://www.enterpriselinuxforum.com
_______________________________________________
Squirrel-sql-develop mailing list
Squirrel-sql-develop@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
--------------------------------------------------------------------------------------------------------------------
This e-mail (including attachments) is confidential information of Australian Submarine Corporation Pty Limited (ASC). It may also be legally privileged. Unauthorised use and disclosure is prohibited. ASC is not taken to have waived confidentiality or privilege if this e-mail was sent to you in error. If you have received it in error, please notify the sender promptly. While ASC takes steps to identify and eliminate viruses, it cannot confirm that this e-mail is free from them. You should scan this e-mail for viruses before it is used. The statements in this e-mail are those of the sender only, unless specifically stated to be those of ASC by someone with authority to do so.
|