[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Merge tracking: will SQLite make NFS sad?

From: Malcolm Rowe <malcolm-svn-dev_at_farside.org.uk>
Date: 2007-03-05 09:07:19 CET

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")

  • application/pgp-signature attachment: stored
Received on Mon Mar 5 09:07:35 2007

This is an archived mail posted to the Subversion Dev mailing list.