DEV Community

# postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
How We Used DBtune to Cut Our Postgres Query Time by 50% on AWS RDS

How We Used DBtune to Cut Our Postgres Query Time by 50% on AWS RDS

3
Comments
9 min read
Connecting Power BI to PostgreSQL (Aiven & Localhost): A Simple Step-by-Step Guide

Connecting Power BI to PostgreSQL (Aiven & Localhost): A Simple Step-by-Step Guide

Comments
2 min read
Building an AI Code Review Swarm with Gemini & Tiger Cloud Postgres

Building an AI Code Review Swarm with Gemini & Tiger Cloud Postgres

Comments
2 min read
Why I chose Postgres (TimescaleDB) over ClickHouse for storing 10M+ logs

Why I chose Postgres (TimescaleDB) over ClickHouse for storing 10M+ logs

3
Comments
3 min read
🗄️ Build an MCP Server for PostgreSQL: Query Your Database with Claude & Any AI ClientHappy building

🗄️ Build an MCP Server for PostgreSQL: Query Your Database with Claude & Any AI ClientHappy building

2
Comments 1
4 min read
How to Connect PostgreSQL to Power BI Using Local PostgreSQL and Aiven

How to Connect PostgreSQL to Power BI Using Local PostgreSQL and Aiven

1
Comments
3 min read
How to load test PostgreSQL database and not miss anything

How to load test PostgreSQL database and not miss anything

3
Comments
14 min read
Recognition of the Winners of the Agentic Postgres Challenge with Tiger Data

Recognition of the Winners of the Agentic Postgres Challenge with Tiger Data

5
Comments 2
2 min read
Vector Search is not enough: Why I added BM25 (Hybrid Search) to my AI Memory Server

Vector Search is not enough: Why I added BM25 (Hybrid Search) to my AI Memory Server

Comments
2 min read
Reconocimiento a los ganadores del Agentic Postgres Challenge con Tiger Data

Reconocimiento a los ganadores del Agentic Postgres Challenge con Tiger Data

Comments 1
2 min read
Analyzing psqlrc settings on GitHub: How PostgreSQL engineers configure PostgreSQL

Analyzing psqlrc settings on GitHub: How PostgreSQL engineers configure PostgreSQL

4
Comments
17 min read
Under the Hood: Building a Hybrid Search Engine for AI Memory (Node.js + pgvector)

Under the Hood: Building a Hybrid Search Engine for AI Memory (Node.js + pgvector)

Comments 2
2 min read
[MyNextHome] Simple Backend Server (Supabase) with Express JS

[MyNextHome] Simple Backend Server (Supabase) with Express JS

2
Comments
4 min read
Scaling Django with PostgreSQL Partitioning: A Deep Dive

Scaling Django with PostgreSQL Partitioning: A Deep Dive

Comments
5 min read
Local RAG with Go, Ollama, and Postgres (pgvector): a minimal guide

Local RAG with Go, Ollama, and Postgres (pgvector): a minimal guide

2
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.