Home / Companies / Tiger Data / Blog / Post Details
Content Deep Dive

Build search and RAG systems on PostgreSQL using Cohere and pgai

Blog post from Tiger Data

Post Details
Company
Date Published
Author
Avthar Sewrathan
Word Count
3,406
Company Posts That Month
8
Language
English
Hacker News Points
-
Post removed?
No
Summary

Cohere, a leading generative AI company, has partnered with pgai, an open-source PostgreSQL extension, to provide enterprise-ready large language models (LLMs) for building search and retrieval augmented generation (RAG) systems. The collaboration allows developers to create embeddings using Cohere's Embed model directly within PostgreSQL tables without transferring data in and out of the database. Additionally, Cohere Rerank can be used to improve search quality by reranking results based on relevance to queries. Pgai supports Cohere's entire suite of models, enabling developers to build hybrid search systems for higher-quality results in search and RAG applications. The integration of Cohere's Command, Embed, and Rerank models into pgai aims to help PostgreSQL evolve into an AI database, offering powerful solutions for various enterprise use cases such as investment research assistants, support chatbots, executive AI assistants, document summarization tools, knowledge and project staffing assistants, regulatory compliance monitoring, sentiment analysis for brand management, and Research and Development assistance.

Trends Found in this Post
Trend Post Mentions Total Month Mentions Posts Companies MoM
Vector Search 53 2,325 291 104 +36%
RAG 15 2,503 269 80 +39%
LLM 2 3,996 453 162 -12%
Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.