SQLite Forum

Temp database
Login
> 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.