> How do I find the current/default location? This is Operating System dependent. <https://sqlite.org/tempfiles.html> Section 5 > Why do I never find 1 in the seq column? (first column) seq 0 is always the main database -- the one opened when the connection was created. seq 1 is always the temp database -- which may not exist if it has never been used. seq 2 and after are the currently attached databases in order of attachment. > As with :memory: I can attach as many '' (temp) databases as long as the name/alias is unique. Correct? Yes. And each so attached database is unique to the connection.