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. |