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


Groups > comp.lang.python > #73533 > unrolled thread

What is the state of MySQL support for Python 3?

Started byhaizaar@gmail.com
First post2014-06-24 01:21 -0700
Last post2014-06-27 14:04 +0200
Articles 6 — 5 participants

Back to article view | Back to comp.lang.python


Contents

  What is the state of MySQL support for Python 3? haizaar@gmail.com - 2014-06-24 01:21 -0700
    Re: What is the state of MySQL support for Python 3? Bernd Nawothnig <Bernd.Nawothnig@t-online.de> - 2014-06-24 11:43 +0200
    Re: What is the state of MySQL support for Python 3? Chris Angelico <rosuav@gmail.com> - 2014-06-24 19:48 +1000
      Re: What is the state of MySQL support for Python 3? haizaar@gmail.com - 2014-06-24 03:41 -0700
    Re: What is the state of MySQL support for Python 3? INADA Naoki <songofacandy@gmail.com> - 2014-06-24 22:13 +0900
    Re: What is the state of MySQL support for Python 3? Egon Frerich <egon@frerich.eu> - 2014-06-27 14:04 +0200

#73533 — What is the state of MySQL support for Python 3?

Fromhaizaar@gmail.com
Date2014-06-24 01:21 -0700
SubjectWhat is the state of MySQL support for Python 3?
Message-ID<6805ae6c-b3da-4ed7-94b5-e0dc370c545a@googlegroups.com>
Good day,

I'm starting a new project from scratch so I think its finally a time to switch to the latest and greatest Python 3.4.

But I'm puzzled with MySQL support for Python 3. So far the only stable library I've found it pymysql.

All others are either abandoned work-in-progress projects or do not support Python 3:
  * mysqldb - Python 2.x only
  * mysql-ctypes - Python 2.x only
  * amysql - Python 2.x only
  * ultramysql - Python 2.x only
  * MySQL Connector/Python - new guy in block. Does anyone use it?
  * WebScaleSQL + MySQLdb1 [1] - still in development, state unknown?
  * etc...

So what library do you use for MySQL access in Python 3?
I'm specifically interested in async support (like in psycopg2 for PostgreSQL) since I'm planning to use Tornado.

Thanks,
Zaar

[1] https://github.com/farcepest/MySQLdb1 
    https://code.facebook.com/posts/1474977139392436/webscalesql-a-collaboration-to-build-upon-the-mysql-upstream/
    http://www.percona.com/live/mysql-conference-2014/sessions/asynchronous-mysql-how-facebook-queries-databases

[toc] | [next] | [standalone]


#73535

FromBernd Nawothnig <Bernd.Nawothnig@t-online.de>
Date2014-06-24 11:43 +0200
Message-ID<rrtn7b-t2f.ln1@bernd.nawothnig.dialin.t-online.de>
In reply to#73533
On 2014-06-24, haizaar@gmail.com wrote:
> I'm starting a new project from scratch so I think its finally a time
> to switch to the latest and greatest Python 3.4.
>
> But I'm puzzled with MySQL support for Python 3. So far the only
> stable library I've found it pymysql.
>
> All others are either abandoned work-in-progress projects or do not
> support Python 3:
>   * mysqldb - Python 2.x only
>   * mysql-ctypes - Python 2.x only
>   * amysql - Python 2.x only
>   * ultramysql - Python 2.x only
>   * MySQL Connector/Python - new guy in block. Does anyone use it?

Yes. It comes directly from MySQL and is written in pure Python. For
that it may not be the fastest solution but it works.

Tested with Python 3.2




Bernd

-- 
no time toulouse

[toc] | [prev] | [next] | [standalone]


#73536

FromChris Angelico <rosuav@gmail.com>
Date2014-06-24 19:48 +1000
Message-ID<mailman.11212.1403603303.18130.python-list@python.org>
In reply to#73533
On Tue, Jun 24, 2014 at 6:21 PM,  <haizaar@gmail.com> wrote:
> I'm starting a new project from scratch so I think its finally a time to switch to the latest and greatest Python 3.4.
>
> But I'm puzzled with MySQL support for Python 3.

Is it completely from scratch? Can you just use PostgreSQL? It's *so*
much better...

Sorry, I can't advise on MySQL bindings. Haven't used any of the
modules in three parts of forever.

ChrisA

[toc] | [prev] | [next] | [standalone]


#73539

Fromhaizaar@gmail.com
Date2014-06-24 03:41 -0700
Message-ID<eab1e1af-5b38-4f89-994b-2e44e2507181@googlegroups.com>
In reply to#73536
On Tuesday, June 24, 2014 12:48:14 PM UTC+3, Chris Angelico wrote:
> 
> Is it completely from scratch? Can you just use PostgreSQL? It's *so*
> 
> much better...
The project is, but the database isn't. So MySQL it is.

[toc] | [prev] | [next] | [standalone]


#73544

FromINADA Naoki <songofacandy@gmail.com>
Date2014-06-24 22:13 +0900
Message-ID<mailman.11217.1403615798.18130.python-list@python.org>
In reply to#73533
Hi.

PyMySQL -- pure Python MySQL connector. Supports Python 3.3~.
mysqlclient -- Fork of MySQLdb. Supports Python 3.3~.

On Tue, Jun 24, 2014 at 5:21 PM,  <haizaar@gmail.com> wrote:
> Good day,
>
> I'm starting a new project from scratch so I think its finally a time to switch to the latest and greatest Python 3.4.
>
> But I'm puzzled with MySQL support for Python 3. So far the only stable library I've found it pymysql.
>
> All others are either abandoned work-in-progress projects or do not support Python 3:
>   * mysqldb - Python 2.x only
>   * mysql-ctypes - Python 2.x only
>   * amysql - Python 2.x only
>   * ultramysql - Python 2.x only
>   * MySQL Connector/Python - new guy in block. Does anyone use it?
>   * WebScaleSQL + MySQLdb1 [1] - still in development, state unknown?
>   * etc...
>
> So what library do you use for MySQL access in Python 3?
> I'm specifically interested in async support (like in psycopg2 for PostgreSQL) since I'm planning to use Tornado.
>
> Thanks,
> Zaar
>
> [1] https://github.com/farcepest/MySQLdb1
>     https://code.facebook.com/posts/1474977139392436/webscalesql-a-collaboration-to-build-upon-the-mysql-upstream/
>     http://www.percona.com/live/mysql-conference-2014/sessions/asynchronous-mysql-how-facebook-queries-databases
>
> --
> https://mail.python.org/mailman/listinfo/python-list



-- 
INADA Naoki  <songofacandy@gmail.com>

[toc] | [prev] | [next] | [standalone]


#73655

FromEgon Frerich <egon@frerich.eu>
Date2014-06-27 14:04 +0200
Message-ID<mailman.11281.1403871162.18130.python-list@python.org>
In reply to#73533

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

Am 24.06.2014 10:21, schrieb haizaar@gmail.com:
> Good day,
> 
> I'm starting a new project from scratch so I think its finally a time to switch to the latest and greatest Python 3.4.
> 
> But I'm puzzled with MySQL support for Python 3. So far the only stable library I've found it pymysql.
> 
> All others are either abandoned work-in-progress projects or do not support Python 3:
>   * mysqldb - Python 2.x only
>   * mysql-ctypes - Python 2.x only
>   * amysql - Python 2.x only
>   * ultramysql - Python 2.x only
>   * MySQL Connector/Python - new guy in block. Does anyone use it?
>   * WebScaleSQL + MySQLdb1 [1] - still in development, state unknown?
>   * etc...
> 
> So what library do you use for MySQL access in Python 3?
> I'm specifically interested in async support (like in psycopg2 for PostgreSQL) since I'm planning to use Tornado.
> 
> Thanks,
> Zaar
> 
> [1] https://github.com/farcepest/MySQLdb1 
>     https://code.facebook.com/posts/1474977139392436/webscalesql-a-collaboration-to-build-upon-the-mysql-upstream/
>     http://www.percona.com/live/mysql-conference-2014/sessions/asynchronous-mysql-how-facebook-queries-databases
> 

I have installed:

Metadata-Version: 1.1
Name: MySQL-python
Version: 1.2.3
Summary: Python interface to MySQL
Home-page: http://sourceforge.net/projects/mysql-python
Author: Andy Dustman
Author-email: adustman@users.sourceforge.net
License: GPL
Download-URL:
http://osdn.dl.sourceforge.net/sourceforge/mysql-python/MySQL-python-1.2.3.tar.gz

E.

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.python


csiph-web