Re: [sqlite] Using VACUUM on an empty file will create a defaultdatabase
On 7/25/2013 2:51 AM, sworddrag...@aol.com wrote: I'm not sure what you want to say me. "echo 'garbage' > some/random/file" will also overwrite non-empty files which is more problematic. Precisely. So do you believe there should be an option to disable echo command? Or rm command? Or cp command? There are lots of ways a person could "destroy complete environments" - why are you singling out one of the more obscure and relatively harmless ones? -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using VACUUM on an empty file will create a defaultdatabase
I also have hard time follow... My answer would be: "yes," What is the problem? On Thu, Jul 25, 2013 at 8:51 AM, wrote: > I'm not sure what you want to say me. "echo 'garbage' > some/random/file" > will also overwrite non-empty files which is more problematic. > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using VACUUM on an empty file will create a defaultdatabase
I'm not sure what you want to say me. "echo 'garbage' > some/random/file" will also overwrite non-empty files which is more problematic. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using VACUUM on an empty file will create a defaultdatabase
sworddrag...@aol.com wrote: > I'm using sqlite3 3.7.9 on Ubuntu 12.04 dev. If the VACUUM command is used on > empty files it will create a default database (for > example "touch /tmp/test.txt && sqlite3 /tmp/test.txt VACUUM"). > > If this behaviour is wanted there should be an option to disable this because > it could destroy complete environments like > operation systems. In other news, "echo 'garbage' > some/random/file" considered harmful. -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Using VACUUM on an empty file will create a default database
I'm using sqlite3 3.7.9 on Ubuntu 12.04 dev. If the VACUUM command is used on empty files it will create a default database (for example "touch /tmp/test.txt && sqlite3 /tmp/test.txt VACUUM"). If this behaviour is wanted there should be an option to disable this because it could destroy complete environments like operation systems. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] using vacuum
If there is no redundancy to remove then the database size will remain the same. Vacuum is only really effective after you delete a large amount of data from a DB. - Scott Li, Charles wrote: > Hi, > I use the vacuum command on a database, but the size remains the same. What > should I check? > > Thanks, > Charles Li -- Scott Baker - Canby Telcom RHCE - System Administrator - 503.266.8253 - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] using vacuum
Hi, I use the vacuum command on a database, but the size remains the same. What should I check? Thanks, Charles Li