Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path: <rosuav@gmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.038
X-Spam-Evidence: '*H*': 0.92; '*S*': 0.00; 'subject: + ': 0.07; 'chime': 0.09; 'postgresql.': 0.09; 'subject:into': 0.09; 'all...': 0.16; 'an,': 0.16; 'concur': 0.16; 'for,': 0.16; 'from:addr:rosuav': 0.16; 'from:name:chris angelico': 0.16; 'hits': 0.16; 'levels,': 0.16; 'massively': 0.16; 'permissive': 0.16; 'query;': 0.16; 'sqlite': 0.16; 'subject: \n ': 0.16; 'subject:which': 0.16; 'subject:python': 0.16; 'subject: ?': 0.16; 'wrote:': 0.18; 'commit': 0.19; 'fairly': 0.24; "i've": 0.25; 'source': 0.25; 'pass': 0.26; 'header:In-Reply-To:1': 0.27; 'chris': 0.29; 'am,': 0.29; "doesn't": 0.30; 'returned': 0.30; 'message-id:@mail.gmail.com': 0.30; "i'm": 0.30; '(although': 0.31; 'agreed.': 0.31; 'bunch': 0.31; 'supposed': 0.32; 'run': 0.32; 'another': 0.32; 'says': 0.33; 'maybe': 0.34; 'basic': 0.35; 'something': 0.35; 'hundreds': 0.35; 'test': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'google': 0.35; '14,': 0.36; 'in.': 0.36; 'oracle': 0.36; 'two': 0.37; 'level': 0.37; 'configured': 0.38; 'easiest': 0.38; 'handle': 0.38; 'to:addr:python-list': 0.38; 'pm,': 0.38; 'previous': 0.38; 'rather': 0.38; 'anything': 0.39; 'expensive': 0.39; 'heard': 0.39; 'sure': 0.39; 'to:addr:python.org': 0.39; 'easy': 0.60; 'free': 0.61; 'simple': 0.61; 'guarantee': 0.63; 'telling': 0.64; '(that': 0.65; 'here': 0.66; 'side': 0.67; 'compliant': 0.68; 'sound': 0.68; 'overall': 0.69; 'money': 0.72; 'other.': 0.75; 'power': 0.76; 'leak.': 0.84; 'rich,': 0.84; 'trusted,': 0.84; '2013': 0.98
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=OM81nsEQOqIDClswDGlIbC6wU5DW7cnxLRtbm6XBxQc=; b=rbbYeJcegI+374Hk3+3yOMlToOdSUa5YvAnqyvnP5PiqBrDJvgTyX/i+cTnyWRpEnv JVVVDDrF9FgdEdda0megyEIbK0hZHjGxFB8X/jfoYQ3KT+pdXP2llDxstVhkeNuK2vHl Yf6pjlP6ALRTvLpIKhWaz+Ru4V9YBToBHZFT8m3vDwFcEWtAdr9izIRhIYGAtwhNzQdl u7fgmEUaKZctta/5dCYa+R1mqxo2GzU76UFNMKd6PLAhixp6kaQbOO2Kt3htl95Ipw8G jOKGNNdF67JVgbEEtv/sTmpnWk+1EY8c64ucbbRFRp3BaKPHUTTLyhybpYjTXDE0+q4x 6wIQ==
MIME-Version: 1.0
X-Received: by 10.52.97.8 with SMTP id dw8mr2577224vdb.91.1365869755556; Sat, 13 Apr 2013 09:15:55 -0700 (PDT)
In-Reply-To: <kkbqhd$29r$1@dont-email.me>
References: <kk4nkd$ain$1@dont-email.me> <kk6tk2$inl$1@dont-email.me> <kk9433$l9s$1@dont-email.me> <kk9ef7$9ll$1@dont-email.me> <kk9s22$i7n$1@dont-email.me> <kka56d$beu$1@dont-email.me> <5168b87f$0$29977$c3e8da3$5496439d@news.astraweb.com> <kkbe5r$isk$1@dont-email.me> <mailman.550.1365853145.3114.python-list@python.org> <kkbmfq$7ed$1@dont-email.me> <mailman.551.1365861813.3114.python-list@python.org> <kkbqhd$29r$1@dont-email.me>
Date: Sun, 14 Apr 2013 02:15:55 +1000
Subject: Re: python-noob - which container is appropriate for later exporting into mySql + matplotlib ?
From: Chris Angelico <rosuav@gmail.com>
To: python-list@python.org
Content-Type: text/plain; charset=ISO-8859-1
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: <http://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: <http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.555.1365869763.3114.python-list@python.org>
Lines: 38
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1365869763 news.xs4all.nl 2643 [2001:888:2000:d::a6]:49962
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:43521

On Sun, Apr 14, 2013 at 12:39 AM, someone <newsboost@gmail.com> wrote:
> On 04/13/2013 04:03 PM, Chris Angelico wrote:
>> Failure at any level means the overall system is not ACID compliant.
>
> Roger... But google says sqlite is supposed to be ACID compliant (although
> maybe not "fully" as you indicate, I'm not sure about this)...

What your Google hits are telling you is that sqlite can (if
configured correctly) pass level 2. But it doesn't guarantee anything
about the other levels, so it's easy to have an, uhh, ACID leak.

>> You'd have to actually test it. The easiest way is to get two
>> computers, side by side, and run the database engine on one and a
>> monitor on the other.
>
> Ok, that doesn't sound to be so simple after all...

I gave a fairly wordy run-down of what I tested, but it's actually
fairly simple in concept: Do a huge bunch of transactions, and keep a
log of what's returned from the COMMIT query; then pull the power out.

> Ok, it would be nice to hear/read the opinion from another in here who've
> been working (a lot?) with sqlite...

Agreed. I'm sure someone will chime in.

> I'm not so rich, so I prefer to go for a free database solution rather than
> an expensive license... I've heard good things about oracle and that's also
> what they used at my previous company, but it's not something I am willing
> to pay for, from my private/own money for my sparetime-projects...

I concur with Walter's assessment: You want PostgreSQL. It's free/open
source software (highly permissive MIT-like license), massively
trusted, and scales up beautifully. (That last one may not be
significant to you, but it's still good to know your database can
handle hundreds or thousands of tps on basic hardware.)

ChrisA