On Fri, Jun 14, 2013 at 9:42 AM, <[email protected]> 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 having one process > web facing, when a request comes from the web the web facing process > writes a record to a transaction table. Another process waits for work > in the transaction table, removes a record from that transaction table, > and does the requested work. > > Does that make sense and is that possible? Both processes would write > to the datbase file. >
There can only be one writer at a time. You can do what you describe, and have multiple writers, it is just that the writers have to take turns. The locking system of SQLite will enforce this for you. > > Mike > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
