github repo –> tbrockman/pglite-vector-search

An interactive 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 filter through 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)