search

SOCI / soci

Official repository of the SOCI - The C++ Database Access Library
http://soci.sourceforge.net/
Boost Software License 1.0
1.41k stars 477 forks source link

Sqlite3 Support begin deffered, immediate, and exclusive transaction #1069

Open wakille opened 1 year ago

wakille commented 1 year ago

Hello together,

sqlite3 supports to start a transaction with different arguments like deffered, immediate, and exclusive. Is it possible to support to choose with which argument the transaction ist started ? E.g. with an enum ?

Thanks a lot

vadz commented 1 year ago

You can always execute the corresponding SQL command directly, but there is no support for this at the API level and I'm not sure if it really makes sense to add it as it's not clear how would this map to the other databases. But if it can be mapped to at least some of them in a reasonable way, it would be worth adding, of course.