Building modern Python web apps with PostgreSQL | POSETTE: An Event for Postgres 2025

From the creator

Video of a conference talk detailing how PostgreSQL is the most popular database amongst Pythonistas, according to the most recent Python developers survey. Many of those developers are using PostgreSQL to build web applications, which means they're deciding what web app framework to use (Flask? Django? FastAPI?), whether to use an ORM (SQLAlchemy? SQLModel?), and whether to use asyncpg or psycopg. So many decisions! In this talk, we'll walk through an opinionated architecture—a FastAPI web app using asyncpg and SQLAlchemy—and talk about why we chose those options. Pamela Fox is a human that loves to learn, teach, and create. She's currently a Cloud Advocate in Python at Microsoft, where she helps developers use Python with the many Azure offerings. On the teaching front, Pamela has taught computer science at UC Berkeley and volunteered in Bay Area classrooms as part of the TEALS, GirlsWhoCode, and CoderDojo organizations. She also started the SF chapter of GirlDevelopIt, where she taught dozens of web development workshops. Pamela has been in the tech industry for 15 years now, starting with her first role at Google as one of their first developer advocates. She went on to be an early full-stack engineer at Coursera and spent many years after at Khan Academy, both as an engineer and the creator of the computer programming content. ► Video bookmarks: ⏩ 00:00 Welcome ⏩ 03:04 Web app architecture ⏩ 06:23 Web framework ⏩ 08:15 What is async ⏩ 09:35 DEMO of async f

Published 2025-06-12 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.