Re: [sqlite] Inserts silently failing

2017-02-12 Thread Keith Medcalf
On Sunday, 12 February, 2017 07:28, Brian Macy said: > Recently I removed a bunch of latency from my application. Suddenly I’m > getting odd errors where a record that was just inserted can’t be read by > the same process. SQLite does not do "per process"

Re: [sqlite] Inserts silently failing

2017-02-12 Thread Simon Slavin
On 12 Feb 2017, at 2:27pm, Brian Macy wrote: > Recently I removed a bunch of latency from my application. Suddenly I’m > getting odd errors where a record that was just inserted can’t be read by the > same process. In fact, even waiting till completion of the run, the

[sqlite] Inserts silently failing

2017-02-12 Thread Brian Macy
I have an application where multiple engines perform heavy write OLTP transactions on a repository. The engine supports many data stores and I recently added SQLite support. WAL is great, for small single node stuff SQLite is very fast and simple. I had turned of synchronous (=0), as for the