title: Is sqlite last_insert_rowid atomic?
body: <p>I use node.js sqlite3 to manipulate data. I use these codes to insert data to database and get inserted id:</p>
  
  <pre><code>db.run("INSERT INTO myTable (name) VALUES ('test')");
  db.get("SELECT last_insert_rowid() as id", function (err, row) {
       console.log('Last inserted id is: ' + row['id']);
  });
  </code></pre>
  
  <p>I think this is not stable. my db connection is always open. when my server serves this code on multiple and same time connections from clients, Does<code>SELECT last_insert_rowid()</code> get id rightly?
  Is sqlite last_insert_rowid atomic?
  thanks.</p>