Re: [sqlite] Multiple databases in one DB connection. How to let BEGIN TRANSACTION..COMMIT apply to only one of them?

Well, if the statements within your BEGIN TRANSACTION ... COMMIT only really affects one database (hereafter called the main database) only that database should be locked. If you experience otherwise, it could be because: 1. The locking_mode for the databases has been set to EXCLUSIVE (see

[sqlite] Multiple databases in one DB connection. How to let BEGIN TRANSACTION..COMMIT apply to only one of them?

While one of the databases is under a lengthy writing process, I don't want other databases to be locked by the BEGIN TRANSACTION...COMMIT lock. Is this possible? Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org