Nope.
The SQL database is the complete download and visited histories for the computer.
Upgrades to browser version do not affect it, as it is in a different location than the installed browser file.
Local, or local low in the AppData folder.
Clear browser history does not affect it at all.
There is a bit of discussion in the developer forums about it, but not much.
i don't think this is it.
https://developer.mozilla.org/en-US/doc ... ry_service
http://sqlitebrowser.sourceforge.net/
here is the cleaner for the places sql database
PlacesCleaner extension v0.41
Prevent recently records within desire periods to be delete.
Compatible for Firefox 4.0 beta.
Installation
Open PlacesCleaner :: Add-ons for Firefox
I hate to paste this much, but don't have it bookmarked, just as saved page
there it is
http://forums.mozillazine.org/viewtopic ... 0e63fdf27
delete History traces from the Places.sqlite file
Hi,
I am a software developer and I need some information.
I want to delete History traces from the Places.sqlite file and I want to implement this in the following way:
- all tables obtained from sqlite_master, I will create them in the new database using the SQL command obtained from the sqlite_master too.
- I will proceed the same way with INDEX, and I will create them in the new database
- then I will also proceed the same way with TRIGGER, and I will create them in the new database
- after this, I will make an INSERT at each table, as below:
eg. for moz_places I will use:
INSERT INTO <New DataBase>.<Table> SELECT ALL * FROM <Table> WHERE moz_places.id IN (SELECT fk FROM moz_bookmarks)
I would like to make this because I want to copy all the entries from moz_places in moz_places from the new database, excluding those entries which are not connected to a bookmark. This way, obtaining a new database which this time does not contain the entries related with History, and the original file can be always erased beyond recovery and this way, the History will be erased without affecting any Bookmark.
The result I will obtain is identical (of course that it does not contain the entires "erased") with the original database, with the following problems:
1. The file size drops down suddenly from 150KB to 55 KB, but WHY? When doing a complete copying did not should be approx the same file size? I am doing a complete copying by creating tables, indexes, trigers and inserting the data into the tables, or I need to do something additionally?
2. The new file (the new database) is no more "compatible" with Firefox 3, what I want to explain is that when creating a new bookmark, this bookmark won't be saved in the database or at least, we see this from the Mozilla browser after the next browser restarting, it has disappeared from there.
Could this be a conflict, if yes, what kind of conflict or is there a solution so I can solve this?
What I noticed is: after opening Mozilla Firefox 3, the file modified by me in the way I described above is modified, the table moz_Bookmarks is re-ordered and new entries appear, and also some entries or data from it disappear . The same happens with the table moz_places. I don't understand WHY this table modification? What it's happening? I think that this modification affect Firefox because it it not able to work with the Bookmarks as before.
Thank you very much for all your help.
Post Posted August 6th, 2008, 5:58 am
Is there a particular reason you want to do this? It's easy enough to delete the history using the history browser or through Tools -> Clear Private Data
Second, why are you copying the database tables? It would be much simpler to do this in-place, directly in the origional database. If you want to make a backup, make a copy of the database file rather than recreating it.
Third. there re about 11 tables and numerous indexes that are all inter-related. There is more involved other than adding or removing entries from moz_places, moz_bookmarks, and moz_historyvisits. There are also things like annotations and favicons that may also need to be updated.
If you're writing a Firefox extension, I suggest trying to leverage as much existing Firefox code as possible (there is, of course, already code to add and remove bookmarks and clean up history).
There have always been ghosts in the machine... random segments of code that have grouped together to form unexpected protocols. Unanticipated, these free radicals engender questions of free will, creativity, and even the nature of what we might call the soul...
argh
Guest
Post Posted September 18th, 2008, 6:58 pm
It doesn't work in FF3. I can open places.sqlite in Emacs and see history and deleted bookmarks.