On Fri, Jun 14, 2013 at 9:10 AM, Vijay Khurdiya < [email protected]> wrote:
> Please confirm below statement is TRUE when Sqlit3 configure in thread > safe mode. (I am checking for Serialized) > > "Multiple processes can access same database connection"? > False. A "database connection" is an in-memory object that communicates with an SQLite database file. The operating system prevents multiple processes from accessing the same memory, so it is not possible for multiple processes to access the same database connection. Perhaps you meant to ask if multiple processes could access the same SQLite database file at the same time. The answer to that question is "yes". An SQLite "database connection" is analogous to the FILE* handle of fopen(). You can fopen() the same file at the same time from multiple processes. Each process has its own private FILE* handle, but all FILE* handles point to the same file on disk. In the same say, each process using sqlite3_open() will have its own database connection, but all the database connections will be accessing the same database file. Thanks for your clear explanation. It is clear that if I have 'N' processes to access the same DB file then they all should have private connection for accessing the DB file. In that case can I have separate DB file associated with each process. With this I can have more flexibility to handle concurrent access. Bye - This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies and the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. The recipient acknowledges that Secure Meters Limited or its subsidiaries and associated companies(collectively "Secure Meters Limited"),are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Secure Meters Limi ted. Before opening any attachments please check them for viruses and defects. In case you have any problem or issue with the E-mails from Secure Meters Limited Please do lets us know on [email protected] Secure Meters Limited- Udaipur- Rajasthan -313001 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
