pgvector for Python developers | POSETTE 2024

From the creator

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...

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