MilanPecov/dj_materialized_views

Django Admin tool to create, drop and periodically refresh materialized views in PostgreSQL

Django Materialized Views

Overview

Django Materialized Views is a powerful admin app that allows you to manage materialized views from the admin panel

The app can:

• Create, update and delete materialized views
• Create indexes for the materialized views
• Refresh the materialized views at regular intervals

Limitation:

• Works only with PostgreSQL

Requirements

• Python 3.6+
• Django 2, 3 or 4
• Celery

Installation

Install using pip

pip install dj_materialized_views 

Add 'django_celery_beat' and 'dj_materialized_views' to your INSTALLED_APPS setting

INSTALLED_APPS = [
    ...
    'django_celery_beat',
    'dj_materialized_views',
]

Start Celery

Start the Celery Worker and the Celery Beat

# carries out the operations that update the materialized view.

celery -A tasks worker -l info

# produces the tasks for refreshing the materialized views

celery -A tasks beat -l info

Documentation

For more information on how to use the app, see the documentation at:

https://dj-materialized-views.readthedocs.io/en/latest/quick_start/