Page 1 of 1

basics of sqlite

Posted: Wed Feb 16, 2005 10:47 pm
by saumya
Hello friends,
I am very new to server side and databases.I have started studying PHP for some time now.By the course of my reading I came across sqLite database mentioned at http://www.zend.com. There its written that if you have PHP5 running then you have a running SQLite too.But I could not get that , how can i use that?Again there is a link to sqlite website too.I went there and downloaded a windows version of sqlite too.But when i unzip the file I found there is only one exe file in it.When i double click the file it opens the sqlite manager I think on command prompt.but what next.Where it creates the database and where it stores.I invoked the command "sqlite "test.db" " but that i think does not respond.I am running PHP5.0 win windows 2000.Is it possible to run sqlite with only PHP5.0 installed and no extra sqlite modules as the one I have downloaded.I want to know both the situtations.Please help.
Thank you
Saumya

Posted: Wed Feb 16, 2005 11:56 pm
by timvw
meaby you should read the documentation at the sqlite site?
then you would know where it stores it's data (hint: it's in the files) and know how it compares to a csv file with some sql extensions..