Aggregating Data in Django Using Database Views

Discover how to efficiently aggregate data in Django using database views in this 30-minute EuroPython 2024 conference talk by Mikuláš Poul. Learn about the django-pgviews-redux library, which provides first-class support for database views with PostgreSQL, simplifying complex aggregation tasks. Explore how database views can be wrapped around models, offering familiar features like querysets, filtering, and admin integration. Walk through practical examples comparing traditional Django aggregation methods with the simplified approach using the library. Gain insights into materialized views and their potential for significant performance improvements when working with large datasets. Master techniques to streamline your Django projects and enhance database query efficiency.

Aggregating data in Django using database views — Mikuláš Poul