GSQL's mission is to supply database developers with an universal tool platform tailored against market leading DBMS by providing:
* native DBMS access (not via ODBC layer)
* databased objects organised into a tree
* intuitive and easy database objects handling
* syntax highlighting
* query plan builder
* query constructor
* query result export (in XML, CSV, HTML)
* debugger (depending on RDBMS)
* query planner control (depending on RDBMS)
* database administration functions
* database system monitoring
* GNOME integration (via gconf and gnome-keyring)
* plugin: data migration wizard for various RDBMS
Architecturely GSQL is designed so that the database interfaces are arranged into modules linked to the platform by engine API. It allows to implement new engines independently. GSQL provides developers with a rich API. To extend the functions of GSQL engines, we suggest loadable plugins API.
One of the main ideas is tight integration with the Desktop Environment (GNOME).
Product's homepage
Here are some key features of "GSQL":
Oracle features:
· navigation tree
· SQL editor
· create/edit/drop tables
· create/edit/drop triggers
· create/edit/drop procedures
· create/edit/drop functions
· create/edit/drop packages
· DBMS output support
MySQL features:
· navigation tree
· SQL editor
· create/edit/drop tables
Requirements:
· gtk+
· GtkSourceView
· libnotify
What's New in This Release: [ read full changelog ]
· PostgreSQL support (experimental)
· Plugin Tunnel (libssh 0.4.* is required)
Bugs fixed:
· Fix some typos and GUI stuff (#25 and #29)
· Fix oracle crashed on deleting variables (#23)
· Added port number to MySQL and PGSQL login dialog (#21)
· Fix mysql crashed with invalid query (#30)