Ada Programming/Libraries/Database
From Wikibooks, open books for an open world
The following libraries help you in Database programming:
| Library | License | MySQL | ODBC | Oracle | PostgreSQL | SQLite 3 | Sybase | Other database | Binary packages | Notes |
|---|---|---|---|---|---|---|---|---|---|---|
| APQ | GMGPL | Yes | Yes | — | Yes | — | Yes | — | Debian | Thread-safe connection pools |
| GNADE (GNu Ada Database Environment) | GMGPL | 3.x, 4.x | Yes | — | Yes | Yes | — | — | Debian | Embedded SQL preprocessor |
| gnadelite | ? | ? | ? | ? | ? | Yes | ? | ? | ? | |
| GNATCOLL (database interface module) | GPL/GMGPL | Yes | — | — | Yes | Yes | — | — | ? | gnatcoll_db2ada generates thick Ada bindings to a specified database schema. Requires Ada 2005. |
| GWindows | ? | ? | Yes | ? | ? | ? | ? | ? | ? | Windows only? |
| Matreshka SQL | BSD | — | — | Yes | Yes | Yes | — | — | OpenSUSE, Fedora | |
| ODBC | GPL | ? | Yes | ? | ? | ? | ? | ? | none | Windows only. Depends on Win32Ada. Very simple. |
| QtAda (QtSql module) | GPL/GMGPL | Yes | Yes | Yes | Yes | Yes | Yes | IBM DB/2, SQLite2, Borland Interbase | Microsoft Windows | Binding to Qt: requires C++ |
| Simple Components for Ada (SQLite package) | GMGPL | — | — | — | — | Yes | — | — | none | Intended for static linking with the SQLite3 amalgation |
| SOCI-Ada | Boost | Yes | — | Yes | Yes | — | — | — | ? | Requires C++. |
| SQLite3-Ada | Public domain | — | — | — | — | Yes | — | — | ? |