News for hackers. Stuff that matters.
Re:Embeddings are a good starting point for the AI curious a... by kiwicopple on Thursday April 18, 2024 @03:22AM (#40073801)
This is possible in supabase. You can store all the data in a table and restrict access with Row Level Security

You also have various ways to separate the data for indexes/performance

- use metadata filtering first (eg: filter by customer ID prior to running a semantic search). This is fast in postgres since its a relational DB

- pgvector supports partial indexes - create one per customer based on a customer ID column

- use table partitions

- use Foreign Data Wrappers (more involved but scales horizontally)

There are no comments on this comment yet.