title: Sqlite over a network share
body: <p>Does anyone have real world experience running a Sqlite database on an SMB share on a LAN (Windows or Linux)?</p>
  
  <p>Its clear from the <a href="http://www2.sqlite.org/cvstrac/wiki?p=SqliteNetwork" rel="noreferrer">documentation</a> that this is not really the fastest way to share a Sqlite database. </p>
  
  <p>The obvious caveats are that it may be slow, and Sqlite only supports a single thread writing to the DB at a time. So you become a lot less concurrent cause your DB updates now will block the DB for longer (DB will be locked while data is in transit over the network).</p>
  
  <p>For my application the amount of data that I would like to share is fairly small and writes are not too frequent (a few writes every few seconds at most). </p>
  
  <p>What should I watch out for? Can this work? </p>
  
  <p>I know this is not what Sqlite was designed for, I am less interested in a Postgres/MySql/Sql Server based solution as I am trying to keep my app a light as possible with a minimal amount of dependencies.</p>
  
  <p>Related Links: </p>
  
  <p>From the <a href="http://www.mail-archive.com/sqlite-users@sqlite.org/msg37281.html" rel="noreferrer">sqlite mailing list</a>, so I guess one big question is how unreliable are the filelock apis over SMB (windows or linux) </p>