Re: MySQL with Python

Path	csiph.com!usenet.pasdenom.info!news.albasani.net!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.011
X-Spam-Evidence	'H': 0.98; 'S': 0.00; '16,': 0.03; 'subject:Python': 0.05; 'linux,': 0.05; 'mysql,': 0.07; 'postgresql': 0.07; 'python': 0.09; 'suggest': 0.11; 'language': 0.14; 'library': 0.15; 'options.': 0.15; 'database).': 0.16; 'from:addr:rosuav': 0.16; 'from:name:chris angelico': 0.16; 'oct': 0.16; 'supported:': 0.16; 'wrote:': 0.17; 'instance,': 0.17; 'url:moin': 0.17; 'module': 0.19; 'mostly': 0.20; 'project,': 0.24; 'header:In-Reply-To:1': 0.25; 'creating': 0.26; 'url:wiki': 0.26; 'am,': 0.27; 'possibly': 0.27; 'instead.': 0.27; 'module.': 0.27; 'message-id:@mail.gmail.com': 0.27; 'this?': 0.28; 'went': 0.28; 'perl': 0.29; 'surprised': 0.29; "i'm": 0.29; 'install': 0.29; 'books': 0.30; 'url:python': 0.32; 'generally': 0.32; 'support,': 0.32; 'running': 0.32; 'to:addr:python-list': 0.33; 'that,': 0.34; 'received:google.com': 0.34; 'project': 0.34; 'self': 0.34; 'friends,': 0.35; 'received:209.85': 0.35; 'there': 0.35; 'but': 0.36; 'url:org': 0.36; 'subject:with': 0.36; 'itself': 0.37; 'quite': 0.37; 'received:209': 0.37; 'far': 0.37; 'subject:: ': 0.38; 'possible.': 0.38; 'several': 0.39; 'to:addr:python.org': 0.39; 'header:Received:5': 0.40; 'first': 0.61; 'free': 0.61; "you'll": 0.62; 'managing': 0.64; 'dear': 0.66; 'kindly': 0.67; '8bit%:100': 0.70; 'wish': 0.70; 'institute': 0.72; 'actually,': 0.84; 'add-on': 0.84; 'skip:\xe0 10': 0.84; 'skip:\xe0 30': 0.84; '"apt-get': 0.91; 'on?': 0.91
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 :content-type:content-transfer-encoding; bh=+kE9dzZIf3zJAlqTIyOFHpKG18jFb+6CsMY3YvKWQWM=; b=yiHE5hYZUMD2jLyXlS6eN0X6HCjpQ+MehrCbvEFMqyqvEokOpZxGoptyvVE7liRqEL +mpyVT4cVNMbZGlacIvJerYkB1slj4syh4VZDVlSArKGtZZnM418DHjJp83+LpWHx9FJ 61ehxg0SLIgEqvF9ODm7yfu8tfa3DdO9T4N6j9FCFDHM1c7KnQqtP+QOmeGW9+0eqBI/ hfMFpiULAZPMZkLS2N087F/Ovxh1YucGGArgTAdQ/2oIc2ur9i5gZJjKk5McGbDWWEPj 5PlvLDtcns8kCNY1pR6QfCb3izxo9zhVw7n4GAtkKFERQNw7cxOvZDVT/Vo4BBLdsry8 JpTQ==
MIME-Version	1.0
In-Reply-To	<1350308732.2373.8.camel@roddur>
References	<1350308732.2373.8.camel@roddur>
Date	Tue, 16 Oct 2012 01:01:58 +1100
Subject	Re: MySQL with Python
From	Chris Angelico <rosuav@gmail.com>
To	python-list@python.org
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	quoted-printable
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.2207.1350309721.27098.python-list@python.org> (permalink)
Lines	32
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1350309721 news.xs4all.nl 6961 [2001:888:2000:d::a6]:58911
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:31305

Show key headers only | View raw

On Tue, Oct 16, 2012 at 12:45 AM, রুদ্র ব্যাণার্জী <bnrj.rudra@gmail.com> wrote:
> Dear friends,
> I am starting a project of creating a database using mySQL(my first
> project with database).
> I went to my institute library and find that, all books are managing
> "mySQL with perl and php"
>
> I am new to python itself and gradually loving it. I mostly use it as an
> alternative of shell-script. Since learning a new language for every new
> project is not possible(its self assigned project, generally in free
> time), can I do a "mySQL with python?"
>
> if yes, can you kindly suggest a book/reference on this?

It's definitely possible. As far as I know, though, there's no inbuilt
support, so you'll need an add-on module. What platform are you
running on? On Debian Linux, for instance, you can simply "apt-get
install python-mysqldb".

But you may wish to consider using PostgreSQL instead. It's a
generally better database engine than MySQL, and is equally well
supported:

http://wiki.python.org/moin/PostgreSQL

Actually, to be quite honest, I'm surprised there's no module in the
Python stdlib for either of the above. Possibly because there are
several competing options.

ChrisA

Thread

MySQL with Python রুদ্র ব্যাণার্জী  <bnrj.rudra@gmail.com> - 2012-10-15 14:45 +0100
  Re: MySQL with Python Chris Angelico <rosuav@gmail.com> - 2012-10-16 01:01 +1100
    Re: MySQL with Python রুদ্র ব্যাণার্জী  <bnrj.rudra@gmail.com> - 2012-10-15 15:47 +0100
      Re: MySQL with Python Chris Angelico <rosuav@gmail.com> - 2012-10-16 01:54 +1100
  Re: MySQL with Python Demian Brecht <demianbrecht@gmail.com> - 2012-10-15 07:05 -0700
  Re: MySQL with Python Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2012-10-15 15:20 -0400
    Re: MySQL with Python Roy Smith <roy@panix.com> - 2012-10-15 15:44 -0400

csiph-web