Comments on Getting Clever: Vacuum your Firefox 3

All robotic vacuums, it's not for deep cleanin...

2011-03-02T05:49:02.080+08:00

All robotic vacuums, it's not for deep cleaning. Used regularly, it will help maintain carpets and floors and get to the spots under and behind furniture that you're likely to skip. To restrict the Neato from any areas, you have to lay down some of the 15-foot boundary marker that comes with it. In our lab tests, it worked very well on bare floors and also did a good.

Do you want to know which vacuum cleaner is best b...

2011-02-17T23:32:54.314+08:00

Do you want to know which vacuum cleaner is best before you buy? Then check out our detailed and unbiased vacuum reviews. With so many manufacturers and so many models to choose from, getting the right vacuum cleaner. We use many sources, This data is compiled into articles and tables to help you make the best possible buying decision.

There is an firefox extension that do the chores: ...

2010-11-10T18:38:25.036+08:00

There is an firefox extension that do the chores:

SQLite Optimizer
https://addons.mozilla.org/en-US/firefox/addon/11198/

When I tried using sqlite3 to vacuum my places.sql...

2010-09-27T07:11:19.022+08:00

When I tried using sqlite3 to vacuum my places.sqlite database I got "Error: database or disk is full" even though I had plenty of disk space. All other methods of vacuuming (such as compact function of SQLite Manager add-on in Firefox) didn't work either: Even if they did not emit an error message they didn't change the database so obviously failed.

I tried an sqlite3 integrity check on the database which said it was corrupted. The solution was to dump the database as text, use that to make a new database, then rename the file to places.sqlite. That I could vacuum and Firefox stopped hanging up for many seconds every time I typed in the URL bar.

The commands to dump and recreate the database were

echo '.dump' | sqlite3 places.sqlite | gzip -c > places.dump.gz

zcat places.dump.gz | sqlite3 places2.sqlite

for i in ${HOME}/.mozilla/firefox//.sqlite; do ...

2010-07-28T08:22:41.474+08:00

for i in ${HOME}/.mozilla/firefox/*/*.sqlite; do sqlite3 "$i" "VACUUM";sqlite3 "$i" "REINDEX"; done

for i in ${HOME}/.mozilla/firefox//.sqlite; do ...

2010-07-28T08:18:55.161+08:00

for i in ${HOME}/.mozilla/firefox/*/*.sqlite; do sqlite3 "$i" "VACUUM"; done

Here's a better Linux command for firefox vacu...

2010-06-09T03:35:33.370+08:00

Here's a better Linux command for firefox vacuum.

for x in `find ~ -type f -name *.sqlite* | grep firefox`;do echo "$x";sqlite3 $x VACUUM;done

This way it is easy to alias it and can be run from any directory.

Thanks for the blog post, BUT the windows command ...

2010-06-07T09:27:40.084+08:00

Thanks for the blog post, BUT the windows command is wrong.

Inside a bat file, the correct line is just this:

for %%i in (*.sqlite) do sqlite3 %%i VACUUM

cd ~/.mozilla/profile/9jdn39sdjk.default sqlite3 u...

2009-10-08T14:51:29.099+08:00

cd ~/.mozilla/profile/9jdn39sdjk.default
sqlite3 urlclassifier3.sqlite 'VACUUM;'
sqlite3 urlclassifier3.sqlite 'REINDEX;'
sqlite3 places.sqlite 'VACUUM;'
sqlite3 places.sqlite 'REINDEX;'

for i in `find ~/.mozilla -name \*.sqlite`; do sqlite3 $i vacuum; done
for i in `find ~/.mozilla -name \*.sqlite`; do sqlite3 $i reindex; done

Heh, my places.sqlite got trimmed down from 180M t...

2009-09-09T00:35:15.864+08:00

Heh, my places.sqlite got trimmed down from 180M to about 800k. Not bad. Thanks so much for this mini tutorial!

Thanks for the information about the firefox.I che...

2009-08-29T12:05:18.975+08:00

Thanks for the information about the firefox.I check my internet speed in the site www.ip-details.com.but my firefox is slow.From this article I know about the more information about the firefox and its speed.I hope this is very useful to all.

If you use BleachBit and select "places"...

2009-08-09T07:13:15.782+08:00

If you use BleachBit and select "places", by all means SAVE YOUR BOOKMARK BACKUPS in a place different from the "bookmarkbackups" profile folder. Reason being that BleachBit removes all of them too, but does not tell this explicitly beforehand. It only notifies the user that "bookmarks will be deleted" when places are selected.

If you are as common (or stupid) as me, you might think this pertains only to the current set of bookmarks and any necessary reconstruction can be done via one of the numerous backups.

It can't.

Wow, it actually worked. So simple, anyone could h...

2009-08-02T23:01:16.676+08:00

Wow, it actually worked. So simple, anyone could have thought of it (but didn't).

python cleaner on command line, full automatic for...

2009-07-19T12:44:42.942+08:00

python cleaner on command line, full automatic for all firefox profiles in user's account:

http://code.activestate.com/recipes/576842/

2009-07-02T11:22:38.494+08:00
BleachBit is an easy way to vacuum Firefox from a GUI and perform other system cleaning tasks

Da der Firefox 3 SQLite Datenbanken für so ziemlic...

2009-01-29T00:51:00.000+08:00

Da der Firefox 3 SQLite Datenbanken für so ziemlich alles verwendet, bringt es durchaus Performancevorteile wenn man die zwischendurch optimiert. Unter Linux Unix muss man dafür das sqlite3-Paket installiert haben, den Kommandozeilenclient für SQLite Datenbanken. Das Optimieren ist ganz einfach:

Der Befehl sorgt dafür das SQLite die Datenbanken von Sachen befreit die schon längt gelöscht wurden, wie viele andere Dateibasirende Datenbanken gibt auch SQLite seinen schon belegten Speicher nicht einfach so frei. Erst durch VACUUM wird das erledigt, welches Firefox dummerweise nicht selbst macht.

Zuvor sollte Firefox unbedingt beendet werden!

Das hat mir bei meinem Firefox ca. 30 MByte mehr freien Platz gebracht, und natürlich hakt Firefox nichtmehr so sehr wenn man mal in der History rumwühlt.

for f in ~/.mozilla/firefox/*/*.sqlite; do sqlite3 $f 'VACUUM;'; done

cd .mozilla/firefox/[Profilkennung]
for i in *.sqlite; do echo "VACUUM;" | sqlite3 $i ; done

* For Linux

$ for i in *.sqlite; do echo "VACUUM;" | sqlite3 $i ; done

* For Windows

for %i in (*.sqlite) do @echo VACUUM; | sqlite3 %i

Für Windows

sqlite-3 downloaden downloaden und in den Firefox profil ordner entpacken
Ins Verzeichins gehen vom firefox

C:\Dokumente und Einstellungen\benuztername\Anwendungsdaten\Mozilla\Firefox\Profiles\[Profilkennung]
und for %i in (*.sqlite) do @echo VACUUM; | sqlite3 %i

eingeben.

get SQLite Database Browser v1.3 (nothing to do with firefox) and then load your places.sqlite into it and then choose File > Compact Database. That might save you some space without loosing any of your data.

edit: of course, backup your places.sqlite file up somewhere before you compact it.

While FF is NOT running, check and see if your profile contains files in "bookmarkbackups", named thus: "bookmarks-2008-06-06.json". If you do have one then you don't need to make a new backup, you'll just use one of the Firefox-saved ones. (But this might be a brand new feature, maybe even newer than RC2... I'm personally running FF 3.1 test builds already, and don't know exactly when this Feature was put in.)

(B) If you don't have such a file, bring up firefox and save your bookmark to a "json" backup file. (NOT a mere "html" file, that's for exporting to non-Firefox browsers and it loses all your tags.) Then terminate Firefox

(C) One way or the other, you've now got a "*.json" backup file for your bookmarks. Now, while Firefox is not running, rename your "places.sqlite file to something else. (Like maybe, "places-dot-sqlite-saved-in-case-this-doesnt-work.old" :wink: .) Start up Firefox, it should create a new but empty "places.sqlite" file. Go to Bookmarks --> Organize Bookmarks and click "Backup/Restore". Use "Restore" with either the latest Firefox-built JSON file, or use "choose" to load from the one you made in step (A).

Your resulting "places.sqlite" should be MUCH smaller, and if you've set your "maximum days to keep in history" to an aggressive value, then it should stay that way. If it worked, go ahead and delete "places-dot-sqlite-saved-in-case-this-doesnt-work.old", which you can do even while FF is running.

doing an "Vaccum" / "Compact" function on the SQLite files of the profile
improves the performance at lot

Do you have the new security features

Tell me if the site I'm visiting is a suspected attack side
Tell me if the stie I'm viviting is a suspected forgery

active?

Then first change the preference

urlclassifier.updatecachemax from -1 to 104857600

(via using about:config).

The following SQLite file are part of your profile:

Verzeichnis von S:\mof-3000\mozilla\firefox\Profiles\5eqjlbn3.default

26.06.08 2.28 7168 0 content-prefs.sqlite
26.06.08 11.39 20480 0 cookies.sqlite
26.06.08 2.30 10240 0 downloads.sqlite
26.06.08 11.39 9216 0 formhistory.sqlite
26.06.08 2.31 2048 0 permissions.sqlite
26.06.08 11.39 3837952 0 places.sqlite
26.06.08 2.31 2048 0 search.sqlite
26.06.08 11.37 34660352 0 urlclassifier3.sqlite
8 Datei(en) 38549504 Byte belegt

Verzeichnis von
S:\mof-3000\mozilla\firefox\Profiles\5eqjlbn3.default\OfflineCache

22.06.08 19.46 4096 0 index.sqlite
1 Datei(en) 4096 Byte belegt

As you see, the file urlclassifier3.sqlite ist currenty 34 MB big.

This file is growing from 0 ( at creation of the profile )
to about 56 MB (before Vaccum/Ccmpact ) at my installation.

There is clear a need to "Vaccum" this file after creation of
a profile and first few surf sessions.

Hwoto to shrink / vacuum / compact the SQLite file.

1. Manual Way

1.1 Get the application SQLiteBrowse from sourceforge.net

http://sourceforge.net/project/showfiles.php?group_id=87946&package_id=91778&release_id=414746

Install the application on your system

1.2 shut down Firefox 3.0

1.3 save your current profile

1.4 Start the SQLite Browser

Open DB S:\mof-3000\mozilla\firefox\Profiles\5eqjlbn3.default\
urlclassifier3.sqlite

select menu Menue "File/Compact Database"

function processes at my installation about 1 min

Than the meassage box " compact done" is display with okay bottom

caveat: at the current version of SQLiteBrowser 1.3b
the cursor is still at "clock - Busy indicator -
but click to bottom okay works on my installation

Close the DB.

Repeat the procedure for the rest of the SQLite files of your profile

at my installation after 3 day of surfing,

the vacuum / compact function shrinks the

file urlclassifier3.sqlite from 56 MB to 34 MB

1.5 Do a test with Firefox 3.0

performance of your system? :-)

The RxSql package 2.5 is at SQLite 3.3.x

The SQLite is currently at SQLite 3.5.9 according project

References:
==============

Bug 439340 – Background cleanup actions block desktop on OS/2
https://bugzilla.mozilla.org/show_bug.cgi?id=439340

Firefox 3.0: Blockien des Systems durch minutenlange hohe HDD I/O Aktivität" - Workaround
http://de.os2.org/forum/diskussion/index.php3?all=116554

http://www.sqlite.org/

http://sqlitebrowser.sourceforge.net/index.html

http://www.sqlite.org/lang_vacuum.html

http://rexxsql.sourceforge.net/

Firefox/Tuning
Hier einige Optimierungsvorschläge um den Firefox zu beschleunigen.Die Datei user.js erstellen im Firefox profil.
Linux

cd .mozilla/firefox/[Profilkennung]
nano user.js
Windows

C:\Dokumente und Einstellungen\benuztername\Anwendungsdaten\Mozilla\Firefox\Profiles\[Profilkennung]

und folgendes einfügen

#tweaked firefox user.js
user_pref("content.interrupt.parsing", true);
user_pref("content.max.tokenizing.time", 2250000);
user_pref("content.notify.interval", 750000);
user_pref("content.notify.ontimer", true);
user_pref("content.switch.threshold", 750000);
user_pref("nglayout.initialpaint.delay", 0);
user_pref("network.http.max-connections", 48);
user_pref("network.http.max-connections-per-server", 16);
user_pref("network.http.max-persistent-connections-per-proxy", 16);
user_pref("network.http.max-persistent-connections-per-server", 8);
user_pref("browser.cache.memory.capacity", 65536);
user_pref("ui.submenuDelay", 0);
user_pref("network.dns.disableIPv6", true);
user_pref("mousewheel.withnokey.numlines", 15);
user_pref("mousewheel.withnokey.sysnumlines", false);
Turning off anti-phishing to speedup Firefox

The anti-phishing features of Firefox may cause Firefox to become slow to start or exit, and might also affect the browsing speed since Firefox apparently contacts google for every http request. The problem is that Firefox maintains a sqlite database that might grow quite big, and reading and writing to this database begins to take some time when it grows bigger. If you feel that you don't need Firefox to tell you which sites may be suspect you can disable this feature:

1. Turn off the following options under the security tab in preferences: "Tell me if the site I'm visiting is a suspected Attack site" and "Tell me if the site I'm visiting is a suspected forgery".
2. Delete all files beginning with urlclassifier in your profile folder (~/.mozilla/firefox/********.default where ******** is some combination of letters and numbers. default might be something else if you have created a non-default profile). Some of these files might be recreated by Firefox, but they won't grow any larger than their initial size.

rm -i ~/.mozilla/firefox/*.default/urlclassifier*

IPv6 deaktivieren

Es kann unter gewissen Netzwerkkonstellationen vorkommen, dass Firefox bei aktivierter IPv6-Unterstützung sehr langsam ist, oder seiten gar nicht geladen werden können. Um die IPv6-Funktion zu deaktivieren, muss man den entsprechenden Wert über „about:config“ auf „true“ setzen.

network.dns.disableIPv6

Sollte der Seitenaufruf allerdings funktionieren, sollte man diese Option so belassen, wie sie ist. Durch das deaktivieren der IPv6-unterstützung in Firefox erhält man keine Vorteile, wenn es auch mit aktivierter unterstützung funktioniert.

Firefox Tweaks
Speed Up Firefox Web Browser Tips

* Applications -> Internet -> Firefox Web Browser

* Mozilla Firefox

Address Bar -> about:config

Filter: ->
network.dns.disableIPv6 -> true
network.http.pipelining -> true
network.http.pipelining.maxrequests -> 8
network.http.proxy.pipelining -> true

* Restart Mozilla Firefox

How to disable beep sound for link find function in Mozilla Firefox

* Applications -> Internet -> Firefox Web Browser

* Mozilla Firefox

Address Bar -> about:config

Filter: accessibility.typeaheadfind.enablesound -> false

* Restart Mozilla Firefox

Setting the backspace button to go to a previous page

* Applications -> Internet -> Firefox Web Browser

* Mozilla Firefox

Address Bar -> about:config

Filter: -> browser.backspace_action -> 0

* Restart Mozilla Firefox

Close the Download dialog quicker

* Go to Applications -> Internet -> Firefox Web Browser

* Put in your address bar

Address Bar -> about:config

Filter the configs options

Filter: -> alerts.totalOpenTime -> 500

Reduce the quantity of popups

* Load Mozilla Firefox

* Applications -> Internet -> Firefox Web Browser

* Put in your address bar

Address Bar -> about:config

* Filter the config options and change it to a reasonable number

Filter: -> dom.popup_maximum -> 5

Hide the Go Button

* Load Mozilla Firefox

* Applications -> Internet -> Firefox Web Browser

* Put in your address bar

Address Bar -> about:config

* Filter the config options and double click so it changes the result

browser.urlbar.hideGoButton -> Yes

Speed improvements using tmpfs

* Load Mozilla Firefox

* Applications -> Internet -> Firefox Web Browser

* Put in your address bar

Address Bar -> about:config

* Right click anywhere in the browser window and select

New -> String

* Type in:

browser.cache.disk.parent_directory

* press OK, and type in the new window:

/tmp

Step 1. Reduce the size of your profile directory.

tmpfs is RAM-backed, so we want to conserve memory by trimming the fat
from the profile. I recommend making the following config changes
(enter 'about:config' in the Firefox address bar):

set browser.cache.disk.capacity to 20000 or thereabouts

set browser.safebrowsing.enabled to false

set browser.safebrowsing.malware.enabled to false

The first one reduces the size of the disk cache to about 20 MB,
down from 50MB. It might be tempting to turn disk cache off entirely,
but I've encountered poor performance doing that in the past; I think
that the caching algorithm has to be able to push things into disk
cache for best performance, even if they won't stay there long.

The last two disable the collection of the information in the
'urlclassifier*.sqlite' files. These hold Firefox's database of
suspected malware or phishing sites, and while most users will feel
comfortable turning this off, it does in theory leave you more
vulnerable to these types of attacks. There's a known bug in Firefox
which can make these files grow quickly; on my system, they were 70MB
total.

After you've changed these settings, clear the cache in Firefox and
delete the urlclassifier*.sqlite files from your profile directory.
(SQLite will recreate empty databases but they'll stay at 32k.) My
profile is about 54MB in total size now, which is quite reasonable.

Step 2. Edit the fstab and prepare the backup tarball.

First, create a tarball of your profile as it currently stands.

Code:
$ cd
$ cd .mozilla/firefox
$ tar cpf packed.tar abcd1234.default

abcd1234.default should be replaced by your profile directory name here and below.

Now edit /etc/fstab and add a line like this:

Code:
firefox /home/steven/.mozilla/firefox/abcd1234.default tmpfs size=128M,noauto,user,exec,uid=1000,gid=100 0 0

You'll have to adjust path components, uid and gid.

Step 3. Set up a backup and restore script.

This is an example, but is by no means the only way to do it. I'll assume you've named the script "${HOME}/.pack_ffox.sh" in future commands, so replace that with whatever you decide to do.

Code:
#!/bin/bash

# Change this to match your correct profile
PROFILE="abcd1234.default"

cd "${HOME}/.mozilla/firefox"

if test -z "$(mount | grep -F "${HOME}/.mozilla/firefox/${PROFILE}" )"
then
mount "${HOME}/.mozilla/firefox/${PROFILE}"
fi

if test -f "${PROFILE}/.unpacked"
then
tar --exclude '.unpacked' -cpf packed.tmp.tar "$PROFILE"
mv packed.tar packed.tar.old
mv packed.tmp.tar packed.tar
else
tar xpf packed.tar &&\
touch "${PROFILE}/.unpacked"
fi

This script will load your firefox profile if it hasn't been loaded, and save it otherwise (keeping one backup copy from a few minutes ago in case of file corruption or the like). Once you've got it saved, you'll need to quit Firefox for this next step. Open in links, copy and paste to a text editor, or just remember the steps.

Step 4. Switch over.

With Firefox closed, you need to empty your profile directory. Either move the files currently in there to a new folder, or simply erase them (remember, a copy is in packed.tar as well). Be sure to leave the empty profile directory there for the tmpfs mount point.

Now, run the script:
Code:
$ "${HOME}/.pack_ffox.sh"

Verify that your profile directory is now mounted on tmpfs, that your files got correctly unpacked, and that the file .unpacked exists inside of your profile directory.

Now run the script again, exactly as before. This time, it will detect that your profile's been unpacked and is ready to use, and create a new packed.tar. If it worked, you should now have the file ".mozilla/firefox/packed.old.tar" as well.

If both of those things checked out, you're clear to start Firefox again.

I recommend adding the command to your .xinitrc or desktop-environment-specific startup settings, so that it's ready to go when you log in. It's also critical that you run it again before you shut down your computer, or you'll lose all changes. One of the safest ways for users on media that doesn't have limited write-cycles is to simply add an entry to the crontab which runs the script every five minutes. Run this command to edit the crontab:

Code:
# crontab -u USERNAME -e

which will bring up your editor. Add a line akin to this one:

Code:
*/5 * * * * $HOME/.pack_ffox.sh

Check in five minutes to make sure the mtime of packed.tar has changed, indicating that the script is working.

For windows users, I wrote a little batch file tha...

2008-07-16T01:19:00.000+08:00

For windows users, I wrote a little batch file that runs vacuum every tenth run. It's not pretty but if you use it to start FF it will compress the files every tenth run. You will need sqlite3.exe in the directory with the batch file and adjust the path as necessary. I put the batch file and sqlite3.exe in the profile folder.

@echo off

if not exist fixcount.txt echo J > fixcount.txt

FIND "A" fixcount.txt
IF ERRORLEVEL 1 GOTO none
IF ERRORLEVEL 0 GOTO zero
:none
FIND "B" fixcount.txt
IF ERRORLEVEL 1 GOTO ntwo
IF ERRORLEVEL 0 GOTO one
:ntwo
FIND "C" fixcount.txt
IF ERRORLEVEL 1 GOTO nthree
IF ERRORLEVEL 0 GOTO two
:nthree
FIND "D" fixcount.txt
IF ERRORLEVEL 1 GOTO nfour
IF ERRORLEVEL 0 GOTO three
:nfour
FIND "E" fixcount.txt
IF ERRORLEVEL 1 GOTO nfive
IF ERRORLEVEL 0 GOTO four
:nfive
FIND "F" fixcount.txt
IF ERRORLEVEL 1 GOTO nsix
IF ERRORLEVEL 0 GOTO five
:nsix
FIND "G" fixcount.txt
IF ERRORLEVEL 1 GOTO nseven
IF ERRORLEVEL 0 GOTO six
:nseven
FIND "H" fixcount.txt
IF ERRORLEVEL 1 GOTO neight
IF ERRORLEVEL 0 GOTO seven
:neight
FIND "I" fixcount.txt
IF ERRORLEVEL 1 GOTO nnine
IF ERRORLEVEL 0 GOTO eight
:nnine
FIND "J" fixcount.txt
IF ERRORLEVEL 1 GOTO error
IF ERRORLEVEL 0 GOTO nine

:error
ECHO There was some error.
GOTO exit

:zero
Echo "Cleaned one run ago"
echo B > fixcount.txt
Goto exit

:one
Echo "Cleaned two runs ago"
echo C > fixcount.txt
Goto exit

:two
Echo "Cleaned three runs ago"
echo D > fixcount.txt
Goto exit

:three
Echo "Cleaned four runs ago"
echo E > fixcount.txt
Goto exit

:four
Echo "Cleaned five runs ago"
echo F > fixcount.txt
Goto exit

:five
Echo "Cleaned six runs ago"
echo G > fixcount.txt
Goto exit

:six
Echo "Cleaned seven runs ago"
echo H > fixcount.txt
Goto exit

:seven
Echo "Cleaned eight runs ago"
echo I > fixcount.txt
Goto exit

:eight
Echo "Cleaned nine runs ago"
echo J > fixcount.txt
Goto exit

:nine
Echo "Cleaning"
echo A > fixcount.txt
for %%i in (*.sqlite) do @echo VACUUM; | sqlite3 %%i
Goto exit

:exit

start "" "F:\Program Files\FirefoxPortable\FirefoxPortable.exe"

exit

It is probably easier to
- install the SQLite ...

2008-07-06T14:31:00.000+08:00

It is probably easier to
- install the SQLite Manager Firefox Plugin
- start it via the 'SQLite Manager' on the Tools menu in Firefox

From the Database menu
- connect to the large databases in both the
..Local Settings\Application Data\Mozilla..profiles...
..Application Data\Mozilla\...profiles...

They might be named: urlclassifier3.sqlite, urlclassifier2.sqlite, places.sqlite

Go to Database Menu
- compact Database

Voila!

My urlclassifier3.sqlite compacted from 54MBs to 28MBs.

Well, I know it can be done a lot faster via SQLite3.exe and a command line, but I couldn't figure out how to do a Vacuum, as I couldn't find detailed instructions.

I hope this helps - and doesn't screw up someone's Firefox installation.

If I've screwed up PLEASE say so. I'm pretty clueless when it comes to databases.

(The above anonymous posts were all from the same ...

2008-06-18T23:49:00.000+08:00

(The above anonymous posts were all from the same person.)

OK, the command worked when I compiled SQLite vers...

2008-06-18T23:47:00.000+08:00

OK, the command worked when I compiled SQLite version 3.5.9.

thanks!

0e21gnpi.default$ sqlite3 places.sqlite

SQL...

2008-06-18T23:37:00.000+08:00

0e21gnpi.default$ sqlite3 places.sqlite

SQLite version 3.1.3
Enter ".help" for instructions
sqlite> .tables

Error: unsupported file format

I'm running the new Firefox that was released yest...

2008-06-18T23:34:00.000+08:00

I'm running the new Firefox that was released yesterday (3.0) with the sqlite3 (3.1.3) that apparently comes with OS X (10.4.11).

It worked okay on some of the files, but not the important ones (eg. not on "places").

There doesn't seem to be any distribution of sqlite for the Mac much more recent than that. I'll see if I can build it from source.

Could you post some more details?

Are you s...

2008-06-18T18:00:00.000+08:00

Could you post some more details?

Are you sure Firefox is not running (could be in the background).

What version of sqlite3 are you using? Firefox 3 ships with 3.5.4.1.

What happens if you try to access the data like this:

sqlite3 places.sqlite
> .tables

When I try this on the places.sqlite file, I get: ...

2008-06-18T15:17:00.000+08:00

When I try this on the places.sqlite file, I get: "SQL logic error or missing database".

Comments on Getting Clever: Vacuum your Firefox 3

All robotic vacuums, it's not for deep cleanin...

Do you want to know which vacuum cleaner is best b...

There is an firefox extension that do the chores: ...

When I tried using sqlite3 to vacuum my places.sql...

for i in ${HOME}/.mozilla/firefox/*/*.sqlite; do ...

for i in ${HOME}/.mozilla/firefox/*/*.sqlite; do ...

Here's a better Linux command for firefox vacu...

Thanks for the blog post, BUT the windows command ...

cd ~/.mozilla/profile/9jdn39sdjk.default sqlite3 u...

Heh, my places.sqlite got trimmed down from 180M t...

Thanks for the information about the firefox.I che...

If you use BleachBit and select "places"...

Wow, it actually worked. So simple, anyone could h...

python cleaner on command line, full automatic for...

2009-07-02T11:22:38.494+08:00 BleachBit is an easy way to vacuum Firefox from a GUI and perform other system cleaning tasks

Da der Firefox 3 SQLite Datenbanken für so ziemlic...

For windows users, I wrote a little batch file tha...

It is probably easier to - install the SQLite ...

(The above anonymous posts were all from the same ...

OK, the command worked when I compiled SQLite vers...

0e21gnpi.default$ sqlite3 places.sqliteSQL...

I'm running the new Firefox that was released yest...

Could you post some more details?Are you s...

When I try this on the places.sqlite file, I get: ...

for i in ${HOME}/.mozilla/firefox//.sqlite; do ...

for i in ${HOME}/.mozilla/firefox//.sqlite; do ...

2009-07-02T11:22:38.494+08:00
BleachBit is an easy way to vacuum Firefox from a GUI and perform other system cleaning tasks

It is probably easier to
- install the SQLite ...

0e21gnpi.default$ sqlite3 places.sqlite

SQL...

Could you post some more details?

Are you s...