Building HTAP Applications with Python & Postgres on Azure

Demo created for PyCon 2020 about building HTAP applications on Azure—by scaling out Postgres with Hyperscale (Citus) on Azure Database for PostgreSQL. HTAP stands for “hybrid transactional analytical processing.” In this demo, Sai Srirampur from the Postgres team at Microsoft shows us how scaling out Postgres with Hyperscale (Citus) enables you to use a single database to serve both transactional and analytical workloads—reducing operational costs, and headaches, in a big way.

This demo uses a Django application for ad agency campaigns that runs on Azure Database for PostgreSQL—and includes a lovely cameo by the Postgres extension to Azure Data Studio, which Sai uses to demo several Postgres EXPLAIN plans, and the performance improvements you get due to the parallelism of Hyperscale (Citus).

#HTAP #Postgres #Python

✅ More demos, workshops, and labs from our PyCon 2020 team:
https://aka.ms/pycon2020

✅ Slides for this PyCon demo on Building HTAP apps with Python & Postgres on Azure:
https://aka.ms/build-HTAP-apps-postgres-azure-slides

✅ Hyperscale (Citus) Quickstart Docs for Azure:
https://aka.ms/hyperscale-citus-quickstart

✅ Multi-tenant Tutorial for Hyperscale (Citus) on Azure
http://aka.ms/hyperscale-citus-multi-tenant-tutorial

✅ GitHub repo for django-multitenant library from Citus
https://aka.ms/django-multitenant-github

✅ GitHub repo for sample Django app used in this demo
https://aka.ms/django-PG-ad-app

✅ Join Citus monthly technical newsletter
https://aka.ms/citus-newsletter