Django-MySQL

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

Django-MySQL extends Django's built-in MySQL and MariaDB support their specific features not available on other databases.

What kind of features?

Includes:

• QuerySet extensions:
  • 'Smart' iteration - chunked pagination across a large queryset
  • approx_count for quick estimates of count()
  • Query hints
  • Quick pt-visual-explain of the underlying query
• Model fields:
  • MySQL 5.7+ JSON Field
  • MariaDB Dynamic Columns for storing dictionaries
  • Comma-separated fields for storing lists and sets
  • 'Missing' fields: differently sized BinaryField/TextField classes, BooleanFields represented by BIT(1)
• ORM expressions for over 20 MySQL-specific functions
• A new cache backend that makes use of MySQL's upsert statement and does compression
• Handler API for quicker-than-SQL reads using the 'NoSQL' HANDLER commands
• Status variable inspection and utility methods
• Named locks for easy locking of e.g. external resources
• Table lock manager for hard to pull off data migrations

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

Requirements and Installation

Please see https://django-mysql.readthedocs.io/en/latest/installation.html .

Documentation

Every detail documented on Read The Docs.