[PREV - HOME_BASE]    [TOP]

HOME_BASE_TECHNOTES

                                             April   11, 2010
                                             October 18, 2013


I like the discussion in this bug report.  Someone is trying to
make the case for being able to use any locally installed database,
but this sounds like crazy bloat to the people who want to solve
the immediate problem:

  https://bugzilla.mozilla.org/show_bug.cgi?id=241438#c0



Someone (sorry, I forget who) was arguing that Firefox must
not've switched to sqlite yet, or else I wouldn't have ever
seen performance problems with a gazillion bookmarks.
Apparently this is an issue related to the way firefox has
been using sqlite 3 so that it does a full fsync if there's
some sort of crash (what firefox, crash?):

  http://shaver.off.net/diary/2008/05/25/fsyncers-and-curveballs/

                                        This fsync problem sounds
                                        like an example of someone
                                        starting out thinking they
                                        need something "simple", and
                                        then getting tripped up when
                                        they find they need to
                                        gradually add ACID features.


This guy, by the way, reminds that flat-text
files scale a lot further than people give them
credit for:

  http://aplawrence.com/Opinion/textvsbinary.html
  http://aplawrence.com/Web/firefox-sqlite.html

There's more than just speed to consider though:
there's data integrity, and possibly concurrency.




--------
[NEXT - FLY_DOWN]