SOCI-Ada - manual

Introduction
Compilation
Concepts
Common Idioms
API Reference

SOCI-Ada is a database access library for Ada.

The library itself is a wrapper for the selected functionality of the SOCI library, which is a C++ database access library recognized for its high quality and innovative interface.
The main SOCI project is hosted at:

http://soci.sourceforge.net/

The SOCI-Ada library offers the following features to the Ada community:

Modular design based on dynamic backend loading. Thanks to this feature, new backends implemented within the context of the main SOCI project are immediately available for Ada programmers without any additional work. A large community of C++ users can help ensure that the new backends are well tested in a variety of environments and usage scenarios.
Native backends for major database servers ensure optimal performance and minimize configuration overhead and complexity that is usually associated with other database access methods.
Direct support for bulk operations allow to achieve high performance with queries that operate on large data sets.
Very liberal open-source license (Boost, accepted by Open Source Initiative) that encourages both commercial and non-commercial use.
Easy to use and compact interface.

Currently the following database servers are directly supported via their native interfaces:

Oracle
PostgreSQL
MySQL

Other backends exist in the SOCI CVS repository and can be provided with future version of the library.

Compilation

In order to use SOCI-Ada, download the recent release of main SOCI library from:

http://sourceforge.net/project/showfiles.php?group_id=121480

Compilation steps are described at:

http://soci.sourceforge.net/doc/structure.html

Note: SOCI header files are not needed to use SOCI-Ada, only compiled SOCI libraries (core and relevant backend) need to exist to build and use SOCI-Ada programs.

The SOCI-Ada library itself is a single package named SOCI. The complete source code for this package is available in both Ada 2005 and Ada 95 versions and can be just included in the target project as is or pre-built to the binary form if required.

In order to link the user programs the -lsoci_core -lstdc++ linker option need to be provided on the Unix/Linux platforms.

Next: Concepts