examples/pglite-vector-search

Vector similarity in the browser using pglite, codemirror, and react

^{- by theowith a good amount of credit due to this Supabase blog post which I swear I discovered after I started}

An example of ingesting CSV data into pglite to be filtered using pgvector, in your browser

Originally written as a takehome project to create a user interface for an executive to understand the data included in data/trials.csv.

Features

• No server, everything is done in the browser ^{except the things done at build-time}
• PostgreSQL instance (pglite) for search (using pgvector, though the fuzzystrmatch extension is also available)
• transformer.js + Supabase/gte-small model for extracting embeddings from user query as well as dataset
• CodeMirror editor for writing SQL (used to query the dataset)
• EB Garamond for font fanciness

Getting started

pnpm i && pnpm dev