Skip navigation.
home | news feeds | archives | search | forums | submit news
Home

Announcing the first public release of project GSQL version 0.2.0

Submitted by halturin on Sat, 2008-11-29 15:25. Gnome DB
Gnome DB

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.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Link Error

Submitted by esodan on Sun, 2008-12-14 19:14.

The correct link for gnomedb is:

www.gnome-db.org

GDA and GnomeDB

Submitted by esodan on Sun, 2008-12-14 18:44.

GDA and GnomeDB is a GLIB/GTK/GNOME based library that allows you to use much more different DB engines, PostgreSQL, SQLite, JDBC ones, Oracle and others, may you can consider to port your effort to this library and help to get the up comming 4.0 release be the best ever (event to avoid duplicated efforts - Mergeant is based in both library)

See at www.gnomedb.org

apt-get install?

Submitted by Anonymous George (not verified) on Tue, 2008-12-09 16:22.

When will this be available in the Ubuntu repositories to "apt-get install gsql"?

I do not know but...

Submitted by halturin on Fri, 2008-12-12 00:39.

I do not know but i believe... coming soon :)

smarten up

Submitted by Anonymous George (not verified) on Sat, 2008-12-06 13:10.

and atleast post the site url or something http://gsql.org/news/

Thanx!

Submitted by halturin on Tue, 2008-12-09 13:33.

Thanx!

Mergeant provides the

Submitted by Anonymous George (not verified) on Fri, 2008-12-05 17:54.

Mergeant provides the standard gnome database tool/api, afaik. Unless that project has been abandoned by GNOME, I'd suggest contributing to it instead of fragmenting effort.

Re: Mergeant

Submitted by rutulian on Mon, 2008-12-22 12:49.

I don't know. I've used Mergeant...it's ok. This app seems to serve a different purpose because it is very developer oriented. You have ready access to stored procedures, triggers, privileges, etc. Mergeant is more of a Microsoft Access clone.

Gnome-db is also very annoying to use because they decided to copy this crappy DSN system from Microsoft. Nothing is more confusing than trying to figure out the obscure terminology of data sources and database drivers (which has very poor documentation, btw), and then trying to get your ODBC-enabled application to use that data source properly, and then finding it doesn't actually support the feature you set it up for in the first place. ODBC is a nice idea in theory, but I've never been able to make it work well on any platform I've tried it on.

Mergeant?

Submitted by Anonymous George (not verified) on Fri, 2008-12-05 17:52.

Mergeant?

Mergeant

Submitted by halturin on Tue, 2008-12-09 13:44.

Did you use it? It can not be named IDE for me (it is only my opinion).

I have another point of view should look DB IDE.