Building modern Python web apps with PostgreSQL
summary
Claims Postgres is the most popular DB among Python devs and demonstrates a working API‑centric stack: FastAPI + asyncpg + SQLAlchemy using ASGI/asyncio for concurrency. The demo stores embeddings in pgvector and performs hybrid vector + full‑text retrieval, then calls an LLM for RAG; some queries use raw SQL for performance. The app runs locally and deploys to Azure components, and the async approach yields higher concurrent throughput.
AI-written summary · about
chapters (10)
- 0:00Welcome
- 3:04Web app architecture
- 6:23Web framework
- 8:15What is async
- 9:35DEMO of async function
- 14:23How to use async with web apps
- 19:03Postgres driver
- 20:57The ORM
- 22:42DEMO of the application
- 28:30Final thoughts
related talks
49mPostgreSQL - the database-sister of Python
31mAdventures in FastAPI: A Choose-Your-Own PyCon AU Talk
53mModern PostgreSQL for AI...
43mOptimize Python & Django apps with Postgres superpowers
24mPostgres-powered AI: Running an End-to-End AI Platform with Postgres on Azure
44mPostgres and OpenAI - a match made in Azure
32mWhat makes Azure Database for PostgreSQL Great for Developers?
47mBuilding Scalable Web Apps