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. For information, the http://live.gnome.org/ChooseLibgdaSQLite page lists key points regarding the usage of the Libgda library compared to SQLite, most of the argumentation being relevant for other databases as well.
Starting with the 4.2 serie, 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 (much of what the Libgnomedb was), and some graphical tools (making Mergeant irrelevant):
Libgda depends on the GLib (and integrates with it), and LibXML.
Libgda's UI extension depends on GTK+
This site now refers to features which are available in the current version 4.2 and 5.0 series starting with Libgda 4.2.0, except when specifically mentionning versions.
The current stable version of Libgda is now 5.0.3, released on the 2012-01-24.
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 behind a web server (through specific PHP scripts)
- LGPL licensed for the libraries and GPL licensed for the tools
Libgda's UI Extension
Here is a brief summary of Libgda's UI Extension features:
- a set of data bound widgets to show and edit data directly in the database,
- some 'administrative' widgets for example to enter the connection parameters to open a connection.
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.
This wiki is powered by MoinMoin.