SQLITE + problems saving tables
 

hey all, i am a newbie to SQL, and decided to start with SQLITE3. I am learning commands and manipulating data in a table. HOwever every time i .quit sqlite and open again, any new table i have just made is not saved?? DO i understand that sqlite should execute the transaction commands by itself (begin, commit).

i downloaded sqlite-3.1.6.tar.gz, unziped, configure, make && makeinstall
with no problems

WHen i run i can enter data into a table but does not save.

i have tried to open sqlite3 like so:
$ ./sqlite3 testdb

but when i try to create a table i get the error:
Unable to open database "testdb": unable to open database file

$ ./sqlite // this works, but again .tables shows nothing after .quit

ANy ideas???
thanks all
josh

i'd assume that you've not got permissions to save it. you're calling sqlite with a relative path.. are you working in /usr/local/bin directly or something? is there some reason sqllite isn't working on just a path statement?