Django with PostgreSQL superpowers | Citus Con: An Event for Postgres 2022

Video of a talk given at Citus Con: An Event for Postgres by Python backend developer Paolo Melchiorre. Abstract: Every time we’re going to create a new project with Django we make assessments on its requirements to choose the best architecture, of which, the database is usually the core. Django is a database-agnostic web framework but natively supports only 4 Open Source databases: PostgreSQL, SQLite, MariaDB and MySQL.

PostgreSQL has the richest feature set of any database supported by Django—and some of these Postgres features are natively supported directly in Django via its contrib module. In this talk we’ll see how to use to our advantage the features of PostgreSQL as a database in Django, its exclusive features present in its contrib module, and also other superpowers that can be exploited through the use of third-party packages.

Paolo Melchiorre is a longtime Python backend developer who contributes to the Django project and gives talks at tech conferences. Paolo has been working in the web for 15 years and is the CTO of 20tab, a pythonic software company. Paolo graduated in Software Engineering and is an alumnus of the University of Bologna, Italy.

► Video bookmarks:
⏩ 00:00 Introduction
⏩ 01:52 Django no code
⏩ 02:39 Psycopg
⏩ 04:41 Test queries
⏩ 05:55 PostgreSQL contrib
⏩ 07:26 Random UUID
⏩ 09:47 Full Text Search
⏩ 11:52 Array field
⏩ 13:49 Django Postgres copy
⏩ 16:53 Django ltree
⏩ 18:51 PostGIS
⏩ 19:42 What’s next

✅ Learn more:
Watch more Citus Con talks: https://aka.ms/cituscon-playlist

📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon

📌 Let’s connect:
Twitter – @CitusCon, https://twitter.com/CitusCon

#CitusCon #PostgreSQL #Django