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 databa
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* fil
> 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 sa
>
>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 or
I was able to reproduct 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> attach
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> attach
8 matches
Mail list logo