News and announcements

Version 0.2.1 released

Written for gsql by Taras Halturin on 2008-12-28

In this release we fixed some bugs:

    * Issue 7 (oracle-engine: SIGSEGV with TIMESTAMP data type)
    * Issue 10 (restoring the window state after restart is fixed now)
    * Issue 6 (mysql-engine: case sensitive on the database object names)
    * Issue 17 (fix FreeBSD build)

Buildsystem was cleaned up (Now the files are installed according to standards).

Debian build routines rewritten from scratch. Fixes for RPM building.

There are also several improvements:

    * oracle-engine: scanning of tnsnames.ora - you can select alias name from the drop-down list, or simply start typing the name of an alias and get suggested autocompletion.
    * option to switch window to fullscreen mode
    * the logon window now includes action by default. you do not have to aim to click "OK", just press Enter.

First, I would like to thank the developers Dmitry Oboukhov (Debian) and Pavel Shevchuk (Fedora) for a great help in adapting build on these distributions. I hope to see this project in official repositories of these distributions in near future.

Also thanks to all who wrote bug reports! Thank you all! I'm looking forwards to see more bugreports ;-)

Happy New Year everyone! Merry Christmas!

See you next year!

PS: Uninstall all previous ubuntu packages prior to installing new version.

Read more

GSQL 0.2.0 released!

Written for gsql by Taras Halturin on 2008-11-29

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.

Release remarks:

     * 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 GSLQ 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.

GSQL API is now stable enough, and you are highly encouraged to
contribute your own plugins or support additional database engines.

We wish GSQL could become the main database development tool in GNOME
one day.

Read more