python-noob - which container is appropriate for later exporting into mySql + matplotlib ?

[Cousin Stanley]

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