Re: [sqlite] Techniques to delay writes to SQLite

2009-02-03 Thread Petite Abeille
On Feb 3, 2009, at 3:12 PM, Brandon, Nicholas (UK) wrote: > I'm open to other techniques particularly if they would be simpler to > implement and manage! Using a queue of DML statements sound very reasonable :) Nanoki [1] uses that technique when indexing text documents with fts3: (1) A reques

Re: [sqlite] Techniques to delay writes to SQLite

2009-02-03 Thread Daniel Watrous
While I'm not sure how long your long running select would take, it seems like SQLite (at least version 3) already works the way you are describing. As soon as you issue a select against a database file a shared lock is obtained. On commit that shared lock is released. While you have a shared com