Path: csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed3a.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.007
X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'subject:not': 0.03; 'url:pypi': 0.03; 'api.': 0.05; 'linux,': 0.07; 'similar,': 0.09; 'subject:Why': 0.09; 'subject:module': 0.09; 'windows,': 0.09; 'cc:addr:python-list': 0.11; 'python': 0.11; 'from:addr:rosuav': 0.16; 'from:name:chris angelico': 0.16; 'sat,': 0.16; 'wrote:': 0.18; 'module': 0.19; 'first.': 0.19; 'seems': 0.21; 'feb': 0.22; 'cc:addr:python.org': 0.22; 'url:dev': 0.24; 'url:moin': 0.24; 'fine': 0.24; 'cc:2**0': 0.24; 'header:In-Reply-To:1': 0.27; 'tried': 0.27; 'message-id:@mail.gmail.com': 0.30; 'url:wiki': 0.31; 'bunch': 0.31; 'know.': 0.32; 'url:python': 0.33; 'core': 0.34; 'maybe': 0.34; "i'd": 0.34; 'test': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'there': 0.35; '2.6': 0.36; 'oracle': 0.36; 'subject:?': 0.36; 'url:org': 0.36; 'las': 0.37; 'issue': 0.38; 'pm,': 0.38; 'anything': 0.39; 'use.': 0.39; 'either': 0.39; 'most': 0.60; 'till': 0.61; 'url:5': 0.61; 'matter': 0.61; 'simple': 0.61; 'first': 0.61; "you'll": 0.62; 'url:index': 0.63; 'choose': 0.64; 'obvious': 0.74; 'find.': 0.84; 'favour': 0.91; 'to:none': 0.92
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=agZICF0Mt0YMLcioPwYPXaQ3yBW5p3RFUqVKEaofxN0=; b=SzvAB2bExZqjDUCGyuPfkSij1On7NrmytNaGb3yw+wE/GtB7CYVVv6Tmiw0eKd3v/0 NnF7zTrSKs1T7Q6gQhEB8G0VQEUIWGwELAs1R21GkujJckHmLqdQC+FNQiDuFr3U0Gb+ uOD3b6j/ZA3rBo6Tqynd83OFqxSgOjbEWYTp2f4tTWf9OwbEYQUjEC9e3nxLNboKEFI2 79cpno6vvc0raSeOXa+uUUYflr6ICZQNrL5xDQDmTmqqV3zpL2BvzOlwdLvsEhi0+KiA N2VyZxgcHsEjZl9KEEvMuqNdtJSuT4uqlUdpAwP2eEZMXoTvHfzrGnmXz8/UepmjM1PE lqGw==
MIME-Version: 1.0
X-Received: by 10.68.162.66 with SMTP id xy2mr25640800pbb.46.1391858715506; Sat, 08 Feb 2014 03:25:15 -0800 (PST)
In-Reply-To: <429f41e0-7fe8-4792-82f2-e438917a3add@googlegroups.com>
References: <f3632548-db57-4357-8d01-03807861d851@googlegroups.com> <429f41e0-7fe8-4792-82f2-e438917a3add@googlegroups.com>
Date: Sat, 8 Feb 2014 22:25:15 +1100
Subject: Re: Why use _mysql module and not use MySQLdb directly?
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.6536.1391858718.18130.python-list@python.org>
Lines: 28
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1391858718 news.xs4all.nl 2932 [2001:888:2000:d::a6]:53625
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:65669

On Sat, Feb 8, 2014 at 10:09 PM, Asaf Las <roegltd@gmail.com> wrote:
> I used this one from Oracle and it was OK for simple test case and
> supports from 2.6 till 3.3:
> http://dev.mysql.com/doc/connector-python/en/index.html
> https://pypi.python.org/pypi/mysql-connector-python/1.1.5
>
>
> yet there is page to bunch of others but i have never tried them:
> https://wiki.python.org/moin/MySQL
>
> Are there hidden issues about Oracle provided connector?

I don't know. The first thing I'd look for is compatibility with the
Python Database API. I flipped through the docs without finding
anything obvious either direction; it seems to be similar, at least,
but it's not declaring that it complies, which I would have thought
would be an important boast.

Also check for platform availability. If one package is available on
Linux, Mac, Windows, and myriad others, and the other is available on
only a few platforms, that's a mark in favour of the first. But I
suspect that won't be an issue with most of what you'll find.

My suspicion, without any proof, is that it's going to come down to a
matter of taste, or maybe some tangential features. The core will most
likely work just fine with pretty much any module you choose to use.

ChrisA