Difference between SQLite Temporary DB and InMemory DB

Question

What is the difference between SQLite InMemory DB and Temporary DB ?

Reference: Temporary DB

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.

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.

Answer 1

The documentation you linked to says:

Even though a disk file is allocated for each temporary database, in practice the temporary database usually resides in the in-memory pager cache and hence is very little difference between a pure in-memory database created by ":memory:" and a temporary database created by an empty filename. The sole difference is that a ":memory:" database must remain in memory at all times whereas parts of a temporary database might be flushed to disk if database becomes large or if SQLite comes under memory pressure.

The default location for temporary database files is the temporary directory, with a file name like etilqs_*. But as mentioned above, often it is not necessary for the data to be actually stored in this file.