Libgda's databases adaptaters are called providers and this page attempts to give a list of the currently supported database types and the limitations.

Providers status

Database provider

Compiles?

Status

Remarks

Access (.MDB files)

Yes

Functional, read only mode

Uses the MDB Tools library to access the .MDB files, and is limited by its features

Berkeley DB

Yes

Fully functionnal

Access to the key/value Berkeley DB database

Berkeley DB SQL

Yes

Fully functionnal

Access to any Berkeley DB using the new SQL API, only in upcoming 4.2 version

MySQL

Yes

Fully functional

For version 5.0.x

Oracle

Yes

Fully functionnal

Starting with the 4.2 version

PostgreSQL

Yes

Fully functional

For versions >= 8

SQLite

Yes

Fully functional

Uses an embedded or external version if possible

SQLCipher

Yes

Fully functional

Extension to SQLite to encrypt databases, starting with the 4.2 version

JDBC

Yes

Fully functionnal

Generic wrapper of any database accessed using JDBC

Web

Yes

Fully functionnal

Generic access to databases hosted behind a web server (some PHP scripts must be installed on the web server and available connections must be configured), starting with the 4.2 version

LDAP

Yes

Fully functionnal, read only mode

Access to LDAP hierarchical databases hosted behind a web server, starting with the 4.2.8 version

Outdated Providers status

Database provider

Compiles?

Status

Remarks

Sybase

No

Outdated

Uses the Sybase API

ODBC

No

Outdated

Features limited by ODBC

Firebird

No

Outdated

IBM DB2

No

Outdated

TDS (Microsoft SQL Server and Sybase)

No

Outdated

Uses the FreeTDS library

mSQL

No

Outdated

Xbase

No

Outdated

You can help improve this table's accuracy by testing libgda with your database.

DISCLAIMER: there is no guarantee that this software functions correctly or that it will not destroy or damage your data. You are warned: Don't test on production servers.

Providers_status (last edited 2011-06-04 12:10:43 by VivienMalerba)