News for hackers. Stuff that matters.
Re:Supabase Vector, the Open Source Vector Toolkit for Postgres by mritchie712 on Thursday June 08, 2023 @10:33AM (#36242507)
we're[0] using pgvector via supabase in prod and we've had 0 issues. We store things like the natural language explanation of what a SQL statement does and use pgvector to look up the SQL based on a users new natural language question.

I think the argument against pgvector would be "it doesn't scale", but we're using it against hundreds of thousands of rows of data and the performance is solid (< 100ms). Maybe we'll run into issues with tens of millions of rows, but we'll worry about that when it actually becomes a problem.

0 - https://www.definite.app/

Re:Supabase Vector, the Open Source Vector Toolkit for Postgres by aligajani on Thursday June 08, 2023 @10:36AM (#36242568)
How do you prevent SQL injections or bad queries?
Re:Supabase Vector, the Open Source Vector Toolkit for Postgres by mritchie712 on Thursday June 08, 2023 @11:03AM (#36243032)
we only execute SELECT statements and the user we connect with has readonly access.

On "bad queries", we rely heavily on the users past SQL history to understand correct JOIN's and how they normally define metrics / use the database in general.