Hi, I have a query regarding SQLite. I am running it on Mac OS X. I created a table, added, deleted rows,columns values and everything is working fine. But when i close the terminal and exit, and reopen the terminal again, the table that i created previously is no longer there. is thi sthe normal behaviour like session only or am i going wrong somewhere.
+1
A:
Are you connecting to a database by name. If not by default the sqlite3 engine will create an in-memory database, and that will disappear once you disconnect.
Try starting your session with something like this:
sqlite3 my_database.litedb
My Other Me
2010-09-13 06:17:42
Hi...Thanks for this info. I did not know that by default the engine creates an in-memory database. That would explain why it is no longer there when i reconnect. But i could not comprehend how to sort this. I am not sure i understand what is meant by connecting to a database by name...Could u slightly elaborate...Thx a billion anyways
2010-09-13 06:48:05
Ah...What a n00B i've been... I confused the table we create as the DB...got it...Now it works fine. I never created a db, just created some tables... Thx a lot again buddy!
2010-09-13 06:52:26
No problem. I make mistakes too before my first coffee.
My Other Me
2010-09-13 07:29:45