OpenDBX
Encyclopedia
The OpenDBX library provides a unified and consistent API
for software developers to different database management systems
. The function library
is written in the C programming language and aims at implementing access to the native database interfaces efficiently via a thin abstraction layer. It consists of a basic set of functions which are part of all vendor database libraries and can be extended by additional function blocks.
Contrary to interfaces like ODBC, the OpenDBX library favors speed and flexibility and therefore doesn't try to unify the SQL query language
. It enables the application developer either to use only standardized SQL elements or to utilize more efficient database specific language elements as well. Furthermore, this approach allows adding support for databases which do not implement SQL as query language.
Application programming interface
An application programming interface is a source code based specification intended to be used as an interface by software components to communicate with each other...
for software developers to different database management systems
Database management system
A database management system is a software package with computer programs that control the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications by database administrators and other specialists. A database is an integrated...
. The function library
Library (computer science)
In computer science, a library is a collection of resources used to develop software. These may include pre-written code and subroutines, classes, values or type specifications....
is written in the C programming language and aims at implementing access to the native database interfaces efficiently via a thin abstraction layer. It consists of a basic set of functions which are part of all vendor database libraries and can be extended by additional function blocks.
Contrary to interfaces like ODBC, the OpenDBX library favors speed and flexibility and therefore doesn't try to unify the SQL query language
SQL
SQL is a programming language designed for managing data in relational database management systems ....
. It enables the application developer either to use only standardized SQL elements or to utilize more efficient database specific language elements as well. Furthermore, this approach allows adding support for databases which do not implement SQL as query language.
Supported databases
- FirebirdFirebird (database server)Firebird is an open source SQL relational database management system that runs on Linux, Windows, and a variety of Unix. The database forked from Borland's open source edition of InterBase in 2000, but since Firebird 1.5 the code has been largely rewritten ....
- InterbaseInterBaseInterBase is a relational database management system currently developed and marketed by Embarcadero Technologies. InterBase is distinguished from other DBMSs by its small footprint, close to zero administration requirements, and multi-generational architecture...
- MS SQL ServerMicrosoft SQL ServerMicrosoft SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network...
- MySQLMySQLMySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
- OracleOracle databaseThe Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....
- ODBC
- PostgreSQLPostgreSQLPostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
- SQLite 2 and 3SQLiteSQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library. The source code for SQLite is in the public domain and implements most of the SQL standard...
- Sybase ASEAdaptive Server EnterpriseAdaptive Server Enterprise is Sybase Corporation's flagship enterprise-class relational model database server product. ASE is predominantly used on the Unix platform but is also available for Windows.-History:...