APQ – The PostgreSQL/MySQL Thick Binding

UPDATE: I am no longer maintaining APQ. The project is now hosted at SourceForge.
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.

Comments

3 Responses to “APQ – The PostgreSQL/MySQL Thick Binding”

  • Tony Gair on October 13th, 2009 0:50 1

    Hi,
    I am trying to compile the sources on ubuntu 9.05 and I am getting an error

    ADA_INCLUDE_PATH=. ADA_OBJECTS_PATH=. gnatmake -c -gnata -gnatf -gnato -gnatwp -O0 comp_mysql
    gcc-4.3 -c -gnata -gnatf -gnato -gnatwp -O0 comp_mysql.adb
    apq-mysql.ads:34:24: identifier expected
    apq-mysql.ads:36:23: aggregate may not have single positional component
    apq-mysql.ads:36:24: missing operand
    gnatmake: “comp_mysql.adb” compilation error
    make: *** [mysql1] Error 4

    Is the version of gnat I am using do you know?

    regards
    Tony

  • Adrian Hoe on October 15th, 2009 22:04 2

    Hi Tony,

    Sorry for the late response. FYI, I am no longer maintaining APQ. It is currently hosted at SourceFirge. I hope this helps.

  • mourice on May 10th, 2010 22:51 3

    Everywhere I look I hear about the 3.x version of APQ. It’s maintained on the http://www…..br website and not put where it can be quickly downloaded.

    What, now we have to have a Brazilian version versus an American version? We in America have to download 2.1 and upgrade it as a forked-off version? Okay!!

Leave a Reply