django-pgviews-redux

What it is and what it does

django-pgviews-redux is a Django extension that brings PostgreSQL views into the ORM as first-class model-like objects. Instead of writing raw SQL or using database triggers outside Django, you define views by subclassing `pg.View`, specify the underlying SQL, and manage them through Django migrations just like regular models. The package handles view creation, updates, and deletion automatically during migrations, and provides a `sync_pgviews` management command for manual synchronization.

It supports both regular views and materialized views (which cache results for faster queries). Materialized views can be refreshed manually or via signals, and on PostgreSQL 9.4+ can use concurrent refresh to avoid blocking reads. The package also handles view dependencies, ensuring dependent views are created in the correct order, and provides utilities to drop and recreate views when upstream table columns change—a common migration pain point.

Use it for

• Create read-only aggregated or filtered views of your data that behave like queryable Django models without duplicating data.
• Build materialized views to cache expensive query results and refresh them on demand or via signals when source data changes.
• Manage complex SQL views alongside your Django models in migrations, keeping schema definitions in Python code.
• Handle PostgreSQL-specific view dependencies and concurrent refresh patterns without writing raw migration operations.
• Query views using the Django ORM (filtering, ordering, pagination) just like regular models, without raw SQL in application code.

Worth the install?

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

Install

django-pgviews-redux on PyPI

Before you install

Low install friction with a single runtime dependency on django. Active maintenance with recent commits (2026-08-10) and support for modern Python versions (3.10–3.14) and Django versions (5.2, 6.0).

Requires PostgreSQL as the database backend; views are PostgreSQL-specific and cannot be used with other database engines.

License in practice

License status is unclear; the package has no SPDX identifier or raw license declaration in its metadata. Verify the actual license terms in the repository before adopting.

Quickstart

pip install django-pgviews-redux

# In settings.py, add 'django_pgviews' to INSTALLED_APPS

from django_pgviews import view as pg
from django.db import models

class PreferredCustomer(pg.View):
    name = models.CharField(max_length=100)
    sql = "SELECT id, name FROM myapp_customer WHERE is_preferred IS TRUE"
    class Meta:
        managed = False

# Then run: python manage.py migrate

Package facts

Evidence: django_pgviews_redux-1.2.0-py3-none-any.whl

Tags

More Database packages

See also dj-materialized-views · sqlalchemy-views · django-postgres-extra · django-multitenant · alembic_utils · schemainspect · django-pg-migration-tools · django-pgtrigger · django-pg-zero-downtime-migrations · django-add-default-value