Technology RadarTechnology Radar

Postgres with pg_vector

AIVector Database
This item was not updated in last three versions of the Radar. Should it have appeared in one of the more recent editions, there is a good chance it remains pertinent. However, if the item dates back further, its relevance may have diminished and our current evaluation could vary. Regrettably, our capacity to consistently revisit items from past Radar editions is limited.
Adopt

[pg_vector] is a PostgreSQL extension that adds native vector indexing and similarity search capabilities directly to your Postgres database. This offers significant benefit in set-up, development and maintenance by avoiding the need for a separate, dedicated vector database that would require additional infrastructure, querying and syncing efforts.

MOHARA is has adopted the use of pg_vector to provide vector capabilities to the supabase-managed postgres database that forms part of teh Mo Stack boilerplate.