Mar 25, 2010 Version 0.2.2 released

The « laty » release.

This release comes with an initial version of PostgreSQL engine and this is a significant step forward in the development of the project.

Whats new:

• 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)

Latest versions are available at:

• Source code: http://code.google.com/p/gsql/downloads/list Ubuntu's binary: able to download after Ubuntu 10.04 release

  • https://launchpad.net/~halturin/+archive/gsql or use '$ sudo add-apt-repository ppa:halturin/gsql'

Multiple engines and plugins helps defining a better API for GSQL, so contributions are welcome! If you want to contribute you can ask for information and report bugs at:

• #gsql on freenode

• GSQL's mailing list: http://groups.google.com/group/gsql-dev

• Bug report: http://code.google.com/p/gsql/issues/list

What's next?

Please, follow to http://halturin.blogspot.com/2010/03/gsql-022.html for more details.

Dec 23, 2008 Version 0.2.1 released

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.

Nov 29, 2008 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 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.

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.