🏷️

postgres

2 articles tagged with "postgres"

Tech Feeds

ai-assisted-coding

Building Hybrid Search for RAG: Combining pgvector and Full-Text Search with Reciprocal Rank Fusion

Most RAG tutorials show you the happy path: embed your documents, store them in a vector database, do a similarity search, done. Ship it. Then you put it in front of real users and discover that seman...

ai-assisted-coding

SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG

Today was one of those SQL days where things look simple… until you actually write the query. I focused on GROUP BY, HAVING, and the basic aggregate functions: MIN, MAX, and AVG. These are things I’ve...