GNOME-DB

GNOME-DB

Repository	{{#property:P1324}}
Type	database, data abstraction layer
License	GNU Lesser General Public License
Website	www.gnome-db.org

GNOME-DB is a database application by the GNOME community. The project aims to provide a free unified data access architecture to the GNOME project for all Unix platforms. GNOME-DB is useful for any application that accesses persistent data (not only databases, but data), since it now contains a data management API.

General

The GNOME-DB project aims to provide a free unified data access architecture to the GNOME project.

GNOME-DB is useful for any application that accesses persistent data (not only databases, but data), since it now contains a pretty good data management API.

GNOME-DB's production corresponds to the Libgda library which is mainly a database and data abstraction layer, and includes a GTK+ based UI extension, and some graphical tools:

• Libgda depends on the GLib (and integrates with it), and LibXML.
• Libgda's UI extension depends on GTK+
• Libgda's graphical tools depend on GTK+ and optionally GooCanvas and GraphViz

Features

Libgda is a (relatively small) database access library:

• it is a wrapper like ODBC but with more features to access several database engines
• features a meta data extractor (to know all about database objects in a common way)
• comes with an SQL console application (like mysql, psql or sqlite3 consoles)
• relies on GLib, coded in C, its API is easy to use
• at the moment supports SQLite (and SQLCipher), MySQL, PostgreSQL, MSAccess, Berkeley Db (and is SQL extension), Oracle and JDBC (allows access to any database through a JDBC driver), work is in progress for other database types (such as Firebird). There is also a special feature which allows one to connect to a database hidden behing a web server (through specific PHP scripts)
• LGPL licensed for the libraries and GPL licensed for the tools

Libgda's graphical tools

Libgda's UI graphical tools include:

• a data sources administration tool to manage data sources and test them
• a database "browser" which allows one to explore a database's structure

and, in the future modify its contents. For more information, see the GdaBrowser's specific page.

Links

• Wiki
• Homepage