See the .save command. ``` SQLite version 3.35.0 2020-12-25 00:58:53 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .save test.db sqlite> .help save .save FILE Write in-memory database into FILE sqlite> .exit >dir test.db 2020-12-25 18:06 4,096 test.db ``` and actually, no database is created or opened until you access it. Note also that .save works to save whatever database is currently open with the schema name "main", it does not have to be an in-memory database.