django-pgtrigger

What it is and what it does

django-pgtrigger is a Django integration layer for PostgreSQL triggers. It lets you declare triggers as Python objects in your model's Meta class—such as Protect, ReadOnly, SoftDelete, or FSM—and have them automatically created and managed through Django migrations. Instead of writing raw SQL or relying on Django signals and application logic, you define what should happen at the database level when rows are inserted, updated, or deleted, with optional conditions based on old and new row values.

The package handles the translation from Python trigger definitions to SQL, manages migrations, and provides utilities like pgtrigger.Q and pgtrigger.F to express row conditions without raw SQL. It supports Python 3.10–3.14 and Django 4.2–6.0, and requires PostgreSQL as the database backend. Most use cases avoid custom SQL entirely, though the package allows it for complex scenarios.

Use it for

• Prevent deletion of active records or enforce soft-delete behavior at the database level.
• Make specific model fields or entire models read-only after creation without application-layer checks.
• Enforce state transitions (e.g., workflow statuses) so invalid transitions are rejected by the database.
• Automatically update search vectors or denormalized columns whenever source data changes.
• Ensure official interfaces are used (e.g., force User.objects.create_user over User.objects.create).
• Track or snapshot model changes for audit logs or versioning without signal handlers.

Worth the install?

AI-flagged interpretation of the facts on this page. Verify before relying on it.

Install

django-pgtrigger on PyPI

Before you install

Low friction: pure Python wheel with only django as a runtime dependency. Maintenance status is aging—last release 253 days ago—but the repository remains active with recent commits and no archived status.

Requires PostgreSQL as the database backend; django-pgtrigger does not work with other database engines.

License in practice

BSD-3-Clause is permissive; you may use, modify, and distribute this package freely in commercial and private projects with minimal restrictions.

Quickstart

pip install django-pgtrigger

# Add 'pgtrigger' to settings.INSTALLED_APPS

import pgtrigger
from django.db import models

class ProtectedModel(models.Model):
    class Meta:
        triggers = [
            pgtrigger.Protect(name="protect_deletes", operation=pgtrigger.Delete)
        ]

# Run: python manage.py makemigrations && python manage.py migrate

Package facts

Evidence: django_pgtrigger-4.17.0-py3-none-any.whl

Tags

More Database packages

See also django-pghistory · django-read-only · django-postgres-extra · django-pgviews-redux · alembic_utils · django-postgres-copy · django-pgmigrate · django-soft-delete · django-pg-migration-tools · django-fsm-log