Tiny Core Linux

Tiny Core Extensions => TCE Talk => Topic started by: bmarkus on May 02, 2011, 08:48:36 AM

Title: Vacuum your Firefox 3
Post by: bmarkus on May 02, 2011, 08:48:36 AM

Looking for some information on SQLite by accident found this interesting article:

http://www.gettingclever.com/2008/06/vacuum-your-firefox-3.html

It may help to reduce backup size and improve performance, worth to try. What you need is sqlite3-bin.tcz extension.

Title: Re: Vacuum your Firefox 3
Post by: tinypoodle on May 02, 2011, 03:52:36 PM

Not using any netscape based browser myself since long, but when using hv3 which can store all its settings in one single sqlite file, if I run a vacuum script before backup then backup will definitely end up with a reduced size.

Code: [Select]

#!/bin/sh
for f in /home/tc/.local/share/data/hv3/hv3_state.db; do sqlite3 $f VACUUM; done

Title: Re: Vacuum your Firefox 3
Post by: tinypoodle on May 16, 2013, 08:17:45 PM

For a script which is automatically optimizing all sqlite databases in rootfs see here:

http://forum.tinycorelinux.net/index.php/topic,15399.msg89188.html