Difference between revisions of "OpenDBX/Support"

From Linuxnetworks
Jump to: navigation, search
(removed backlink)
(Supported databases)
Line 3: Line 3:
 
Backends of officially supported database management systems (DBMS) are included in the source distribution and consist of modules for
 
Backends of officially supported database management systems (DBMS) are included in the source distribution and consist of modules for
  
* Firebird
+
{| class="wikitable" style="text-align:center; width:100%"
* Interbase
+
! Database !! Backend name !! Links
* MS SQL Server
+
|-
* MySQL
+
! Firebird
* Oracle
+
| firebird
* PostgreSQL
+
| [http://www.firebirdsql.org/ http://www.firebirdsql.org/]
* SQLite
+
|-
* SQLite3
+
! Interbase
* Sybase
+
| firebird
 +
| [http://www.codegear.com/products/interbase http://www.codegear.com/]
 +
|-
 +
! MS SQL Server
 +
| mssql
 +
| [http://www.microsoft.com/sql/default.mspx http://www.microsoft.com/]
 +
|-
 +
! MySQL
 +
| mysql
 +
| [http://www.mysql.com/ http://www.mysql.com/]
 +
|-
 +
! Oracle
 +
| oracle
 +
| [http://www.oracle.com/database/index.html http://www.oracle.com/]
 +
|-
 +
! PostgreSQL
 +
| pgsql
 +
| [http://www.postgresql.org/ http://www.postgresql.org/]
 +
|-
 +
! SQLite
 +
| sqlite
 +
| [http://www.sqlite.org/ http://www.sqlite.org/]
 +
|-
 +
! SQLite
 +
| sqlite3
 +
| [http://www.sqlite.org/ http://www.sqlite.org/]
 +
|-
 +
! Sybase ASE
 +
| sybase
 +
| [http://www.sybase.com/products/databasemanagement/adaptiveserverenterprise http://www.sybase.com/]
 +
|}
  
 
Backends for more native database APIs can be written easily. The [[OpenDBX/API|OpenDBX API Reference]] should provide all information to implement a new backend.
 
Backends for more native database APIs can be written easily. The [[OpenDBX/API|OpenDBX API Reference]] should provide all information to implement a new backend.

Revision as of 19:26, 30 November 2008

Supported databases

Backends of officially supported database management systems (DBMS) are included in the source distribution and consist of modules for

Database Backend name Links
Firebird firebird http://www.firebirdsql.org/
Interbase firebird http://www.codegear.com/
MS SQL Server mssql http://www.microsoft.com/
MySQL mysql http://www.mysql.com/
Oracle oracle http://www.oracle.com/
PostgreSQL pgsql http://www.postgresql.org/
SQLite sqlite http://www.sqlite.org/
SQLite sqlite3 http://www.sqlite.org/
Sybase ASE sybase http://www.sybase.com/

Backends for more native database APIs can be written easily. The OpenDBX API Reference should provide all information to implement a new backend.

Tested platforms

  • FreeBSD
  • Linux
    • Debian
    • Gentoo
    • Fedora
    • RHEL
    • OpenSuSE
  • Mac OS X
  • OpenPKG
  • Solaris
  • Windows (Cygwin and MinGW)

OpenDBX should compile on all Unix based platforms if a C compiler supporting the ISO C99 standard. Furthermore, building a shared library for each backend requires the dlopen() function. Alternatively, all backends can be linked with the core module to a single library. Some backends may only be supported on certain platforms depending on the availability of their used native database client library or of replacements thereof.

Native support for the Windows platform is still missing and we would appreciate any help to make OpenDBX available on Windows NT based systems without the need of Cygwin. When using Microsofts "Services for Unix" the only TODOs should be to create a Makefile and maybe a MSVC project file.