Steven D'Aprano wrote: > On Fri, 12 Apr 2013 23:26:05 +0000, Cousin Stanley wrote: > >> The firefox browser keeps different sqlite database files for various >> uses .... > > Yes, and I *really* wish they wouldn't. > > It's my number 1 cause of major problems with Firefox.
Problems with software of any flavor, especially software that is used regularly and upon which we are somewhat dependent, are always a source of frustration .... My own personal use of firefox over the years has been limited as I have not used it for my primary browser and have not experienced any problems with its bookmarks .... I use opera as my primary browser and would very much like to convert the plain-vanilla bookmark.adr file that opera uses into an sqlite data base for diversity in bookmark searches that would be independent of reglular browser usage .... $ grep FOLDER ~/.opera/bookmarks.adr | wc -l 631 $ grep URL ~/.opera/bookmarks.adr | wc -l 14944 > http://kb.mozillazine.org/Bookmarks_history_and_toolbar_buttons_not_working_-_Firefox Although there have been many reports entailing corruption of the places.sqlite file, it isn't apparent to me from the link above that sqlite itself is the culprit .... Could the complexity/bugginess of the firefox code possibly be the cause instead ? "If Firefox works normally when you first open it after starting up the computer but multiple symptoms arise after you close and later reopen Firefox, it's likely that a Firefox process from a previous session did not close properly and the Places database ( "places.sqlite" file ) is locked." If you check the headers of any of my posts here you will find that I post with a python-based news client named XPN that also uses sqlite for persistent storage, one sqlite database for each different newsgroup .... I've used xpn daily for many years and have never experienced a corrupted sqlite database file .... firefox + sqlite ----> buggy ? ....... :-( python + sqlite ----> ok, hooray .... :-) > Using a database for such lightweight data as bookmarks is, in my > opinion, gross overkill and adds to the complexity of Firefox. > > More complexity leads to more bugs, e.g.: > > https://bugzilla.mozilla.org/show_bug.cgi?id=465684#c11 > > https://bugzilla.mozilla.org/show_bug.cgi?id=431558 These pages show problems that are 4 and 5 years old from 2008 & 2009 and are marked as Status: RESOLVED FIXED at the top of the page .... Are you still having firefox bookmark problems today ? -- Stanley C. Kitching Human Being Phoenix, Arizona -- http://mail.python.org/mailman/listinfo/python-list