Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!bcyclone01.am1.xlned.com!bcyclone01.am1.xlned.com!newsfeed.xs4all.nl!newsfeed1.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path: <python.list@tim.thechases.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.025
X-Spam-Evidence: '*H*': 0.95; '*S*': 0.00; "subject:' ": 0.07; '-tkc': 0.16; 'from:addr:python.list': 0.16; 'from:addr:tim.thechases.com': 0.16; 'from:name:tim chase': 0.16; 'shares.': 0.16; 'sqlite': 0.16; 'subject:dates': 0.16; 'subject:sqlite3': 0.16; 'wrote:': 0.18; "aren't": 0.24; 'simpler': 0.24; 'typical': 0.24; 'paul': 0.24; "i've": 0.25; 'nearly': 0.26; 'header:In-Reply-To:1': 0.27; "doesn't": 0.30; 'compared': 0.30; 'needed.': 0.30; 'said,': 0.30; 'too.': 0.31; 'libraries': 0.31; 'overhead': 0.31; 'stuff': 0.32; 'subject: (': 0.35; 'transaction': 0.35; 'add': 0.35; 'charset:us-ascii': 0.36; 'wrong': 0.37; 'received:10': 0.37; 'to:addr:python-list': 0.38; 'embedded': 0.39; 'to:addr:python.org': 0.39; 'even': 0.60; 'skip:u 10': 0.60; 'relations': 0.60; 'browser': 0.61; 'locked': 0.84
X-Sender-Id: wwwh|x-authuser|tim@thechases.com
X-Sender-Id: wwwh|x-authuser|tim@thechases.com
X-MC-Relay: Neutral
X-MailChannels-SenderId: wwwh|x-authuser|tim@thechases.com
X-MailChannels-Auth-Id: wwwh
X-MC-Loop-Signature: 1424467824232:1028521526
X-MC-Ingress-Time: 1424467824232
Date: Fri, 20 Feb 2015 15:31:58 -0600
From: Tim Chase <python.list@tim.thechases.com>
To: python-list@python.org
Subject: Re: 'Lite' Databases (Re: sqlite3 and dates)
In-Reply-To: <87a908e0zh.fsf@jester.gateway.pace.com>
References: <mc1atd$cq0$1@ger.gmane.org> <mailman.18805.1424243139.18130.python-list@python.org> <mc1s1e$feh$1@news.albasani.net> <mailman.18815.1424258499.18130.python-list@python.org> <4154cc37-0bb0-4bf2-a52c-b728c737357c@googlegroups.com> <CAPTjJmogRj_==1wUcLooFwDhUK+saSaAkQEuUo4o30n8aRdB=w@mail.gmail.com> <54E517B4.4000409@stoneleaf.us> <mc37el$ci7$1@ger.gmane.org> <mailman.18844.1424304273.18130.python-list@python.org> <87a908e0zh.fsf@jester.gateway.pace.com>
X-Mailer: Claws Mail 3.8.1 (GTK+ 2.24.10; x86_64-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-AuthUser: tim@thechases.com
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.18945.1424491885.18130.python-list@python.org>
Lines: 19
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1424491885 news.xs4all.nl 2853 [2001:888:2000:d::a6]:59063
X-Complaints-To: abuse@xs4all.nl
X-Received-Bytes: 3949
X-Received-Body-CRC: 3240400964
Xref: csiph.com comp.lang.python:86011

On 2015-02-20 13:17, Paul Rubin wrote:
> For stuff like browser bookmarks or other typical embedded database
> purposes, I don't see why SQL or relations are needed.  Berkeley DB
> is a transactional key-value store that's been around for decades
> and is way simpler than SQLite, and there's other things like that
> too.

Well, for Steven's purposes, both fail ungracefully on network
shares.  From my understanding, BDB fails even harder (whereas the
sqlite doesn't so much fail as keep a locked write transaction locked
if it fails at the wrong time, so you have to force an unlock)

And all said, sqlite doesn't add that much overhead compared to the
many other libraries I've used that aren't nearly so well-tested.

-tkc