Re: [sqlite] Shell tool locks database ? AFP access a problem ?

2011-08-24 Thread Simon Slavin
On 24 Aug 2011, at 3:07pm, Richard Hipp wrote: > You've run up against limitations of AFP. Or, more precisely, you've run up > against the performance/concurrency tradeoffs that are inherent in any > network filesystem. > > Apple has contributed working (though wildly complex) code that allows

Re: [sqlite] Shell tool locks database ? AFP access a problem ?

2011-08-24 Thread Stephan Beal
On Wed, Aug 24, 2011 at 6:14 PM, Pavel Ivanov wrote: > This is completely unrelated because Oracle works differently. > Regardless of the reason for the specific behaviours, the symptoms are similar, and they are both locking-related problems. Maybe off-topic, admittedly,

Re: [sqlite] Shell tool locks database ? AFP access a problem ?

2011-08-24 Thread Pavel Ivanov
> i saw the same behaviour with Oracle's CLI client > ("sqlplus") - as long as i had sqlplus opened and connected, my PHP pages > couldn't insert any data. > > i.e. this type of problem isn't limited to sqlite3. This is completely unrelated because Oracle works differently. And if you saw this

Re: [sqlite] Shell tool locks database ? AFP access a problem ?

2011-08-24 Thread Stephan Beal
On Wed, Aug 24, 2011 at 3:51 PM, Simon Slavin wrote: > SQLite3::query(): Unable to execute statement: database is locked in > [...]readrec.php > For what it's worth: while porting a customer's PHP app from MySQL to Oracle early this year, i saw the same behaviour with

Re: [sqlite] Shell tool locks database ? AFP access a problem ?

2011-08-24 Thread Richard Hipp
On Wed, Aug 24, 2011 at 9:51 AM, Simon Slavin wrote: > On a Mac running OS X 10.6.8 Server. Being accessed by another Mac running > 10.6.8 Client. > > The shell tool I'm using is the one found on a standard installation of OS > X 10.6.8. It accesses the database by

[sqlite] Shell tool locks database ? AFP access a problem ?

2011-08-24 Thread Simon Slavin
On a Mac running OS X 10.6.8 Server. Being accessed by another Mac running 10.6.8 Client. The shell tool I'm using is the one found on a standard installation of OS X 10.6.8. It accesses the database by opening the file across an AFP connection to the server. The shell tool can read and