On Mon, Mar 18, 2013 at 10:36 PM, Alykhan Jetha <[email protected]>wrote:
> Just to be clear. > Is it true that I can have one and only one connection per thread? > No. You can have as many connections per thread as you want (subject to your operating system's ability to give you new file descriptors.) But Posix Advisory Locking is broken in the POSIX specification - broken by design. SQLite works around this brokenness, and so you are safe as long as you do not defeat the work-arounds. But if you are doing something squirrelly you might cause problems. This is discussed in http://www.sqlite.org/howtocorrupt.html -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
