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.