title: Difference between SQLite Temporary DB and InMemory DB
body: <p>What is the difference between SQLite InMemory DB and Temporary DB ?</p>
  
  <p>Reference: <a href="https://www.sqlite.org/inmemorydb.html#temp_db" rel="nofollow">Temporary DB</a></p>
  
  <p>While I expect Temporary DB is a disk backed file DB, the documentation is little confusing as it says temporary DB is almost same as in memory DB.</p>
  
  <p>I am looking for a temporary disk file DB, where records are written to file on the disk.
  If temporary DB are stored as file on the disk, where do I find them ? I understand that when the connection is closed the DB cease to exist but while the connection is open I expect to find the DB on the disk.</p>