APQ - The PostgreSQL/MySQL Thick Binding

APQ is a project created by Warren W. Gay (ve3wwg). It is a thick binding for PostgreSQL and MySQL database completely written in Ada95.

Current Release

MySQL support is now included in APQ 2.1. The following are some reasons you want to use APQ as your Ada95 binding to the PostgreSQL and/or MySQL database:

  • It is a thick binding to the database library(ies)
  • Very simple to use
  • Uses Ada95 data types only (no C language interfaces)
  • Full BLOB support(PostgreSQL only)
    • Open/Create blobs
    • Read/Write blobs using Ada95 stream I/O
    • Buffered BLOB I/O for greater performance
  • Generic functions and procedures allowing strongly typed programming
  • Generic database programming is available (database neutral code)
  • Very simple to install under Linux/FreeBSD:
    • Simple compile and install process
    • Only depends upon PostgreSQL libpq
    • No ODBC required! Direct interface to database.
  • Full support of NULL indicators (strongly typed)
  • Source code is almost all Ada95 (tested under GNAT-3.15p, Linux, Win2k)
  • Extensive page programmer’s manual (almost all functions have an example code fragment)
  • ACL or GPL2 license (dual license - you choose)
  • Win32 clients are supported (in APQ 2.1)
  • Under active development
  • Sybase support coming with APQ 2.2!

Here is what users said about APQ:

Charles Darcy , charlie+at+mullum+dot+com+dot+au November 30, 2002 said

Thanks for ‘apq’. The packages are easy to understand and use, and the doc’s are helpful. With the help of ‘apq’ and ‘PostgreSQL’, I was able to build a largish, functional database in less than a week.

Download APQ Software or Manual

Alternatively, if APQ is not right for you, try GNADE for Ada.