Fixes a bug occurring when caching a SQL query using a non-ascii table name.
Added:
- Adds an invalidate_cachalot command to invalidate django-cachalot from a script without having to clear the whole cache
- Adds the benchmark introduction, conditions & results to the documentation
- Adds a short guide on how to configure Redis as a LRU cache
Fixed:
Fixes a rare invalidation issue occurring when updating a many-to-many table after executing a queryset generating a
HAVING
SQL statement – for example,User.objects.first().user_permissions.add(Permission.objects.first())
was not invalidatingUser.objects.annotate(n=Count('user_permissions')).filter(n__gte=1)
Fixes an even rarer invalidation issue occurring when updating a many-to-many table after executing a queryset filtering nested subqueries by another subquery through that many-to-many table – for example:
User.objects.filter( pk__in=User.objects.filter( pk__in=User.objects.filter( user_permissions__in=Permission.objects.all())))
Avoids setting useless cache keys by using table names instead of Django-generated table alias
Added:
- Caches all queries implying
Queryset.extra
- Invalidates raw queries
- Adds a simple API containing:
invalidate_tables
,invalidate_models
,invalidate_all
- Adds file-based cache support for Django 1.7
- Adds a setting to choose if random queries must be cached
- Adds 2 settings to customize how cache keys are generated
- Adds a django-debug-toolbar panel
- Adds a benchmark
Fixed:
- Rewrites invalidation for a better speed & memory performance
- Fixes a stale cache issue occurring when an invalidation is done exactly during a SQL request on the invalidated table(s)
- Fixes a stale cache issue occurring after concurrent transactions
- Uses an infinite timeout
Removed:
- Simplifies
cachalot_settings
and forbids its use or modification
- Fixes an issue with pip if Django is not yet installed
- Adds multi-database support
- Adds invalidation when altering the DB schema using migrate, syncdb, flush, loaddata commands (also invalidates South, if you use it)
- Small optimizations & simplifications
- Adds several tests
- Adds thread-safety
- Optimizes the amount of cache queries during transaction
- Adds memcached support
- Adds
CACHALOT_ENABLED
&CACHALOT_CACHE
settings - Allows settings to be dynamically overridden using
cachalot_settings
- Adds some missing tests
- Fixes
pip install
.
- Adds Travis CI and adds compatibility for:
- Django 1.6 & 1.7
- Python 2.6, 2.7, 3.2, 3.3, & 3.4
- locmem & Redis
- SQLite, PostgreSQL, MySQL
- Handles transactions
- Adds lots of tests for complex cases
- Adds a test suite
- Fixes invalidation for data creation/deletion
- Stops caching on queries defining
select
orwhere
arguments withQuerySet.extra
Prototype simply caching all SQL queries reading the database and trying to invalidate them when SQL queries modify the database.
Has issues invalidating deletions and creations.
Also caches QuerySet.extra
queries but can’t reliably invalidate them.
No transaction support, no test, no multi-database support, etc.