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…')
(ScreenShots)
 
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.
 +
 +
=='''ScreenShots'''==
 +
'''Database properties application'''
 +
 +
The Gnome Database properties application makes it easy to declare new data sources:
 +
[[File:gdp.png]]
 +
 +
 +
''' Widgets from the UI extension '''
 +
 +
'''Login'''
 +
 +
The login widget lets the user enter information required to open a connection defined by a data source. The following screenshot shows the Survey data source selected, and the Add button lets the user define a new data source.
 +
 +
[[File:login.png]]
 +
 +
'''DSN specification'''
 +
 +
The DSN spec. widget lets the user enter information required to create a new data source (the actual type of information depends on the DBMS which will be used). The following screenshots shows this widget for a PostgreSQL and for a TDS data source.
 +
 +
[[File:dsn_spec.png]]
 +
 +
[[File:dsn_spec2.png]]

Current revision as of 06:55, 15 March 2011