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.
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/