Use ".open FILENAME" to reopen on a persistent database. sqlite> How to exit the SQLite CLI. By default, the CLI works with an in-memory database. To save your data across sessions, it’s best to ...