Database libraries - again

Considering the fact that there was some interest in the database library, I think it is a good time to revive the discussion: ------- We are pleased to announce that the new version of SOCI library is available for download. http://soci.sourceforge.net/ The important new feature in the library allows to operate on whole arrays of values (interfaced via std::vector), which can greatly increase application performance by reducing network round-trips in those queries that insert or retrieve many rows at once. -------- I think that this feature is mandatory if we discuss a "quality" library. The question is how to interface to it and how much generic interface can be provided wrt so-called bulk operations. At the moment, SOCI supports interfacing via std::vector, for example: std::vector<int> vec; // ... sql << "insert into numbers(val) values(:val)", use(vec); or: vec.resize(100); // some batch size Statement st = (sql.prepare << "select val from numbers", into(vec)); st.execute(); while (st.fetch()) { // here, vec has subsequent portions of the whole result } Your comments are welcome. I would like to acknowledge that Steve Hutton entirely contributed to the implementation of the bulk operations in this new release. You can visit Steve at <http://featurecomplete.com/> -- Maciej Sobczak : http://www.msobczak.com/ Programming : http://www.msobczak.com/prog/

Andy Little wrote:
At the moment only Oracle is supported, through its native OCI interface. There are plans to support other database servers. -- Maciej Sobczak : http://www.msobczak.com/ Programming : http://www.msobczak.com/prog/

Andy Little wrote:
FWIW zip and tgz for latest version v1.2 ? -- for seems to be empty!
Looks like SF is having problems. The files are listed with correct size, but indeed download as empty. More interestingly, it worked fine yesterday. I already complained at SF, please check it a bit later. -- Maciej Sobczak : http://www.msobczak.com/ Programming : http://www.msobczak.com/prog/
participants (2)
-
Andy Little
-
Maciej Sobczak