We're not talking about reliability or robustness of networked file
systems - those caveats are valid of course - but not relevant for
the case in point.
The case in point is a simple sequence of operations that you can execute
one at a time, as slowly as you like, and results in a corrupt
On Thu, Mar 25, 2010 at 10:58:41AM -0700, Dave Dyer scratched on the wall:
>
> >
> >AFAIK it's a general rule: don't use SQLite with database somewhere on
> >network shared file system, otherwise bad things can happen.
>
> That's definitely not the general rule.
Yes it is-- for *networked*
> That's definitely not the general rule. Generally, you can open
> a sqlite database from multiple processes and all of them can modify
> at will without corrupting the database.
You didn't understand my words correctly. Of course SQLite database
can be opened from multiple processes and used
>
>AFAIK it's a general rule: don't use SQLite with database somewhere on
>network shared file system, otherwise bad things can happen.
That's definitely not the general rule. Generally, you can open
a sqlite database from multiple processes and all of them can modify
at will without corrupting
On 25 Mar 2010, at 11:42am, Pavel Ivanov wrote:
> For me your sequence of commands clearly shows database file is badly
> managed by your Mac file system and/or network sharing mechanism.
Or by the client computer (which is running Windows).
The setup described by Mr. Dyer appears to involve a
For me your sequence of commands clearly shows database file is badly
managed by your Mac file system and/or network sharing mechanism.
Apparently when you try to delete rows from table on Mac SQLite didn't
understand that database was changed (probably because of some caching
either on Mac side
I was able to reproduce the problem using a trivial set of commands
to the standard sqlite command tool:
On the Mac:
gorp:~/2010 yeartech/yearbook tools/resource davedyer$
/applications/utilities/sqlite3-shell actiontool2.sqlite
SQLite version 3.6.10 with the Encryption Extension
sqlite>
7 matches
Mail list logo