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

Groups > comp.lang.python > #65735

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

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.xs4all.nl!newsfeed4.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path <marcelgmr@gmail.com>
X-Original-To python-list@python.org
Delivered-To python-list@mail.python.org
X-Spam-Status OK 0.004
X-Spam-Evidence '*H*': 0.99; '*S*': 0.00; 'python,': 0.02; 'url:pypi': 0.03; 'back-end': 0.09; 'subject:module': 0.09; 'cc:addr:python-list': 0.11; 'python': 0.11; '[2].': 0.16; 'maintainable': 0.16; 'readable': 0.16; 'sqlite': 0.16; 'subject:access': 0.16; 'subject:python': 0.16; 'code.': 0.18; 'module': 0.19; 'written': 0.21; 'cc:addr:python.org': 0.22; 'install': 0.23; 'decide': 0.24; 'cc:2**0': 0.24; 'header:In- Reply-To:1': 0.27; 'installed': 0.27; 'chris': 0.29; '[1]': 0.29; '[2]': 0.30; 'compared': 0.30; 'said,': 0.30; 'message- id:@mail.gmail.com': 0.30; 'url:mailman': 0.30; 'easier': 0.31; 'probably': 0.32; 'compatible': 0.32; 'interface': 0.32; 'url:python': 0.33; 'subject:the': 0.34; 'received:google.com': 0.35; 'there': 0.35; 'library.': 0.36; 'url:listinfo': 0.36; 'subject:?': 0.36; 'url:org': 0.36; 'being': 0.38; 'url:library': 0.38; 'url:mail': 0.40; 'simple,': 0.60; 'url:3': 0.61; 'to:addr:gmail.com': 0.65; 'sam': 0.68; 'subject:SQL': 0.84; 'subject:recommended': 0.84
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:to :cc:content-type; bh=34mpCtaIqJlFt4Uz5qEL4GqbEIm2NG++GzmBLW6qSj4=; b=LgN/8Ww8NovbWlRYk7otkfKgX9ZKmP1mkpvzLaEcL2QCY43hAznskjt/b/kvZok0pf quCo9UQKyCtJF2/vT0+2iRVCXSQWHMYnmdrD/YLih5eSTEwNxsLHwCnccjleA0P1nWq5 lzoQxYmuKb1bNLfd9N2hyMd3mXCujPuKo6tJNO2MAQ9ln0Hit6BQ8MnMXKHB2zvrECtT J9sSjnLxZaC78sPwaLqr1O4O7xokk0SpPjdV76fU/X4rjt8pRuwevsR74eMkdMif6r6O nJmvrufEGbwftCuD0a7kV0O6XMzC/rtY1Z6QZFoy9FgYRjoHvt8HUm5YmP2qkpihnLQZ pClw==
MIME-Version 1.0
X-Received by 10.60.98.174 with SMTP id ej14mr21667867oeb.16.1391941247875; Sun, 09 Feb 2014 02:20:47 -0800 (PST)
In-Reply-To <d2aa22af-8771-4944-ba2a-1098f9b5a735@googlegroups.com>
References <d2aa22af-8771-4944-ba2a-1098f9b5a735@googlegroups.com>
Date Sun, 9 Feb 2014 08:20:47 -0200
Subject Re: What is the recommended python module for SQL database access?
From Marcel Rodrigues <marcelgmr@gmail.com>
To Sam <lightaiyee@gmail.com>
Content-Type multipart/alternative; boundary=089e0122912ca0c04f04f1f69346
Cc python-list <python-list@python.org>
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.6576.1391941257.18130.python-list@python.org> (permalink)
Lines 52
NNTP-Posting-Host 2001:888:2000:d::a6
X-Trace 1391941257 news.xs4all.nl 2920 [2001:888:2000:d::a6]:36219
X-Complaints-To abuse@xs4all.nl
Xref csiph.com comp.lang.python:65735

Show key headers only | View raw

[Multipart message — attachments visible in raw view] - view raw

As Chris said, if your needs are simple, use SQLite back-end. It's probably
already installed on your computer and Python has a nice interface to it in
its standard library. [1]

If you decide to use MySQL back-end instead, consider using PyMySQL [2].
It's compatible with both Python 2 and Python 3. Also, being written in
pure Python, it's easier to install compared to MySQLdb.

[1] http://docs.python.org/3/library/sqlite3.html#module-sqlite3
[2] https://pypi.python.org/pypi/PyMySQL


2014-02-08 6:55 GMT-02:00 Sam <lightaiyee@gmail.com>:

> Is MySQLdb the recommended python module for SQL database access? Are
> there other modules? What I want in a module is to be able to write
> readable and maintainable code.
> --
> https://mail.python.org/mailman/listinfo/python-list
>

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