GSQL Project: Integrated database development tool for GNOME

dec 14, 2010
Short news

• GSQL has been included to the Debian Unstable. It also means that the project should be included to the next Ubuntu's release 11.04
• Added the Firebird engine in trunk (screenshot)

---

mar 25, 2010
Release 0.2.2

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)

What's next? folow to my blog...

---

Jul 19, 2009
Why I'm not using libgda/ODBC/and.so.on

I was constantly asked about not using ODBC. If my project is point at GNOME desktop integration, I'll not use the exist library (libgda) to the database accesss (libgda is the part of the GNOME­DB project). To answer this questions please read this wiki page

---

Jun 14, 2009
New logo!

A few days ago i asked my friends (http://linuxgraphics.ru) for drawing a new logo. So... Konstantin Rotkevich has done it. How do you find it? I think it is perfect!

---

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.