Re: [sqlite] Multiprocess accessing SQLite connection

2013-06-17 Thread Vijay Khurdiya
On 6/17/2013 9:57 AM, Vijay Khurdiya wrote: > Do we can use attach & deattach option to read the other DB file data from > other process.? Yes you can, but you'd have exactly the same concurrency-related restrictions as when you open multiple connections to the same file directly. Connecting via

Re: [sqlite] Multiprocess accessing SQLite connection

2013-06-17 Thread Igor Tandetnik
On 6/17/2013 9:57 AM, Vijay Khurdiya wrote: Do we can use attach & deattach option to read the other DB file data from other process.? Yes you can, but you'd have exactly the same concurrency-related restrictions as when you open multiple connections to the same file directly. Connecting vi

Re: [sqlite] Multiprocess accessing SQLite connection

2013-06-17 Thread Vijay Khurdiya
Yes... but it should be clear that each process will have only access to the data it has written and it won't have Access to the data written by other processes. > I am not sure writing from other process is possible, provided other process > opening the connection to that DB file. > Do we can

Re: [sqlite] Multiprocess accessing SQLite connection

2013-06-17 Thread Paolo Bolzoni
Yes... but it should be clear that each process will have only access to the data it has written and it won't have access to the data written by other processes. On Mon, Jun 17, 2013 at 3:08 PM, Igor Tandetnik wrote: > On 6/17/2013 1:01 AM, Vijay Khurdiya wrote: >> >> In that case can I have sepa

Re: [sqlite] Multiprocess accessing SQLite connection

2013-06-17 Thread Igor Tandetnik
On 6/17/2013 1:01 AM, Vijay Khurdiya wrote: In that case can I have separate DB file associated with each process. Of course. Just pass different file names to sqlite3_open or similar. -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqli

Re: [sqlite] Multiprocess accessing SQLite connection

2013-06-16 Thread Vijay Khurdiya
On Fri, Jun 14, 2013 at 9:10 AM, Vijay Khurdiya < vijay.khurd...@securetogether.com> 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 conn

Re: [sqlite] Multiprocess accessing SQLite connection

2013-06-15 Thread Richard Hipp
On Fri, Jun 14, 2013 at 9:42 AM, wrote: > On Fri, 14 Jun 2013, Richard Hipp might have said: > > > I've read of multiple processes opening the same database. How far > can this go? Is it allowed to have one writer and many readers or can > each process be writer and reader? I am thinking of hav

Re: [sqlite] Multiprocess accessing SQLite connection

2013-06-15 Thread mikeegg1
On Fri, 14 Jun 2013, Richard Hipp might have said: > On Fri, Jun 14, 2013 at 9:10 AM, Vijay Khurdiya < > vijay.khurd...@securetogether.com> wrote: > > > Please confirm below statement is TRUE when Sqlit3 configure in thread > > safe mode. (I am checking for Serialized) > > > > "Multiple processes

Re: [sqlite] Multiprocess accessing SQLite connection

2013-06-14 Thread Richard Hipp
On Fri, Jun 14, 2013 at 9:10 AM, Vijay Khurdiya < vijay.khurd...@securetogether.com> 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 conn

[sqlite] Multiprocess accessing SQLite connection

2013-06-14 Thread Vijay Khurdiya
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"? Bye - This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confide