Episode
pgvector for Python developers
with Pamela Fox
Video of a conference talk about pgvector for Python developers presented by Pamela Fox at POSETTE: An Event for Postgres 2024. Learn how to use pgvector, the Postgres extension for vector storage and querying, from Python scripts and web apps. I'll include demos with the most common drivers and ORMs, like psycopg, asyncpg, SQLAlchemy, SQLModel, and deploy a full FastAPI app using pgvector for a vector search API. I'll also talk about embedding model options and indexing strategies.
Pamela 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's 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.
Chapters
- 00:00 - Intro
- 00:56 - Overview of vectors
- 05:07 - Tools to understand vectors
- 07:52 - Measuring the distance between vectors
- 09:53 - Storing vectors in PostgreSQL
- 18:05 - Using pgvector with Python
- 26:02 - Slides & more...
Recommended resources
Related episodes
Connect
- Twitter/X – @PosetteConf
- Mastodon - @posetteconf
- Threads – @posetteconf
- Subscribe to the POSETTE News
- Pamela Fox | Twitter/X: @pamelafox | LinkedIn: /in/pamela-fox-5668b1b4/ | Mastodon: @pamelafox
Video of a conference talk about pgvector for Python developers presented by Pamela Fox at POSETTE: An Event for Postgres 2024. Learn how to use pgvector, the Postgres extension for vector storage and querying, from Python scripts and web apps. I'll include demos with the most common drivers and ORMs, like psycopg, asyncpg, SQLAlchemy, SQLModel, and deploy a full FastAPI app using pgvector for a vector search API. I'll also talk about embedding model options and indexing strategies.
Pamela 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's 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.
Chapters
- 00:00 - Intro
- 00:56 - Overview of vectors
- 05:07 - Tools to understand vectors
- 07:52 - Measuring the distance between vectors
- 09:53 - Storing vectors in PostgreSQL
- 18:05 - Using pgvector with Python
- 26:02 - Slides & more...
Recommended resources
Related episodes
Connect
- Twitter/X – @PosetteConf
- Mastodon - @posetteconf
- Threads – @posetteconf
- Subscribe to the POSETTE News
- Pamela Fox | Twitter/X: @pamelafox | LinkedIn: /in/pamela-fox-5668b1b4/ | Mastodon: @pamelafox
Have feedback? Submit an issue here.