Post Content
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 function
⏩ 14:23 How to use async with web apps
⏩ 19:03 Postgres driver
⏩ 20:57 The ORM
⏩ 22:42 DEMO of the application
⏩ 28:30 Final thoughts
📕 Everything you need to know about POSETTE: An Event for Postgres 2025 can be found at: https://posetteconf.com
✅ Learn more:
Watch more POSETTE talks: https://aka.ms/posette-playlist
📌 Let’s connect:
LinkedIn – https://www.linkedin.com/company/posetteconf/
X – @PosetteConf, https://twitter.com/PosetteConf
Mastodon – @posetteconf, https://mastodon.social/@posetteconf
Bluesky – @posetteconf.com, https://bsky.app/profile/posetteconf.com
____________________
#PosetteConf #PostgreSQL #Python Read More Microsoft Developer
