title: Are Google Cloud Disks OK to use with SQLite?
body: <p>Google Cloud disks are network disks that behave like local disks. SQLite expects a local disk so that locking and transactions work correctly.</p>
  <p>A. Is it safe to use Google Cloud disks for SQLite?</p>
  <p>B. Do they support the right locking mechanisms? How is this done over the network?</p>
  <p>C. How does disk IOP's and Throughput relate to SQLite performance? If I have a 1GB SQLite file with queries that take 40ms to complete locally, how many IOP's would this use? Which disk performance should I choose between (standard, balanced, SSD)?</p>
  <p>Thanks.</p>
  <p><strong>Related</strong></p>
  <p><a href="https://cloud.google.com/compute/docs/disks#pdspecs" rel="nofollow noreferrer">https://cloud.google.com/compute/docs/disks#pdspecs</a></p>
  <blockquote>
  <p>Persistent disks are durable <strong>network</strong> storage devices that your instances can access like physical disks</p>
  </blockquote>
  <p><a href="https://www.sqlite.org/draft/useovernet.html" rel="nofollow noreferrer">https://www.sqlite.org/draft/useovernet.html</a></p>
  <blockquote>
  <p>the SQLite library is not tested in across-a-<strong>network</strong> scenarios, nor is that reasonably possible. Hence, use of a remote database is done at the user's risk.</p>
  </blockquote>