Re: [sqlite] Using VACUUM on an empty file will create a defaultdatabase

[Igor Tandetnik]

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

[Paolo Bolzoni]

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

[sworddragon2]

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

[Igor Tandetnik]

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

[sworddragon2]

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

[Scott Baker]

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

[Li, Charles]

Hi,
I use the vacuum command on a database, but the size remains the same.  What
should I check?
 
Thanks,
Charles Li