rilpoint_mw113

Gnome-db

(Created page with '=='''Overview'''== GNOME-DB is the database application of GNOME Office, the office suite of the GNOME desktop. The project aims to provide a free unified data access architectur…')
(Overview)
Line 1: Line 1:
=='''Overview'''==
=='''Overview'''==
GNOME-DB is the database application of GNOME Office, the office suite of the GNOME desktop. 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.
GNOME-DB is the database application of GNOME Office, the office suite of the GNOME desktop. 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.
 +
 +
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:
 +
 +
    a) it is a wrapper like ODBC but with more features to access several atabase engines
 +
    b) features a meta data extractor (to know all about database objects in a common way)
 +
    c) comes with an SQL console application (like mysql, psql or sqlite3 consoles)
 +
    d) relies on GLib, coded in C, its API is easy to use
 +
    e) 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)
 +
 +
    f) LGPL licensed for the libraries and GPL licensed for the tools
 +
 +
 +
'''Libgda's UI Extension'''
 +
 +
 +
Libgda's UI Extension features:
 +
 +
 +
    a) a set of data bound widgets to show and edit data directly in the
 +
database,
 +
    b) 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) a data sources administration tool to manage data sources and test them
 +
 +
    b) 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.

Revision as of 06:30, 15 March 2011