django-mysql 0.1.6

Extensions to Django for use with MySQL/MariaDB

The dolphin-pony - proof that cute + cute = double cute.

Django-MySQL is a non-inventively named package that helps you use some MySQL/MariaDB-specific features in the world of Django.

What kind of features?

Here’s a short list of what’s inside:

• QuerySet extensions - ‘smart’ iteration, approx_count for quick estimates of count(), quick pt-visual-explain of the underlying query

• Handler - quicker reads using MySQL’s built-in NoSQL API

• Status variable inspection and utility methods

• User locks - use MySQL as a locking server between your servers

To see them all, check out the exposition at http://django-mysql.readthedocs.org/en/latest/exposition.html .

Requirements

Tested with:

• Python: 2.7, 3.3, 3.4

• Django: 1.7, 1.8 RC

• MySQL: 5.5, 5.6 / MariaDB: 5.5, 10.0, 10.1

• mysqlclient: 1.3.5 (Python 3 compatible version of MySQL-python)

Any combination of these should be good, and also MySQL-python should work since it’s just an older version of mysqlclient.

History

0.1.7 (pending)

• Renamed connection_name argument to db on Lock, GlobalStatus, and SessionStatus classes, for more consistency with Django.

0.1.6 (2015-03-21)

• Added support for HANDLER statements as a QuerySet extension

• Now tested on Django 1.8

• Add pk_range argument for ‘smart iteration’ code

0.1.5 (2015-03-11)

• Added manage.py command dbparams for outputting database paramters in formats useful for shell scripts

0.1.4 (2015-03-10)

• Fix release process

0.1.3 (2015-03-08)

• Added pt_visual_explain integration on QuerySet

• Added soundex-based field lookups for the ORM

0.1.2 (2015-03-01)

• Added get_many to GlobalStatus

• Added wait_until_load_low to GlobalStatus which allows you to wait for any high load on your database server to dissipate.

• Added smart iteration classes and methods for QuerySets that allow efficient iteration over very large sets of objects slice-by-slice.

0.1.1 (2015-02-23)

• Added Model and QuerySet subclasses which add the approx_count method

0.1.0 (2015-02-12)

• First release on PyPI

• Locks

• GlobalStatus and SessionStatus