SQLite table does not save

Question

I have a query regarding SQLite. I run it on Mac OS X. I created a table, added, deleted rows, column values, and everything worked fine. But when I close the terminal and exit and open the terminal again, the table I created earlier no longer exists. this is normal behavior such as a session, or am I mistaken somewhere.

Answer 1

You are connecting to the database by name. If, by default, the sqlite3 processor does not create a database in memory, and it will disappear after shutdown.

Try starting a session like this:

sqlite3 my_database.litedb