[sqlite] Location of Sqlite Files
Hey, I am kind of new to SQLite. I was wondering if anyone could help me with a couple things: 1) Where are the SQLite databases stored? I was told in the C:\WINDOWS\temp folder, but I can't seem to find any SQLite-related files there. 2) How do you delete a SQLite database? Any help is much appreciated, thank you. -- View this message in context: http://old.nabble.com/Location-of-Sqlite-Files-tp26545375p26545375.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Location of Sqlite Files
1) save the db wherever is appropriate for your application. (network drives are generally considered to be a bad idea) 2) An sqllite db is a file. There are lots of ways to delete files Adam On Fri, Nov 27, 2009 at 2:54 PM, mr_orange rlvl...@gmail.com wrote: Hey, I am kind of new to SQLite. I was wondering if anyone could help me with a couple things: 1) Where are the SQLite databases stored? I was told in the C:\WINDOWS\temp folder, but I can't seem to find any SQLite-related files there. 2) How do you delete a SQLite database? Any help is much appreciated, thank you. -- View this message in context: http://old.nabble.com/Location-of-Sqlite-Files-tp26545375p26545375.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- VerifEye Technologies Inc. 905-948-0015x245 7100 Warden Ave, Unit 3 Markham ON, L3R 8B5 Canada ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Location of Sqlite Files
1) I store my sqlite files at directories where i use it. Where do you know to store sqlite files in the temp directory? I use sqlitefront - like phpmyadmin - and there are also my files stored for better editing. 2. Ehm .. right click delete? Or you mean to delete a whole database? use php function unlink for this. with best wishes Artur Hey, I am kind of new to SQLite. I was wondering if anyone could help me with a couple things: 1) Where are the SQLite databases stored? I was told in the C:\WINDOWS\temp folder, but I can't seem to find any SQLite-related files there. 2) How do you delete a SQLite database? Any help is much appreciated, thank you. -- View this message in context: http://old.nabble.com/Location-of-Sqlite-Files-tp26545375p26545375.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Location of Sqlite Files
On 27 Nov 2009, at 7:54pm, mr_orange wrote: Hey, I am kind of new to SQLite. I was wondering if anyone could help me with a couple things: 1) Where are the SQLite databases stored? I was told in the C:\WINDOWS\temp folder, but I can't seem to find any SQLite-related files there. 2) How do you delete a SQLite database? Mr. Orange is obviously used to SQL engines which manage many files in a designated folder, for example MySQL. SQLite handles databases very simply. The first SQLite call you issue will probably be one that opens a database file or creates a new one if the file doesn't already exist. In this call you supply the full path and filename. So you could tell SQLite to open the file C:\MyFiles\databases\animals.db and that's one file will hold all the data. Once your application has closed the connection that file is just a file: move it from folder to folder, copy it to a Flash drive, or delete it as you wish. One note: while your application has the database open you may see a journal file, in the same folder as the database file with almost the same name. Once your application has closed the database file, the journal file will disappear. If the application crashes, when you next open the databases file SQLite will notice the journal file and use what it finds to update the database file without any corruption. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users