~/talk

Semantic search with Django, PostgreSQL, & pgvector

Talkat POSETTE: An Event for Postgres 2024 · 2024-06-11..06-13· [databases]
slides:none on file

Shows a working semantic search added to an existing Django app by storing embeddings in Postgres via pgvector, creating a Vector extension migration and a fixed-dimension embedding column, and using sentence-transformers to encode text on save. Queries use pgvector’s cosine distance operator to filter and order results, demonstrated in the Django admin returning surprisingly relevant matches (e.g., “guitar” matching “rock” and “music”). Notes heavy deps for sentence-transformers and simple integration by override model.save and Django + PostgreSQL + pgvector.

AI-written summary · about

  1. 0:00Intro
  2. 1:17Django
  3. 2:19Flask, FastAPI, etc
  4. 4:06Django - Code
  5. 9:47Django - Administration
  6. 14:26Semantic Search and Vector Databases
  7. 16:37pgvector
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.