Gizmos Freeware Reviews  

Go Back   Gizmo's Freeware Forum > Debating Chamber > Internet, Web Apps and Networking

Reply
 
Thread Tools Display Modes
Old 12. Sep 2010, 02:22 PM   #11 (permalink)
Senior Member
 
Join Date: Mar 2010
Posts: 395
Default

This is what the SQLite site has:
Quote:
(12) I deleted a lot of data but the database file did not get any smaller. Is this a bug?

No. When you delete information from an SQLite database, the unused disk space is added to an internal "free-list" and is reused the next time you insert data. The disk space is not lost. But neither is it returned to the operating system.

If you delete a lot of data and want to shrink the database file, run the VACUUM command. VACUUM will reconstruct the database from scratch. This will leave the database with an empty free-list and a file that is minimal in size...
vasa1 is offline   Reply With Quote
Old 12. Sep 2010, 02:41 PM   #12 (permalink)
Senior Member
 
Join Date: Mar 2010
Posts: 395
Default

Hmmm...

My last words on the topic. I had the impression that .sqlite files were quite common on my PC. I was wrong. They're only in the Firefox folders. So I'm not going to bother too much with them.
vasa1 is offline   Reply With Quote
Old 12. Sep 2010, 05:26 PM   #13 (permalink)
Banned
 
Join Date: Sep 2009
Posts: 57
Default SQLite 3 not recommended by Mozillazine

Quote:
Originally Posted by vasa1 View Post
@mikecorbeil:

Thanks for waking up this thread. Really nice info here.

The link that Chrisgiz provided led to other good stuff and to this:
http://mozillalinks.org/wp/2009/07/v...r-performance/
SQLite.org's sqlite3 is not recommended at mozillazine.org, which is, I believe, the Mozilla products' "community" website. Actually, it's the auto-vacuum mode of sqlite3 3.1 that's not recommended.

Quote:
This article talks about using the sqlite vacuum command to defragment the database to decrease startup time. This forum thread has a script to do that under Ubuntu. I haven't tried this since I don't enable history but I've found several Mozillazine forum threads [1] [2] that claim its useful.

(http://)(www.)sqlite.org/lang_vacuum.html mentions that SQLite version 3.1 (Firefox 3.0 uses SQLite version 3.5.4) added support for a auto-vacuum mode that can be used instead but it has several drawbacks. Its also not clear that when the history gets too old that that causes a large enough delete for this mode to do anything useful. Tanstaafl 14:49, 11 July 2009 (UTC)
http://kb.mozillazine.org/Talk:Increasing_startup_speed

That's SQLite 3 and not SQLite3 3.x, I believe; and the latter is what mozillalinks.org refers to.

I checked if Softpedia, CNET, MG, and Snapfiles have downloads for sqlite3. Softpedia has a download for sqlite3 3.7.2 (the current version at sqlite.org), and CNET has a 3.5.x download; but I would not want to run this tool as explained in the mozillalinks.org page you provided a link for. I don't like needing to bring up a file manager and then navigating down to the Firefox profiles; only doing that on occasion, as infrequently as possible. And I have several profiles within my principal Windows user account; because they're for totally different purposes and I don't like building up huge bookmarks files with bookmarks and folders thereof for several different purposes.

But a small script could surely be created and then saved to the user's desktop folder in order to have a script-launch icon on the desktop for running the command or commands for cleaning the .sqlite files in each of the Firefox profiles. A simple and easy-to-write or create .bat file should do the trick.

However, I wonder if the auto-vacuum mode in sqlite3 is still problematic, because if it is, then I'd make sure that this mode is disabled. Not knowing whether it is still a problem, I'd disable this mode and would only run the .bat command file on demand.

Re. links in the above-quoted Mozillazine text:

The first paragraph has a few links in it and the first one, for ``This article talks about ...``, is for the mozillalinks.org link you provided.

Closing:

I`ll give this a try, and thanks for the tip.

Last edited by mikecorbeil; 12. Sep 2010 at 05:49 PM.
mikecorbeil is offline   Reply With Quote
Old 12. Sep 2010, 06:15 PM   #14 (permalink)
Banned
 
Join Date: Sep 2009
Posts: 57
Default WARNING: IniFox generates 10 alerts at VirusTotal.com

vasa1 referred to an article at mozillalinks.org and that article says that IniFox from InfoSpyware is a .zip archive that contains sqlite3, which is supposed to be from sqlite.org, ``and an interactive batch file that defragments all databases in your profile as described above``. I think the above thing referred to is the use of a .bat file or script using loop code, like a ``for loop`` sort of loop.

That mozillalinks.org article recommended IniFox from InfoSpyware and I downloaded this for the script that the article says is included, but just uploaded the download Inifox archive to Virustotal and there are 10 warnings from 43 AVs, which is a high percentage of warnings, imo.

The warings are from Antiy-AVL, Authentium, Comodo, F-Prot, Jiangmin, K7AntiVirus, McAfee, Sophos, TrendMicro, and TrendMicro-Housecall.

So I just ran ``destroy`` on the Inifox download. Bye-bye to that nonsense.

Before doing that, however, I opened the archive with 7-Zip to see what files were in this article and there`s only inifox.exe, which I suppose is supposed to create or install the script when the installer is run, which apparently should not be done.

SQLite3 from sqlite.org passes all of the scans at Virustotal, so I`d just put the loop command shown in the mozillalinks.org article in a .bat file using a text editor, while placing the file in my desktop folder. The only difference would be that the command would need to be repeated for each of my profiles, and the full paths to the Firefox profile folders would need to be specified. That`s all simple and quick to do and we can do it with a simple text editor, only needing to save the file with the .bat extension.

Last edited by mikecorbeil; 12. Sep 2010 at 06:22 PM.
mikecorbeil is offline   Reply With Quote
Old 13. Sep 2010, 04:13 PM   #15 (permalink)
Senior Member
 
Join Date: Jul 2009
Location: Northeast US
Posts: 476
Default

Quote:
Originally Posted by Sope View Post
Is this the same thing that CCleaner does when "compact databases" (under Firefox) is selected?
I haven't seen an answer to this very good question about CCleaner taking care of bloated sqlite database associated with Firefox. IMHO CCleaner takes care of maintaining Firefox pretty well. I would have to have a very good reason and a proven method for using anything other than CCleaner to maintain Firefox.

T
Taurus is offline   Reply With Quote
Old 13. Sep 2010, 06:26 PM   #16 (permalink)
Senior Member
 
Join Date: Feb 2009
Location: Wales, UK
Posts: 1,174
Default

Quote:
Originally Posted by Taurus View Post
I haven't seen an answer to this very good question about CCleaner taking care of bloated sqlite database associated with Firefox.
I've recently found out that it does the same for Chrome (and Iron) too.

To quote this Piriform page :-

"CCleaner can now vacuum (or compact) SQLite databases for Firefox and Google Chrome, which can speed up those browsers."
Sope is offline   Reply With Quote
Old 14. Sep 2010, 03:39 AM   #17 (permalink)
Senior Member
 
Join Date: Mar 2010
Posts: 395
Default

I don't get this! I searched my PC for .sqlite but the only hits I found were Firefox-related.

If Chrome is indeed using SQLite, what suffix do the data files carry?
vasa1 is offline   Reply With Quote
Old 14. Sep 2010, 01:21 PM   #18 (permalink)
Senior Member
 
Join Date: Feb 2009
Location: Wales, UK
Posts: 1,174
Default

@vasa1

Maybe these web pages will help you in your search.

http://unlockforus.blogspot.com/2008...-location.html
http://blogs.sans.org/computer-foren...ome-forensics/

Last edited by Sope; 14. Sep 2010 at 01:25 PM. Reason: addition
Sope is offline   Reply With Quote
Old 14. Sep 2010, 01:38 PM   #19 (permalink)
Senior Member
 
Join Date: Mar 2010
Posts: 395
Default

Quote:
Originally Posted by Sope View Post
Thanks a million! What I wanted and a lot more useful stuff!
vasa1 is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT +1. The time now is 12:20 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.