Path: csiph.com!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!newsfeed.eweka.nl!eweka.nl!feeder3.eweka.nl!newsfeed.xs4all.nl!newsfeed5.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path: <python-python-list@m.gmane.org>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.006
X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'python,': 0.02; 'url:sourceforge': 0.03; 'subject:Python': 0.05; 'python': 0.09; 'covered.': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'suggest': 0.11; 'language': 0.14; 'library': 0.15; 'dec': 0.15; 'adapter': 0.16; 'database).': 0.16; 'introduces': 0.16; 'not;': 0.16; 'oct': 0.16; 'packt': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'mon,': 0.16; 'basically': 0.17; 'admin': 0.18; 'mostly': 0.20; 'project,': 0.24; '(which': 0.26; 'creating': 0.26; 'separate': 0.27; 'header:X-Complaints-To:1': 0.28; 'this?': 0.28; 'went': 0.28; '(used': 0.29; '+0100,': 0.29; 'perl': 0.29; 'routine': 0.29; 'unified': 0.29; 'probably': 0.29; 'books': 0.30; 'expect': 0.31; 'server.': 0.32; 'generally': 0.32; 'explains': 0.33; 'limitations': 0.33; 'url:home': 0.33; 'to:addr :python-list': 0.33; 'that,': 0.34; 'project': 0.34; 'self': 0.34; 'server': 0.35; 'along': 0.35; 'friends,': 0.35; 'received:org': 0.36; 'created': 0.36; 'but': 0.36; '2005': 0.36; 'anything': 0.36; 'subject:with': 0.36; 'charset:us-ascii': 0.36; 'itself': 0.37; 'does': 0.37; 'rather': 0.37; 'subject:: ': 0.38; 'some': 0.38; 'to:addr:python.org': 0.39; 'application': 0.40; 'skip:" 10': 0.40; 'header:Received:5': 0.40; 'skip:u 10': 0.60; 'first': 0.61; 'dedicated': 0.61; 'free': 0.61; '(that': 0.62; 'close': 0.63; 'skip:n 10': 0.63; 'managing': 0.64; 'dear': 0.66; 'kindly': 0.67; 'account': 0.67; 'now:': 0.71; 'institute': 0.72; '2002': 0.78; 'introduce': 0.80; 'definitive': 0.84; 'off,': 0.84; 'edition': 0.86; 'dennis': 0.91
X-Injected-Via-Gmane: http://gmane.org/
To: python-list@python.org
From: Dennis Lee Bieber <wlfraed@ix.netcom.com>
Subject: Re: MySQL with Python
Date: Mon, 15 Oct 2012 15:20:47 -0400
Organization: > Bestiaria Support Staff <
References: <1350308732.2373.8.camel@roddur>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Gmane-NNTP-Posting-Host: adsl-76-249-21-26.dsl.klmzmi.sbcglobal.net
X-Newsreader: Forte Agent 3.3/32.846
X-No-Archive: YES
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.2233.1350328857.27098.python-list@python.org>
Lines: 54
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1350328857 news.xs4all.nl 6861 [2001:888:2000:d::a6]:49520
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:31336

On Mon, 15 Oct 2012 14:45:32 +0100, ????? ??????????
<bnrj.rudra@gmail.com> declaimed the following in
gmane.comp.python.general:

> 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?

	First off, how much "managing" do you expect to perform? For
actually managing the MySQL server you're probably better off
downloading the dedicated application (Used to be "MySQL Admin" and a
separate "MySQL QueryBrowser" -- the current download is a unified
"MySQL Workbench").

	For routine database /access/ (that is, someone has created the
database user account that will be used), MySQLdb is the Python adapter
to connect to the server. For using THAT, you basically need to know SQL
(MySQL's flavor in particular), along with understanding the DB-API 2
specification (PEP-249) with the MySQLdb documentation (which explains
any limitations or specifics; see http://mysql-python.sourceforge.net/ )

	For books, though some are rather old by now:

MySQL for Python 
(Albert Lukaszewski; 2010 Packt Publishing)

The Definitive Guide to MySQL 5 3rd Ed 
(Michael Kofler; 2005 Apress)[no Python chapter, but does introduce the
now-discontinued Admin and QueryBrowser applications, and introduces the
features of MySQL v5

Managing & Using MySQL 2nd Ed (Reese/Yarger/King; 2002 O'Reilly)[has 5
pages on MySQL with Python]

	And a new edition NOT YET RELEASED -- don't know if this edition
includes anything on Python, the 3rd edition does not; but the volume is
huge and may be close to covering what the old MySQL AB "Administrators
Guide" and "Language Reference" books covered.

MySQL 5th Ed
(Paul DuBois; Dec 2012 Addison-Wesley [Developer's Library])
-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
        wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/