Not without reading the source code and patching it at a very deep level. In our setup we use virtual tables almost exclusively and these do not support transactions. There are also dedicated writers for each set of tables, so table locking outside of SQLite is sufficient. The only changes that require SQLite to lock the database file(s) are metadata changes (CREATE VIRTUAL TABLE and DROP TABLE). I have added a second bitmap to the code generator that allows me to suppress the Cookie opcode unless a VCreate or VDestroy opcode is generated on a specific database file.
There are some caveats and this is not quite ACID but sufficient for our application, which uses SQL as a universal query interface for application status, report generation and configuration updates. -----Ursprüngliche Nachricht----- Von: Joshua Grauman [mailto:jnf...@grauman.com] Gesendet: Dienstag, 26. November 2013 20:25 An: sqlite-users@sqlite.org Betreff: [sqlite] Transaction involving multiple attached databases Hello all, If I have multiple databases attached and then do a: BEGIN EXCLUSIVE I assume all the sqlite3 tables involved get locked? Is there a way to lock only one of the attached tables? Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -------------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
