Python 3 and MySQL_ZenDei技術網路在線

Python 3 and MySQL

-Advertisement-

http://stackoverflow.com/questions/4960048/python-3-and-mysql http://stackoverflow.com/questions/4960048/python-3-and-mysql up vote61down votefavorite ...

http://stackoverflow.com/questions/4960048/python-3-and-mysql

up vote61down vote favorite 20

I am using ActiveState Python 3 on Windows and wanted to connect to my MySQL database. I heard that mysqldb was the module to use. I can't find mysqldb for Python 3.

Is there a repository available where the binaries exist for mysqldb? How can I connect to MySQL in Python 3 on Windows?

shareimprove this question

edited Oct 30 '14 at 17:29

Martin Thoma 13.7k14111226

asked Feb 10 '11 at 16:47

panofish 1,85122345

Thanks to casevh for the link to the unofficial binaries, but I was too impatient and it appears that the masses are still using python2 ... so I installed python 2.7 and installed MySQLdb from codegood.com/archives/129 – panofish Feb 10 '11 at 18:27

possible duplicate of MySQL-db lib for Python 3.0 ? – itsadok Mar 13 '11 at 9:43

add a comment

11 Answers

active oldest votes

up vote85down voteaccepted

There are currently a few options for using Python 3 with mysql:

https://pypi.python.org/pypi/mysql-connector-python

Officially supported by Oracle
Pure python
A little slow
Not compatible with MySQLdb

https://pypi.python.org/pypi/pymysql

Pure python
Faster than mysql-connector
Almost completely compatible with MySQLdb, after calling pymysql.install_as_MySQLdb()

https://github.com/nakagami/CyMySQL

fork of pymysql with optional C speedups

https://pypi.python.org/pypi/mysqlclient

Django's recommended library.
Friendly fork of the original MySQLdb, hopes to merge back some day
The fastest implementation, as it is C based.
The most compatible with MySQLdb, as it is a fork

benchmarks here: https://github.com/methane/mysql-driver-benchmarks

您的分享是我們最大的動力!

-Advertisement-

更多相關文章

Storm 運行例子

1.建立Java工程使用idea，添加lib庫，拷貝storm中lib到工程中 2.拷貝wordcount代碼下載src包，解壓找到 apache-storm-0.9.4-src\apache-storm-0.9.4\examples\storm-starter\src\jvm\storm\st ...
MySQL實現兩張表數據的同步

有兩張表A和B，要求往A裡面插入一條記錄的同時要向B裡面也插入一條記錄，向B裡面插入一條記錄的同時也向A插入一條記錄。兩張表的結構不同，需要將其中幾個欄位對應起來。可以用下麵的觸發器實現。表A的觸發器：表B的觸發器： ...
淺析MySQL二進位日誌

查看MySQL二進位文件中的內容有兩種方式 1. mysqlbinlog 2. SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] 下麵來測試一下，在mysql中執行如下操作對應二進位日誌中的內容如下 ...
從MySQL 5.5遷移到Mariadb 10.1.14

從MySQL 5.5遷移到Mariadb 10.1.14 遷移計劃如下： 1.備份MySQL 5.5的資料庫，對指定庫進行備份。 2.還原到Mariadb，然後建立複製。 3.然後就可以願意啥時候切換就啥時候切換。遇到的問題：因為一般都是innodb，所以我想用xtrabackup工具備份。備份 ...
NoSql之MongoDB--Windows下資料庫配置及初步使用

1.NoSql簡介 NoSql（Not Only Sql）指的是非關係型的資料庫。下一代資料庫主要解決幾個要點：非關係型的、分散式的、開源的、水平可擴展的。原始的目的是為了大規模web應用，這場運動開始於2009年初，通常特性應用如：模式自由、支持簡易複製、簡單的API、最終的一致性（非ACID） ...
How to return dictionary keys as a list in Python 3.3

http://btmiller.com/2015/04/13/get-list-of-keys-from-dictionary-in-python-2-and-3.html Get a List of Keys From a Dictionary in Both Python 2 and Pytho ...
SQL Server SQL分頁查詢的幾種方式介紹

SQL Server分頁查詢幾種方式介紹 0. 序言 1. TOP…NOT IN… 2. ROW_NUMBER() 3. OFFSET…FETCH 4. 執行計劃 5. 補充 ...
Get a List of Keys From a Dictionary in Both Python 2 and Python 3

http://askubuntu.com/questions/656610/trying-to-install-mysql-connector-for-python-3?rq=1 trying to install mysql-connector for python 3 trying to ins ...