Re: [sqlite] specific behavior of busy_timeout with different transaction modes

2010-11-10 Thread Peter Pawlowski
Thanks, Edzard. For the record, we also found that there is a good explanation of this in the book "Using SQLite" from O'Reilly on pages 153-154. We opened an issue [1] on the Rails project. best, Peter [1] https://rails.lighthouseapp.com/projects/8994-ruby-on-rails/tickets/5941 On 11/10/10

Re: [sqlite] specific behavior of busy_timeout with different transaction modes

2010-11-10 Thread Edzard Pasma
On 9-nov-2010, at 18:22 Peter Pawlowski wrote: > While debugging an issue with using SQLite with a Rails > application, we > discovered that the behavior of SQLite when setting the > 'sqlite3_busy_timeout' option was unexpected. > > After reading and grokking the SQLite documentation about

[sqlite] specific behavior of busy_timeout with different transaction modes

2010-11-09 Thread Peter Pawlowski
While debugging an issue with using SQLite with a Rails application, we discovered that the behavior of SQLite when setting the 'sqlite3_busy_timeout' option was unexpected. After reading and grokking the SQLite documentation about locking (or doing our best to, at least!) it seems that this