Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!ecngs!feeder2.ecngs.de!newsfeed.freenet.ag!news2.euro.net!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.026
X-Spam-Evidence: '*H*': 0.95; '*S*': 0.00; 'mysql,': 0.07; 'postgresql': 0.07; 'sized': 0.07; 'subject: + ': 0.07; 'subject:into': 0.09; 'from:addr:rosuav': 0.16; 'from:name:chris angelico': 0.16; 'subject: \n ': 0.16; 'subject:which': 0.16; 'subject:python': 0.16; 'subject: ?': 0.16; 'wrote:': 0.18; 'bit': 0.19; 'header:In-Reply-To:1': 0.27; 'am,': 0.29; 'message- id:@mail.gmail.com': 0.30; 'assumes': 0.31; 'time;': 0.31; 'stuff': 0.32; 'maybe': 0.34; "i'd": 0.34; 'problem': 0.35; 'received:209.85': 0.35; 'received:209.85.220': 0.35; 'received:google.com': 0.35; '14,': 0.36; 'data,': 0.36; "i'll": 0.36; 'should': 0.36; 'application': 0.37; 'received:209': 0.37; 'loss': 0.38; 'to:addr:python-list': 0.38; 'to:addr:python.org': 0.39; 'more': 0.64; 'therefore': 0.72; 'money': 0.72; 'heavy': 0.81; 'experiment': 0.84; 'trustworthy': 0.91; '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=atxCs/VQKMr0Io1AzUzAPxuclx3l2fBsKlM1NLTKsDI=; b=VzQaAzKzMxNFNhxebEabE+1gkvCD9lKgcYUIgX0oCdU06SCysfZ+vvRPchyO5ouWzC PtFB0J956MGhyuxxFpdDddOClD7SZGL/hzKrzjGaDHfn7YooKfsZsYl1RDoU/TpkfC4g MW+OqU74pAgthbYNU12FYMNEaEwbS61wrTQnkeM4TF71hYep7hIF1AvtLlKvwEUkTwWr sjjkuAqGLSYQ5LYXzke9tw7BzG+n0bh8oviuGlZQ4SbEed69GtNFjMWHUAbioinqDENe pkO8QlGHgyysj5ZWbOwEN4osVSQosyuvtm9gaButVdSLaYHdwjjEOIvJdHOItFpNJCjZ gakw==
MIME-Version: 1.0
X-Received: by 10.52.231.231 with SMTP id tj7mr2659108vdc.111.1365892491777; Sat, 13 Apr 2013 15:34:51 -0700 (PDT)
In-Reply-To: <kkcbra$t45$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> <kkbrnh$n8h$1@news.albasani.net> <kkcbra$t45$1@dont-email.me>
Date: Sun, 14 Apr 2013 08:34:51 +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.577.1365892495.3114.python-list@python.org>
Lines: 16
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1365892495 news.xs4all.nl 2608 [2001:888:2000:d::a6]:60335
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:43551

On Sun, Apr 14, 2013 at 5:34 AM, someone <newsboost@gmail.com> wrote:
> I think maybe I'll experiment a bit with both mySql (small/medium sized
> databases) and for critical/important stuff I should go with PostgreSQL

PostgreSQL isn't majorly slower than MySQL, and it's a lot more
trustworthy in terms of database constraints and so on. MySQL is
designed as a place for a single application to store its data, and it
assumes that the application is king; PostgreSQL is designed as a
database against which application(s) may execute queries, therefore
it assumes that the database administrator is king.

With heavy read/write workloads, I'd put my money on PostgreSQL every
time; MySQL has a much greater problem with wide locks (eg
table-level) and consequent loss of concurrency.

ChrisA