[boost] SOCI 2.2.0 - The C++ Database Access Library

From: Maciej Sobczak (prog_at_[hidden])
Date: 2006-12-05 04:23:49

Hi,

It's already a matter of "tradition" that all database discussions here 
have something to do with SOCI. ;-)

To confirm this "tradition", I would like to announce that the new 
version (2.2.0) of the SOCI library is available for download:

http://soci.sourceforge.net/

This new version provides:

1. Two new backends:
    - ODBC (tested with MS SQL Server)
    - Firebird

2. Complete build system for both Unix/Linux (autotools) and Windows 
(solution files for MSVC++).

3. STL-compatible iterators:

Rowset<string> rs = (sql.prepare << "select name from persons");
copy(rs.begin(), rs.end(), ostream_iterator<string>(cout, "\n"));

4. Stream-like interface for easier dynamic binding and field extraction 
from rows:

Row r;
sql << "select name, age, salary from persons where ...", into(r);

string name;
int age, salary;
r >> name >> age >> salary;

5. The comprehensive set of common tests for all supported database servers.

6. Some performance improvements for PostgreSQL.

7. Better docs.

8. Various fixes and tweaks.

I would like to stress that the ODBC support was our important milestone 
that now allows us to claim a quite extensive coverage of existing 
database technologies. With this in mind, SOCI becomes even more serious 
and our roadmap for the nearest future is to bring the library to the 
state that will make it a valid candidate for inclusion into Boost. We 
will therefore welcome your guidance and suggestions w.r.t. Boost 
compliance.

Note that up to this release, the library was deliberately developed 
without any external dependencies, so there are obviously wide areas 
where Boost might be applied within the library itself (example: 
intrusive pointers to manage some refcounted objects). This is easy.
The more difficult part is the library interface and its general philosophy.

We welcome your feedback.

-- 
Maciej Sobczak : http://www.msobczak.com/
Programming    : http://www.msobczak.com/prog/