title: How to use SQLite in rollback mode?
body: <p>Hi I'm building a simple system by python with SQLite, I set a db file on NFS to allow writing by only one user but with multiple readers from different machines, all I need is to know how to implement isolation by locking the database file and preventing any reads by other database connections while each write transaction is underway, that's a sample of my code:</p>
  <pre><code>conn = sqlite3.connect(&quot;C:\الموارد البشرية &amp; الرعاية الطبية\HR2.db&quot;)
  conn.rollback()
  c = conn.cursor()
  c.execute(&quot;INSERT INTO connected VALUES (?,?,?,?)&quot;, (record[1], dateYY, first_date, final_date))
  conn.commit()
  conn.close()
  </code></pre>