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

Groups > comp.lang.python > #31307

Re: MySQL with Python

Path csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!feeds.phibee-telecom.net!feed.xsnews.nl!border-3.ams.xsnews.nl!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path <demianbrecht@gmail.com>
X-Original-To python-list@python.org
Delivered-To python-list@mail.python.org
X-Spam-Status OK 0.031
X-Spam-Evidence '*H*': 0.94; '*S*': 0.00; 'url:sourceforge': 0.03; 'subject:Python': 0.05; 'mysql,': 0.07; 'orm': 0.09; 'url:github': 0.09; 'suggest': 0.11; 'url:)': 0.13; 'sqlalchemy': 0.16; 'wrote:': 0.17; 'are:': 0.20; 'to:2**1': 0.23; 'allows': 0.25; 'header:In-Reply-To:1': 0.25; 'header:User-Agent:1': 0.26; 'am,': 0.27; 'skip:@ 10': 0.27; 'this?': 0.28; 'received:209.85.160.46': 0.32; 'to:no real name:2**1': 0.32; 'to:addr:python-list': 0.33; 'another': 0.33; 'received:google.com': 0.34; 'received:209.85': 0.35; 'there': 0.35; 'message-id:@gmail.com': 0.36; 'url:org': 0.36; 'subject:with': 0.36; 'two': 0.37; 'received:209': 0.37; 'subject:: ': 0.38; 'to:addr:python.org': 0.39; 'header:Received:5': 0.40; 'your': 0.60; 'different': 0.63; 'more': 0.63; 'kindly': 0.67; '8bit%:100': 0.70; 'skip:\xe0 10': 0.84; 'skip:\xe0 30': 0.84; 'url:sqlalchemy': 0.84; 'abstracts': 0.91
DKIM-Signature v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; bh=VKjc3ncEECZg3Y8qSG/KPhhPhIX4KRW0QW2PCNlEJPI=; b=bZlgs2lGX7PWjfLb107/MjdedvZQ2ILNXUFToodfgAaWt1jd6c/nZlno86E6rOsLJZ llsqXpNL4YFCIMth633ZR42H/n9qNQJ8fi7sbBi31pCAx0QbyWDpai6yJXABKmEEIlWE SvmCsdiqTD0rg4M8Sipv04TiGR9NTNW4ne+mdLjoWY32M0gwOy83ZymKKyImXXquTFXW 8mIhQYJ0dpbnvOjcEHJaOnCArsr7TsykdxiMV9hmBbeCMpKlJuTNI9qdsTvJ61c2VRXN 0kaYQcfAhQ4fXO3ldUDRr47CYpS1Bg4WAOE7X03bM/JCLzbUb9m2uWAs5ZZe4WB7iFse GlSQ==
Date Mon, 15 Oct 2012 07:05:12 -0700
From Demian Brecht <demianbrecht@gmail.com>
User-Agent Mozilla/5.0 (X11; Linux x86_64; rv:15.0) Gecko/20120912 Thunderbird/15.0.1
MIME-Version 1.0
To python-list@python.org, bnrj.rudra@gmail.com
Subject Re: MySQL with Python
References <1350308732.2373.8.camel@roddur>
In-Reply-To <1350308732.2373.8.camel@roddur>
Content-Type text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding 8bit
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.2209.1350309918.27098.python-list@python.org> (permalink)
Lines 17
NNTP-Posting-Host 2001:888:2000:d::a6
X-Trace 1350309918 news.xs4all.nl 6852 [2001:888:2000:d::a6]:33780
X-Complaints-To abuse@xs4all.nl
Xref csiph.com comp.lang.python:31307

Show key headers only | View raw

On 12-10-15 06:45 AM, রুদ্র ব্যাণার্জী wrote:
> if yes, can you kindly suggest a book/reference on this?
>

There are a few different ways to connect to MySQL, two of which are:

For reference on connecting and querying MySQL through mysql-python, 
take a read through http://mysql-python.sourceforge.net/MySQLdb.html.

Another solution is to use SQLAlchemy (http://www.sqlalchemy.org/). The 
ORM abstracts a lot of the tedious SQL queries out for you and allows 
you to concentrate more on your application's logic.

-- 
Demian Brecht
@demianbrecht
http://demianbrecht.github.com

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

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