On Sat, Mar 22, 2008 at 06:44:45PM +0900, Fred Janon wrote: > Hi, > > I read the documentation, features and faq and could not find anything that > specifies where (which directory) the database file is stored. I launched > sqlite3.exe on windows without a database name, using the '.databases' > command, I get: > > sqlite> .databases > seq name file > --- --------------- > ---------------------------------------------------------- > 0 main > sqlite> > > and since it doesn't show a file, I presume that sqlite does actually > support in-memory temporary databases? Where is is documented?
SQLite supports file and/or in-memory databases. The file is wherever you tell it to be. Start the sqlite3.exe command with an (unused) filename and you'll see that file created when you do any writes to this new database. You might want to start here: http://sqlite.org/quickstart.html > > Thanks > > Fred _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
