On Thu, 21 May 2015 17:54:50 +0800 (CST), "miles zhang" <zhang876905 at 163.com> wrote:
>dear, > thanks for your reading. > I have 2 different databases , and I create 2 threads > to access such 2 databases with sqlite3 sql statement?? You do not have to create a thread for each database connection, but it is possible. You would sqlite3_open() one database in each thread, each database gets its own handle. > can it be done successfully like this using sqlite3 lib? Yes. > is it need to control access of such 2 thread for competition ? > for example , locker. No, database connections are independent. Synchronization between them is done with file locking that sqlite provides automatically. You would only have to synchronize between the threads (with a mutex) if they both use the same database connection. > thx, > hope your reply soon. > > miles zhang > 2015-05-21 -- Regards, Kees Nuyt
