What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?

by

PyMySQL and MySQLdb provide the same functionality – they are both database connectors. The difference is in the implementation where MySQLdb is a C extension and PyMySQL is pure Python.

There are a few reasons to try PyMySQL:

  • it might be easier to get running on some systems
  • it works with PyPy
  • it can be “greened” and works with gevent

The proper way to use it with Django is to import it and tell it to impersonate MySQLdb in your top-level file, usually manage.py. Put the following code at the very top of your manage.py (or whatever file you call when starting your server):

try:
    import pymysql
    pymysql.install_as_MySQLdb()
except ImportError:
    pass

More Related Contents:

  1. Install mysql-python (Windows)
  2. Installing specific package version with pip
  3. Database does not update automatically with MySQL and Python
  4. Mac OS X – EnvironmentError: mysql_config not found
  5. mysql-python install error: Cannot open include file ‘config-win.h’
  6. Setting Django up to use MySQL
  7. How to replace Django’s primary key with a different integer that is unique for that table
  8. How to use MySQLdb with Python and Django in OSX 10.6?
  9. When to close cursors using MySQLdb
  10. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  11. Python 3.4.0 with MySQL database
  12. How can I use executemany to insert into MySQL a list of dictionaries in Python
  13. How to run Django’s test database only in memory?
  14. ImportError: No module named MySQLdb
  15. How to filter (or replace) unicode characters that would take more than 3 bytes in UTF-8?
  16. Print the actual query MySQLdb runs?
  17. MySQL Improperly Configured Reason: unsafe use of relative path
  18. Can one use the Django database layer outside of Django?
  19. How do i cast char to integer while querying in django ORM?
  20. How to make an Inner Join in django?
  21. Dynamic SQL Queries with Python and mySQL
  22. Python MySQLDB: Get the result of fetchall in a list
  23. Simple Subquery with OuterRef
  24. How to use python mysqldb to insert many rows at once
  25. Using .aggregate() on a value introduced using .extra(select={…}) in a Django Query?
  26. django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
  27. Install mysqlclient for Django Python on Mac OS X Sierra
  28. ‘pip install MySQL-python’ fails with ‘IndexError’
  29. Django + MySQL on Mac OS 10.6.2 Snow Leopard
  30. Single Django model, multiple tables?

Leave a Comment