CleanerVersion adds a versioning/historizing layer to your relational DB which implements a "Slowly Changing Dimensions Type 2" behavior
Clone or download
maennel Merge pull request #154 from tbazadaykin/master
Fix documentation misprint.
Latest commit c4170c9 Apr 16, 2018
Failed to load latest commit information.
cleanerversion Bumped version number to 2.1.0 Mar 13, 2018
docs #149 Apr 1, 2018
versions Merge remote-tracking branch 'sc/master' into feature/django20-compat… Mar 13, 2018
versions_tests fixes test errors when using with custom user model Mar 27, 2018
.gitignore .gitignore updated Aug 25, 2017
.travis.yml Improved environment specs in travis config Jan 7, 2018
CONTRIBUTING.rst Updated the contribution guideline Sep 11, 2017
LICENSE Initial commit Sep 8, 2014 Update Jun 17, 2015
NOTICE remove support for 1.6 and 1.7 Sep 8, 2016
README.rst Adapted README and bumped version Jan 7, 2018 Removed django-dependency from to remove testing interference Jan 7, 2018


CleanerVersion for Django


CleanerVersion is a solution that allows you to read and write multiple versions of an entry to and from your relational database. It allows to keep track of modifications on an object over time, as described by the theory of Slowly Changing Dimensions (SCD) - Type 2.

CleanerVersion therefore enables a Django-based Datawarehouse, which was the initial idea of this package.


CleanerVersion's feature-set includes the following bullet points:

  • Simple versioning of an object (according to SCD, Type 2)
    • Retrieval of the current version of the object
    • Retrieval of an object's state at any point in time
  • Versioning of One-to-Many relationships
    • For any point in time, retrieval of correct related objects
  • Versioning of Many-to-Many relationships
    • For any point in time, retrieval of correct related objects
  • Migrations, if using in conjunction with Django 1.7 and upwards
  • Integration with Django Admin (Credits to @boydjohnson and @peterfarrell)


This code was tested with the following technical components

  • Python 2.7 & 3.6
  • Django 1.11 & 2.0
  • PostgreSQL 9.3.4 & SQLite3

Older Django versions

CleanerVersion was originally written for Django 1.6 and has now been ported up to Django 1.11.

CleanerVersion 2.x releases are compatible with Django 1.11 and 2.0. It may also work with Django 1.9 and 1.10, but note that these versions are not officially supported and test cases have been removed.

Old packages compatible with older Django releases:


Find a detailed documentation at

Feature requests

  • Querying for time ranges