Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #65870

Re: What is the recommended python module for SQL database access?

Path csiph.com!usenet.pasdenom.info!gegeweb.org!usenet-fr.net!nerim.net!novso.com!newsfeed.xs4all.nl!newsfeed2a.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.016
X-Spam-Evidence '*H*': 0.97; '*S*': 0.00; '(at': 0.04; 'licenses': 0.04; 'explicitly': 0.05; 'postgresql': 0.07; 'image,': 0.09; 'occasionally': 0.09; 'subject:module': 0.09; 'cc:addr:python- list': 0.11; 'assume': 0.14; 'windows': 0.15; 'clone': 0.16; 'concurrency': 0.16; 'database).': 0.16; 'db2,': 0.16; 'from:addr:rosuav': 0.16; 'from:name:chris angelico': 0.16; 'illegal,': 0.16; 'it;': 0.16; 'query,': 0.16; 'subject:access': 0.16; 'terms).': 0.16; 'using,': 0.16; 'subject:python': 0.16; '(you': 0.16; 'wrote:': 0.18; 'looked': 0.18; 'app': 0.19; 'commit': 0.19; 'feb': 0.22; 'cc:addr:python.org': 0.22; 'install': 0.23; 'closely': 0.24; 'convenient': 0.24; 'integrate': 0.24; 'issue,': 0.24; '(or': 0.24; 'cc:2**0': 0.24; "i've": 0.25; 'mention': 0.26; 'nearly': 0.26; 'header:In-Reply-To:1': 0.27; 'chris': 0.29; 'database,': 0.30; 'message-id:@mail.gmail.com': 0.30; "i'm": 0.30; '(which': 0.31; 'that.': 0.31; 'too.': 0.31; 'bunch': 0.31; 'factor': 0.31; 'once,': 0.31; 'option.': 0.31; 'os,': 0.31; 'servers.': 0.31; 'this.': 0.32; 'probably': 0.32; 'stuff': 0.32; 'option': 0.32; 'another': 0.32; 'linux': 0.33; 'subject:the': 0.34; "can't": 0.35; 'agree': 0.35; 'transaction': 0.35; 'test': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'add': 0.35; 'there': 0.35; 'really': 0.36; 'oracle': 0.36; 'doing': 0.36; 'next': 0.36; 'fees': 0.36; 'subject:?': 0.36; 'operating': 0.37; 'machines': 0.38; 'product.': 0.38; 'pm,': 0.38; 'anything': 0.39; 'bad': 0.39; 'how': 0.40; 'even': 0.60; 'easy': 0.60; 'simply': 0.61; "you're": 0.61; 'back': 0.62; 'times': 0.62; "you've": 0.63; 'myself': 0.63; 'our': 0.64; 'networking': 0.64; 'different': 0.65; 'license': 0.66; 'fact,': 0.69; '100%': 0.77; '1990s,': 0.84; 'dba': 0.84; 'desired?': 0.84; 'etc,': 0.84; "life's": 0.84; 'subject:SQL': 0.84; 'subject:recommended': 0.84; 'absolutely': 0.87; 'boxes': 0.91; 'thoroughly': 0.91; 'transactions': 0.91; 'to:none': 0.92; 'taught': 0.96
DKIM-Signature v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:cc :content-type; bh=5z+T+MdPutCaGO8cGSpGaKNPgjxNHopyjygNAbob/y4=; b=Kr4a+bjAeOwduRqvMxRrE7MGJDeTk7Iia1TzqQCujKDRmgfL8o/hNJuogUdpBaK1Na Qa5bQ6KpyEUJ2rLPv0PM7SSNra6FayvA/nD6fTaodBHB9JlqT2OqYQUMNINS0AqGgGCj UqmYkR6gSCJN0Hv4JHpaRpxz+Y12OvrTq6T/KS5iRST21lyt7FeAV5UZOt1JZhM9BPaw +gporGUmxPiY8MhqzYXOfke9jX3qSs9NKqBeuYIcVZHW7AOm6oG7NmvDLaD+aUHbKd13 dsuFtKEd2plvI5b1f9ekcWX4jvSamkYhGu6C815kEbWQ0jilGQGqXw5ygbl2+dHXi25W CXcw==
MIME-Version 1.0
X-Received by 10.66.118.71 with SMTP id kk7mr29579783pab.14.1392088733354; Mon, 10 Feb 2014 19:18:53 -0800 (PST)
In-Reply-To <ldc3iq$d5u$1@news.albasani.net>
References <d2aa22af-8771-4944-ba2a-1098f9b5a735@googlegroups.com> <CAFEv2m5BOdZ3PzdVfQTw-K9xJ=oWiLi5ZOUFHAkimdndDshBnQ@mail.gmail.com> <mailman.6579.1391943667.18130.python-list@python.org> <ldc3iq$d5u$1@news.albasani.net>
Date Tue, 11 Feb 2014 14:18:53 +1100
Subject Re: What is the recommended python module for SQL database access?
From Chris Angelico <rosuav@gmail.com>
Cc "python-list@python.org" <python-list@python.org>
Content-Type text/plain; charset=UTF-8
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.6645.1392088743.18130.python-list@python.org> (permalink)
Lines 40
NNTP-Posting-Host 2001:888:2000:d::a6
X-Trace 1392088743 news.xs4all.nl 2886 [2001:888:2000:d::a6]:56660
X-Complaints-To abuse@xs4all.nl
Xref csiph.com comp.lang.python:65870

Show key headers only | View raw

On Tue, Feb 11, 2014 at 1:57 PM, Walter Hurry <walterhurry@gmail.com> wrote:
> Chris Angelico wrote:
>
>> Broad recommendation: Single application, tiny workload, concurrency
>> not an issue, simplicity desired? Go SQLite. Big complex job, need
>> performance, lots of things reading and writing at once, want
>> networked access? Go PGSQL. And don't go MySQL if PG is an option.
>>
>> And definitely don't go for a non-free option (MS-SQL, DB2, etc)
>> unless you've looked into it really closely and you are absolutely
>> thoroughly *sure* that you need that system (which probably means you
>> need your app to integrate with someone else's, and that other app
>> demands one particular database).
>>
> I agree 100% with this. And speaking as an ex Oracle and DB2 DBA - not to mention MS-SQL (spit), with which I occasionally had to dabble, avoid them like the plague unless circumstances dictate.
>

I can't speak for Oracle as I've never used it, but DB2 is not at all
a bad product. In fact, it's excellent. I'm not sorry to have spent a
couple of decades using it; it's part of what taught me to assume
transactions everywhere, for instance (you don't "BEGIN TRANSACTION",
you simply are in one - after you COMMIT, another transaction is
automatically opened (at next query, I think), so you have to
explicitly COMMIT everything), and its networking support is
excellent. (Also, back in the 1990s, PostgreSQL wasn't nearly as easy
to use as it is now.)

But it's non-free, and that makes a HUGE difference when you start
deploying servers. You have to count up how many boxes you're using,
and then factor in the number of test machines you have too. Licenses
for your OS, database, etc, etc, all add up pretty quickly. When there
are no license fees whatsoever, life's easy - I can create myself a
Debian Linux VM image, install all our stuff on it, and then clone it
a whole bunch of times to try different things; doing that with
Windows or DB2 or anything pay-for is a lot less convenient (or even
straight-up illegal, depending on the license terms). That's a pretty
huge downside, and I've yet to use any pay-for database engine or
operating system that outdoes that.

ChrisA

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

What is the recommended python module for SQL database access? Sam <lightaiyee@gmail.com> - 2014-02-08 00:55 -0800
  Re: What is the recommended python module for SQL database access? Chris Angelico <rosuav@gmail.com> - 2014-02-08 20:04 +1100
  Re: What is the recommended python module for SQL database access? Marcel Rodrigues <marcelgmr@gmail.com> - 2014-02-09 08:20 -0200
  Re: What is the recommended python module for SQL database access? Chris Angelico <rosuav@gmail.com> - 2014-02-09 22:00 +1100
    Re: What is the recommended python module for SQL database access? Asaf Las <roegltd@gmail.com> - 2014-02-09 04:47 -0800
      Re: What is the recommended python module for SQL database access? Chris Angelico <rosuav@gmail.com> - 2014-02-10 00:14 +1100
        Re: What is the recommended python module for SQL database access? Asaf Las <roegltd@gmail.com> - 2014-02-09 05:27 -0800
          Re: What is the recommended python module for SQL database access? Chris Angelico <rosuav@gmail.com> - 2014-02-10 00:36 +1100
    Re: What is the recommended python module for SQL database access? Walter Hurry <walterhurry@gmail.com> - 2014-02-11 02:57 +0000
      Re: What is the recommended python module for SQL database access? Asaf Las <roegltd@gmail.com> - 2014-02-10 19:02 -0800
        Re: What is the recommended python module for SQL database access? Chris Angelico <rosuav@gmail.com> - 2014-02-11 14:31 +1100
          Re: What is the recommended python module for SQL database access? Asaf Las <roegltd@gmail.com> - 2014-02-10 19:45 -0800
      Re: What is the recommended python module for SQL database access? Chris Angelico <rosuav@gmail.com> - 2014-02-11 14:18 +1100
  Re: What is the recommended python module for SQL database access? Marcel Rodrigues <marcelgmr@gmail.com> - 2014-02-09 10:04 -0200
  Re: What is the recommended python module for SQL database access? Chris Angelico <rosuav@gmail.com> - 2014-02-09 23:13 +1100
  Re: What is the recommended python module for SQL database access? Tim Chase <python.list@tim.thechases.com> - 2014-02-09 08:31 -0600
  Re: What is the recommended python module for SQL database access? Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2014-02-09 10:40 -0500
  Re: What is the recommended python module for SQL database access? Chris Angelico <rosuav@gmail.com> - 2014-02-10 09:03 +1100
  Re: What is the recommended python module for SQL database access? Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2014-02-09 19:27 -0500

csiph-web