On Fri, Jan 7, 2022 at 12:07 AM Istvan Gabor <suseuser04@gmail.hu> wrote:
Thu, 6 Jan 2022 21:54:42 +0100 időpontban Carlos E. R. írta:
On 06/01/2022 21.51, Istvan Gabor wrote:
Thu, 6 Jan 2022 11:13:44 -0500 időpontban Bob Rogers írta:
From: Istvan Gabor <suseuser04@gmail.hu> Date: Thu, 06 Jan 2022 12:23:47 +0100
Hello:
Currently I use firefox 91.4.1esr in openSUSE 15.3.
I noticed that in the profile directory the size of some sqlite database files does not change after deleting history. Namely, places.sqlite, favicons.sqlite, cookies.sqlite files' size remains the same after deleting history.
Why don't the file sizes decrease after deleting their content by deleting history?
From the SQLite docs [1]:
When content is deleted from an SQLite database, the content is not usually erased but rather the space used to hold the content is marked as being available for reuse. Does this mean that the sqlite file still contains the data which has been deleted from history? That is, someone who has access to the file can read history data, despite is has been deleted?
There is an menu or tool in Firefox to refresh profile. Be sure to read the caveats.
Sorry, but this info is vague. My problem is that when I delete history I expect that the history data is erased, and cannot be read anymore (by accessing the database file; not including hard disk forensic data recovery). If the data still can be read directly from the database after deleting history it is a privacy/ security issue.
Then you asked the wrong question. Even if Firefox overwrites deleted data with zeros or some random pattern the file itself will certainly not shrink. If you have these concerns you will need to a) verify that deleted content is still accessible and b) make this question/request where it belongs - Firefox bugzilla, not some random list.