Announcing the first public release of project GSQL version 0.2.0 GSQL is an integrated database development environment for GNOME. It is designed to support multiple database engines, so far MySQL and Oracle are supported. This release introduces:
- SQL editor
- PL /SQL editor (in triggers, functions, procedures and packages)
accessible in Oracle engine.
- tree-like database object navigation
- using standard notification service for pop up messages. E. g.
in case of inactivity user will be notified on query completion
- create and connect to a duplicate session with parameters copied
from the active session, all in one click
- configuration improved. It is now possible to tune GSQL look,
customize editor and set up the settings of DBMS engine, e.g.
set custom environment variables to access Oracle
- new plugins:
Terminal - opens a terminal session with parameters (such as login, password etc) taken from the active session
Exporter - exports query results to a CVS file. So far only fetched records could be exported
Runner - periodically executes SQL queries.
- MySQL engine:
- MySQL server version 5 and higher is required. GSQL relies on information_schema, which was introduced in version 5.0
- you can not cancel a running query as easy as in Oracle due to API limitations. You can always open a terminal session and cancel the query with “KILL QUERY”
- Oracle:
- this version was tested with Oracle version 10.1.0.2.0. Should you experience any troubles with different Oracle versions please report to GSQL authors
- it is not recommended to use oracle-xe-client from http://oss.oracle.com/debian repository, there are known issues with NLS with this client.