Re: vacuum browser

4 views
Skip to first unread message

os...@wisdomtree.info

unread,
May 16, 2020, 9:33:57 AM5/16/20
to dev-po...@lists.mozilla.org
** Reply to note from dev-ports-...@lists.mozilla.org Sat, 16 May 2020 12:00:02 +0000
>
> Are there any program(s) that can sort of vacuum-clean the SQL databases which FF uses so She can shrink them down thereby freeing space on the
> Y: volume where the Mozilla tree sits?

https://hobbes.nmsu.edu/download/pub/os2/apps/database/sqlitebrowser13j.zip
Separate tool when mozilla is not operating, functions with any sqlite file.
--

https://hobbes.nmsu.edu/download/pub/os2/apps/internet/misc/upssv-1.0rc3.zip
For mozilla specifically
--

There is an addon extension that does this when mozilla is running. Do not have exact name of this at the moment. Such as:
- install the SQLite Manager Firefox Plugin
- start it via the 'SQLite Manager' on the Tools menu in Firefox

--
SqLite command line client is supposed to have the ability to vacuum files. There are several versions at archive sites.

--
Do you have the following turned on in preferences? Exact wording may differ between versions. Turn it off

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

urlclassifier3.sqlite can delete
--
webappstore.sqlite and healthreport.sqlite could be deleted.

--
Do you have \thumbnails directory in profile? Can be many files, delete. Turn off this feature in user.js

user_pref("browser.pagethumbnails.capturing_disabled", true);
--

My profiles rarely grow as have everything turned off and use mozilla as little as possible. If you have "Don't remember history" set, places.sqlite stays
the same size.

Cal





Christer Jacobsson

unread,
May 19, 2020, 1:04:57 AM5/19/20
to
os...@wisdomtree.info wrote:
> ** Reply to note from dev-ports-...@lists.mozilla.org Sat, 16 May 2020 12:00:02 +0000
>>

As Salaam Aleikum!

>> Are there any program(s) that can sort of vacuum-clean the SQL databases which FF uses so She can shrink them down thereby freeing space on the
>> Y: volume where the Mozilla tree sits?
>
> https://hobbes.nmsu.edu/download/pub/os2/apps/database/sqlitebrowser13j.zip
> Separate tool when mozilla is not operating, functions with any sqlite file.
> --
>
> https://hobbes.nmsu.edu/download/pub/os2/apps/internet/misc/upssv-1.0rc3.zip
> For mozilla specifically
> --

That should probably be more effective than the first one listed above
as it's targeted to the Mozilla SQLITE files.
>
> There is an addon extension that does this when mozilla is running. Do not have exact name of this at the moment. Such as:
> - install the SQLite Manager Firefox Plugin
> - start it via the 'SQLite Manager' on the Tools menu in Firefox
>
> --
> SqLite command line client is supposed to have the ability to vacuum files. There are several versions at archive sites.
>
> --
> Do you have the following turned on in preferences? Exact wording may differ between versions. Turn it off
>
> 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
>
> urlclassifier3.sqlite can delete
> --
> webappstore.sqlite and healthreport.sqlite could be deleted.
>
> --
> Do you have \thumbnails directory in profile? Can be many files, delete. Turn off this feature in user.js
>
> user_pref("browser.pagethumbnails.capturing_disabled", true);
> --
>
> My profiles rarely grow as have everything turned off and use mozilla as little as possible. If you have "Don't remember history" set, places.sqlite stays
> the same size.
>

Another tack, the Warpin issue. After She have renamed & copied the
databse to another location should She do a Warpin -deinstall, and if
that won't work, just delete the files in the Warpin base dir and
reinstall Warpin-1-0-19.exe which is dated 2020-05-13. Is She can just
delete the files (not the database) in g:\os2ut\warpin and then execute
the above file after moving it to g:\os2ut\warpin. In this way, no
statements in config.sys have to be altered, and after a succesful
install. place the database with it's correct name in the Warpin dir and
then trying upgrading Her PMViewPro (which is installed by Warpin). If
that works, then it's time to install PM Backup using Warpin and trying
to 'hot up" WSeB by installing the latest AHCI, APCI, FAT32 and the SMP
code (have the CD with the Convenient Pack 2 at hand here. Would be good
to continue using WSeB on the new box, but also use eCs 2.1 and ArcaOS -
She believes in having more than one flavour of OS2 / eCs / ArcaOS so as
to be able to use the various OS'es strenght - eCs 2.1 She must have to
access SVTPlay (SVT is public service) but requires the latest ODIN and
the Flash11 plugin to see TV programs. As Flash11 is only licensed for
eCs, it won't work from WSeB or ArcaOS, only the various eCs versions.
Btw the Warpin version info is hideous - 1-0-19 is later than 1-0-22, so
why can't these who delevop Warpin use a more consistent version system
so newer versions have higher version info than earler versions? One
could get preggers for this stupid version info :-=


Cul8er alligator!
gaea - feminist & chunkawakan
--
/GAIA (Insulin User - 24th Anniversary :-) Ex-wife deceased :-(
Team OS/2 e-mail: cribo.j...@gaea.se (Primary)
Team eCs e-mail: gaian...@yahoo.com (Alternate)
Team DRW Dare Refuse Windows
Chunkawakan Lakota/Sioux: Horse

Paul Ratcliffe

unread,
May 19, 2020, 4:04:05 PM5/19/20
to
On Tue, 19 May 2020 07:05:08 +0200, Christer Jacobsson
<cribo.j...@gaea.se> wrote:

> Btw the Warpin version info is hideous - 1-0-19 is later than 1-0-22, so
> why can't these who delevop Warpin use a more consistent version system
> so newer versions have higher version info than earler versions? One
> could get preggers for this stupid version info :-=

What you say is just garbage (and not only this message).
Obviously 1-0-22 is later than 1-0-19.
Did you actually try reading the documentation?
Timestamps are meaningless and are easily changed.
But you carry on with your stupid little ways if it suits you.
Don't expect anyone with any sense to listen though.

Christer Jacobsson

unread,
May 20, 2020, 12:39:45 AM5/20/20
to
Paul Ratcliffe wrote:
> On Tue, 19 May 2020 07:05:08 +0200, Christer Jacobsson
> <cribo.j...@gaea.se> wrote:
>

As Salaam Aleikum!

>> Btw the Warpin version info is hideous - 1-0-19 is later than 1-0-22, so
>> why can't these who delevop Warpin use a more consistent version system
>> so newer versions have higher version info than earler versions? One
>> could get preggers for this stupid version info :-=
>
> What you say is just garbage (and not only this message).
> Obviously 1-0-22 is later than 1-0-19.
> Did you actually try reading the documentation?
> Timestamps are meaningless and are easily changed.
> But you carry on with your stupid little ways if it suits you.
> Don't expect anyone with any sense to listen though.

Thanks for sorting this out! Then She will use 1-0-22 to repair the
current Warpin.

Christer Jacobsson

unread,
Jun 5, 2020, 12:42:44 AM6/5/20
to
Christer Jacobsson wrote:
> os...@wisdomtree.info wrote:
>

As Salaam Aleikum!

>
>>> Are there any program(s) that can sort of vacuum-clean the SQL
>>> databases which FF uses so She can shrink them down thereby freeing
>>> space on the Y: volume where the Mozilla tree sits?
>>
>> https://hobbes.nmsu.edu/download/pub/os2/apps/database/sqlitebrowser13j.zip
>>
>> Separate tool when mozilla is not operating, functions with any
>> sqlite file.
>> --

She have downloaded the above archive and it contains two .exe files
namely sqlite3.exe and sqlitebrowser.exe. She don't to browse the two
SQLITE files namely URLCLASSES.SQLITE and PLACES.SQLITE, just vacuum
them out of excess and / or duplicate entries so the files will be
smaller. So should She use sqlite3.exe against those files and what
arguments must the program be fed with (the manes of the sqlite files
must be provided), but are there more useful arguments för the sqlite3.exe?
Is this program a "browser" or just a hoovering tool for the Moz sqlite
files? (Hoover was an old brand of vacuum cleaner, not the infamous J.
Edgar Hoover of FBI :-(
>
> That should probably be more effective than the first one listed above
> as it's targeted to the Mozilla SQLITE files.
>>
>> There is an addon extension that does this when mozilla is running.
>> Do not have exact name of this at the moment. Such as:
>> - install the SQLite Manager Firefox Plugin
>> - start it via the 'SQLite Manager' on the Tools menu in Firefox

So this tool is a part of the abovementioned package?
>>
>> --
>> SqLite command line client is supposed to have the ability to vacuum
>> files. There are several versions at archive sites.
>>
>> --
>> Do you have the following turned on in preferences? Exact wording may
>> differ between versions. Turn it off
>>
>> 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
>>
>> urlclassifier3.sqlite can delete
>> --
>> webappstore.sqlite and healthreport.sqlite could be deleted.
>>
>> --
>> Do you have \thumbnails directory in profile? Can be many files,
>> delete. Turn off this feature in user.js
>>
>> user_pref("browser.pagethumbnails.capturing_disabled", true);
>> --
>>
>> My profiles rarely grow as have everything turned off and use mozilla
>> as little as possible. If you have "Don't remember history" set,
>> places.sqlite stays
>> the same size.
>

But having history turned off or it's standard value of 7 days are quite
low for Her. So She installed a History plugin to gain more history data
- if She forgets to bookmark a particular site, it can probably be found
in the History if the time frame are bigger than the standard seven days
:-/ If the files tend to be very big, they can be cleaned out by the
program(s) mentioned above. At least they won't be monster-size in this way.
Reply all
Reply to author
Forward
0 new messages