libgda

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, 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 This site now refers to features which are available in the current version 5.2.x, except when specifically mentionning versions. The current stable version of Libgda is now 5.2.3, released on the 2015-06-12. Work is currently done on the next version, see the Roadmap. Features Libgda Here is a brief summary of Libgda's features, see also the detailed list of Libgda's features, or the Roadmap for the future versions. 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.