Merge tracking: will SQLite make NFS sad?

Hi Dan,

I notice that SQLite currently recommends [1] that you don't use it over a
network filesystem. People are currently happily using FSFS repositories
stored on NAS boxes (over CIFS and NFS), because we've been careful to
make sure it works.

How do we reconcile these two statements?

I'm also wondering how SQLite would work out with multiple clients:
conceivably you could deploy a farm of mod_dav_svn servers for
load-balancing purposes, and they could share a single backend FS on a
NAS.

In my (albeit limited) experience of SQLite, it doesn't seem to attempt a
great deal of concurrency (until recently, you could deadlock by deleting
rows that you were currently iterating through with a SELECT).

Regards,
Malcolm

[1] http://www.sqlite.org/lockingv3.html
    (under "How To Corrupt Your Database Files")