django-sqlite-strict

django-sqlite-strict is a drop-in replacement for Django's stock SQLite engine that enforces STRICT tables.

Prerequisites

django-sqlite-strict works on Django webapps that use:

• Django >= 4.2
• SQLite >= 3.37.0

Install

1. Add as a dependency:

   uv add django-sqlite-strict
   

2. In settings.py, add to INSTALLED_APPS after any first-party apps and before django.contrib packages.

   INSTALLED_APPS = [
       ...,
       'django_sqlite_strict',
       ...,
   ]
   

3. In settings.py, configure DATABASES to use it as the engine:

   DATABASES = {
       "default": {
           "ENGINE": "django_sqlite_strict",
           "NAME": BASE_DIR / "db.sqlite3",
       }
   }
   

Features

Compared to Django's stock SQLite backend

SQLite STRICT tables only permit the storage classes INTEGER, REAL, TEXT, BLOB and ANY (source).
To generate valid STRICT tables, django-sqlite-strict maps field types differently to Django's stock SQLite backend. For example:

• CharField is stored as TEXT instead of VARCHAR
• BooleanField as INTEGER instead of BOOL
• DecimalField as REAL instead of DECIMAL

These changes affect only the SQL column types used in migrations, Django's Python field API remains unchanged.

[!WARNING] Because of the above STRICT-compliant field type mappings, DecimalField is stored as REAL.
Applications requiring exact decimal arithmetic should consider storing integer minor units or using a database with native DECIMAL support.

System checks

django-sqlite-strict will register the following Django system checks:

• check_column_types
  Raises an error if any entry in the DATABASES setting has a column of a type that is not accepted by STRICT tables.
• check_decimal_max_digits
  Raises a warning if a DecimalField has max_digits set to a value higher than the '15 significant digits' threshold up to which SQLite's REAL stores decimals.

Management commands

• convert_to_strict
  Rebuilds existing non-STRICT tables as STRICT ones. Pass --dry-run to preview the effect of this command, and --no-input for use in CI pipelines.

Develop

Development prerequisites

The following tools must be available locally to develop django-sqlite-strict:

• uv
• prek

Run tests

The project aims for 100% test coverage. nox is used to run the test suite against all supported Python/Django pairings (see noxfile.py).

# run latest supported Python/Django pairing only
# (eg. Python 3.14 / Django 6.1)
uvx nox

# run all test sessions
# (ie. all supported Python/Django pairings)
uvx nox -s test

Use the development version in projects

Build the package as a binary distribution (wheel) and install it in a Django project:

# in django-sqlite-strict's root directory
uv build

# in the target Django webapp project
uv add ~/Projects/django-sqlite-strict/dist/django_sqlite_strict-M.m.p-py3-none-any.whl

Acknowledgements

This package was inspired by Martin Dørum's advocacy for STRICT tables in the article SQLite should have (Rust-style) editions.

Shameless self-promotion

Starting a new Django project? Try djereo for a Django project template with modern defaults.

Try pycliché for a no-nonsense Python project template with opinionated tooling.

19th century apparatus to enforce STRICT columns (source, Eton College)