Thanks Richard. Yeah I now need two threads writing concurrently - my requirements have changed from when I first started using SQLite.
But anyway SQLite is awesome. Thank you. On Fri, Jul 25, 2014 at 6:58 PM, Richard Hipp-3 [via SQLite] < ml-node+s1065341n76965...@n5.nabble.com> wrote: > On Fri, Jul 25, 2014 at 4:46 AM, Tom <[hidden email] > <http://user/SendEmail.jtp?type=node&node=76965&i=0>> wrote: > > > I probably should have read the bit about concurrency on > > http://www.sqlite.org/whentouse.html huh :-) > > Although in my defense, my need for write concurrency is new. > > I do wonder if 2 DB's will work well. > > > > My understanding is that you have one reader and one writer, both on the > same box. Is that not correct? Because if it is correct WAL mode should > have solved your problem. If it didn't, then you might have been doing > something wrong. > > Beyond one-writer-and-multiple-readers, you need to go with a > client/server > solution. > > -- > D. Richard Hipp > [hidden email] <http://user/SendEmail.jtp?type=node&node=76965&i=1> > _______________________________________________ > sqlite-users mailing list > [hidden email] <http://user/SendEmail.jtp?type=node&node=76965&i=2> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://sqlite.1065341.n5.nabble.com/Does-SQLite-lock-the-entire-DB-for-writes-or-lock-by-table-tp76921p76965.html > To unsubscribe from Does SQLite lock the entire DB for writes, or lock by > table?, click here > <http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=76921&code=dG9tQG1lYW5mb3guY29tfDc2OTIxfDg0MjQ3NTc4OQ==> > . > NAML > <http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://sqlite.1065341.n5.nabble.com/Does-SQLite-lock-the-entire-DB-for-writes-or-lock-by-table-tp76921p76966.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users