[odb-users] ODB 2.2.0 released
Boris Kolpackov
boris at codesynthesis.com
Wed Feb 13 06:53:05 EST 2013
Hi,
We have released ODB 2.2.0. The NEWS file entries for this release are
as follows:
* Multi-database support. This mechanism allows an application to
simultaneously work with multiple database systems and comes in two
flavors: static and dynamic. With static support the application uses
the static database interfaces (that is, odb::<db>::database instead
of odb::database). With dynamic support the same application code can
access multiple databases via a common interface. Dynamic multi-database
supports also allows the application to dynamically load the database
support code for individual database systems if and when necessary. For
more information, refer to Chapter 14, "Multi-Database Support" in the
ODB manual.
* Support for prepared queries. Prepared queries are a thin wrapper around
the underlying database system's prepared statements functionality. They
provide a way to perform potentially expensive query preparation tasks
only once and then execute the query multiple times. For more information,
refer to Section 4.5, "Prepared Queries" in the ODB manual as well as the
'prepared' example in the odb-examples package.
* Mapping for char[N] and std::array<char, N> to database VARCHAR(N-1) (or
similar) as well as for char to database CHAR(1) (or similar). For SQL
Server and SQLite on Windows equivalent mappings for wchar_t are also
provided. Also the query support for arrays has been improved to allow
passing a value of the decayed type (pointer) as a query parameter.
For more information, refer to the ODB manual "Type Mapping" sections
for each database system.
* Support for change-tracking std::vector and QList container equivalents.
Change-tracking containers minimize the number of database operations
necessary to synchronize the container state with the database. For
more information, refer to Sections 5.4, "Change-Tracking Containers",
5.4.1 "Change-Tracking vector", and 22.3.1, "Change-Tracking QList"
in the ODB manual.
* Support for automatically-derived SQL name transformations (table, column,
index, etc). At the higher level, it is possible to assign prefixes and
suffixes (--table-prefix, --{index,fkey,sequence}--suffix options) as
well as to convert to upper or lower case (--sql-name-case option). At
the lower level, it is possible to specify transformations as regular
expressions (--{table,column,index,fkey,sequence,sql-name}-regex options).
For more information, refer to the SQL NAME TRANSFORMATIONS section in
the ODB compiler command line interface documentation (man pages).
* New options, --export-symbol and --extern-symbol, allow DLL-exporting of
the generated database support code.
* Support for transaction post- commit/rollback callbacks. For more
information, refer to Section 13.1, "Transaction Callbacks" in the ODB
manual.
* Support for custom session implementations. For more information, refer
to Section 10.2, "Custom Sessions" in the ODB manual.
* Support for early connection release. Now the database connection is
released when commit()/rollback() is called rather than when the
transaction instance goes out of scope.
* New odb::schema_catalog function, exists(), can be used to check whether
a schema with the specified name exists in the catalog.
* Support for SQL Server ROWVERSION-based optimistic concurrency. For more
information, refer to Section 19.1.1, "ROWVERSION Support" in the ODB
manual.
* Support for specifying the SQL Server transaction isolation level. For
more information, refer to Section 19.2, "SQL Server Database Class" in
the ODB manual.
* Support for "smart" containers. A smart container is provided with
additional functions which allow it to insert, update, and delete
individual elements in the database. Change-tracking containers are
examples of smart containers that utilizes this new functionality.
Currently only ordered smart containers are supported. Note also that
with this addition the names of the database functions provided by the
ODB compiler (see libodb/odb/container-traits.hxx) have changed. This
will only affect you if you have added ODB persistence support for a
custom container.
This release also adds support for Qt5 in addition to Qt4, including VC++
project/solution files as well as the autotools build system update.
We have also upgraded the private copy of GCC that is used by the ODB
compiler binary packages to 4.7.2 (actually, 4.7.3 pre-release) on all
the platforms. In particular, this should make a difference to projects
wishing to use C++11 features.
Another notable addition is support for mobile/embedded systems. With
this release we have added Raspberry Pi ARM GNU/Linux computer as one
of the test targets and written a guide on using ODB on Mobile and
Embedded Systems:
http://wiki.codesynthesis.com/Using_ODB_on_Mobile_and_Embedded_Systems
A more detailed discussion of the major new features can be found in the
following blog post:
http://www.codesynthesis.com/~boris/blog/2013/02/13/odb-2-2-0-released/
This release has been tested with a large number of platform/compiler/
architecture/library combinations. Specifically:
Platform Compiler Version C++ Std Arch Qt Boost Databases
-------------------------------------------------------------------------
GNU/Linux GCC 4.4-4.8 C++98,11 x86 32/64 4,5 Y All
GNU/Linux Clang 3.2 C++98,11 x86 64 4 Y All
Raspberry Pi GCC 4.7 C++98 arm - - SQLite
Solaris Sun CC 12u2 Cstd x86 32/64 - - All ex MS SQL
Solaris Sun CC 12u2 STLPort x86 32/64 - - All ex MS SQL
Solaris Sun CC 12u2 Cstd SPARC 32/64 - - All ex MS SQL
Mac OS X GCC 4.2 C++98 x86 32 4 Y All ex MS SQL
Windows VC++ 9.0 C++98 x86 32/64 4 Y All
Windows VC++ 10.0 C++11 x86 32/64 4,5 Y All
Windows VC++ 11.0 C++11 x86 32/64 4 Y All
MinGW-W64 GCC 4.7 C++98 x86 32 5 Y All
We would also like to thank everyone who reported bugs, suggested fixes
or new features, as well as tested early versions of this release. In
particular, big thanks goes to Hugo Mildenberger who is working on
packaging ODB for Gentoo and Dave Johansen who is doing the same for
RHEL/CentOS. Hugo Mildenberger has also tracked down a number of issues
in ODB when using MariaDB in place of MySQL. Thanks to his efforts ODB
tests now run cleanly against MariaDB.
Source code and pre-compiled binary packages for this release are available
from the ODB Download page:
http://www.codesynthesis.com/products/odb/download.xhtml
SHA1 checksums for the files in this release are as follows:
c02bc276a48bd8afa3c38b54c1bae790eb061643 libodb-2.2.0.tar.bz2
84adcfdb7cd311ea5cd666a3945713a4ef1f69c5 libodb-2.2.0.tar.gz
f799bb2a3dc4e1eb6c432d5be3fe45cbce56a46d libodb-2.2.0.zip
54bb977beb5bea52eac958eba7e7b1121d5a347a libodb-boost-2.2.0.tar.bz2
fdf57dba0618266e7b948c7e40e09ae2b128dbca libodb-boost-2.2.0.tar.gz
71d5f749264ef64ac2844b6a0f02063accc610ec libodb-boost-2.2.0.zip
ef1fe4216f7756d101a82bc9b728dd4276ecbf73 libodb-mssql-2.2.0.tar.bz2
1daa0d6eda89477bc2a73be89dca4a55e720ddc7 libodb-mssql-2.2.0.tar.gz
620b801743c04b004c6f237f89e76954596c38cd libodb-mssql-2.2.0.zip
acb7f12d58d264f2288285ddd6ed3f3df7c98e8c libodb-mysql-2.2.0.tar.bz2
39a1cdea0cb3e3b6f349c58ce03c4ca237a70e35 libodb-mysql-2.2.0.tar.gz
34cb972170e79fa5f3b3654f5c835dbc0a950097 libodb-mysql-2.2.0.zip
856920bcaf477881d590f4bd5391add18ac6e3e1 libodb-oracle-2.2.0.tar.bz2
916f268778baf5e068497fe5b6d5c50b4cd5e2da libodb-oracle-2.2.0.tar.gz
0639ae29941b72d091eede855523d13588ea2212 libodb-oracle-2.2.0.zip
0bf21dcc5b319e8c5932fb015340bfcbeff69d80 libodb-pgsql-2.2.0.tar.bz2
10eb2dfa5b9ff6c81fa03b00442661e3da7b664c libodb-pgsql-2.2.0.tar.gz
6b65f92137dd9f2f93af604ca08050cc51feded5 libodb-pgsql-2.2.0.zip
d0a26521c1747458ca09e85b97fa7036506b54b5 libodb-qt-2.2.0.tar.bz2
c07a54d4cfa786c49acfe3e521877598ddc8a82c libodb-qt-2.2.0.tar.gz
b78556dd925a1aebcfba3148b8811fe3b1beb228 libodb-qt-2.2.0.zip
a05fee4a452fde7371a78d662e27dd97fbacc14b libodb-sqlite-2.2.0.tar.bz2
458a605ff5945484cd150d81f0b1a7ea16e3a10c libodb-sqlite-2.2.0.tar.gz
3bc453b745bc104a8fdbb7a6f054fa49bdc46e67 libodb-sqlite-2.2.0.zip
c58e80e579c4c49fff19055ee2a47064b5fd0805 odb-2.2.0-i686-linux-gnu.tar.bz2
a8764c780244b137369e8a0382cf3025ae661f03 odb-2.2.0-i686-macosx.tar.bz2
2e62dc711c3108d8a35c7466f0eca8e191ed26ed odb-2.2.0-i686-solaris.tar.bz2
2df92be11f939962f227d8e57e68b7b2f2b64be9 odb-2.2.0-i686-windows.zip
205b40ddb1ba426a348e0007ba262c82a1a11fd1 odb-2.2.0-sparc-solaris.tar.bz2
61657833e119373b4d66f2ccbb1938d7cf57ab1d odb-2.2.0.tar.bz2
ba204e2f3201caac72ecfc6c1e5e3b68f64583fd odb-2.2.0.tar.gz
bfaee59d843facc8ce641232b8b00f7ace7c7d22 odb-2.2.0-x86_64-linux-gnu.tar.bz2
560edb6af4798d6846f6182c22b30b2992af9571 odb-2.2.0.zip
8ba9d5303154a40adfb9db5d989cf56ca8c52b74 odb-examples-2.2.0.tar.bz2
d28a00e6580c3ce8d4bef64ad5836028c873f15e odb-examples-2.2.0.tar.gz
3bd6d2b727997873f326833152914ec8a027820b odb-examples-2.2.0.zip
3ea7fbd83c9c00806453a4b3fa5aefa3995f5c0a odb-tests-2.2.0.tar.bz2
4246bd448c1b149abc176375617326157ba48017 odb-tests-2.2.0.tar.gz
3d2fd3afdcbb212cd8419c4e6cf34ddba1836fe8 odb-tests-2.2.0.zip
Enjoy,
Boris
More information about the odb-users
mailing list