GNOME-DB

Original author(s)	The GNOME Project
Developer(s)	various people
Stable release	5.2.3 / June 12, 2015;9 years ago
Type	database, data abstraction layer
License	GNU Lesser General Public License
Website	www.gnome-db.org

GNOME-DBis adatabaseapplication by theGNOMEcommunity. The project aims to provide a free unified data access architecture to theGNOMEproject for allUnixplatforms. GNOME-DB is useful for any application that accesses persistent data (not only databases, but data), since it contains a data managementAPI.

Features

GNOME-DB has support forGObject IntrospectionandVala.Starting with the 4.2 series, GNOME-DB corresponds to thelibgdalibrary. The libgnomedb library provides "widgets" that allow users to interact with data in databases. It uses the libgda generic databaseAPI,so it can useMySQL,Postgres,SQLite,etc.

GNU Data Access

GNU Data Access (GDA) is a set of pluginAPIs,defined as generic as possible, so that any kind of data source can be accessed through them, to provide uniform access to different kinds of data sources (databases, information servers, mail spools, etc.). Similar toOpen Database Connectivity(ODBC) orJava Database Connectivity(JDBC), GNU Data Access is a wrapper but with more features to access several database engines. GNU Data Access has been developed as a complete architecture that provides everything required to access data sources.

Libgda is mainly a database and a data abstraction layer. It is alibrarythat implements the interfaces defined by the GDA architecture, for both the client and the server parts. It additionally provides a bunch of tools to help with the development and the management of data sources via the GDA APIs. Libgda was part of theGNOME-DBproject but has been separated from it to allow non-GNOME applications to be developed based on it.

The libgda library is released under the terms of theGNU Lesser General Public License(LGPL), which allows for commercial applications to be developed based on libgda. Its command-line and UI tools are under theGNU General Public License(GPL).

Libgda is a (relatively small) database access library:

features a metadata extractor (to know all about database objects in a common way)
comes with anSQLconsole application (like mysql, psql or sqlite3 consoles)
Libgda is coded inC,depends onGLib(and integrates with it), andLibXML2.
Libgda's UI extension depends onGTK+
Libgda's graphical tools depend on GTK+ and optionallyGooCanvas^[1]andGraphViz