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.
The Open-Source Alternative to Oracle 26ai: Why PostgreSQL is All You Need

The Open-Source Alternative to Oracle 26ai: Why PostgreSQL is All You Need

Comments
5 min read
How to Build True Multi-Tenant Database Isolation (Stop using if-statements)

How to Build True Multi-Tenant Database Isolation (Stop using if-statements)

1
Comments 1
3 min read
pg-stress — Stress Testing PostgreSQL with Claude-powered advisory

pg-stress — Stress Testing PostgreSQL with Claude-powered advisory

Comments
2 min read
I got tired of migration tools that do too much — so I built one that does exactly one thing

I got tired of migration tools that do too much — so I built one that does exactly one thing

Comments
1 min read
Optimizing Time Series Data Storage and Querying: Migrating `candle_data` from PostgreSQL to QuestDB for Enhanced Performance

Optimizing Time Series Data Storage and Querying: Migrating `candle_data` from PostgreSQL to QuestDB for Enhanced Performance

Comments
10 min read
What happens when every developer on your team can query production (safely)

What happens when every developer on your team can query production (safely)

Comments
2 min read
Finding Hidden Bottlenecks in Go Apps: A Lazy, Hacky, and Bruteforce Method

Finding Hidden Bottlenecks in Go Apps: A Lazy, Hacky, and Bruteforce Method

Comments
4 min read
Kanel v4: Generate Markdown from Postgres

Kanel v4: Generate Markdown from Postgres

Comments
3 min read
7 PostgreSQL extensions that will supercharge your database in 2026

7 PostgreSQL extensions that will supercharge your database in 2026

Comments
9 min read
Build a RAG Pipeline in Java (Text Vector LLM, No Paid APIs)

Build a RAG Pipeline in Java (Text Vector LLM, No Paid APIs)

Comments
3 min read
PostgreSQL logical replication — 5 steps to set up real-time data sync across servers

PostgreSQL logical replication — 5 steps to set up real-time data sync across servers

Comments
7 min read
Wait Event Heatmaps: See What PostgreSQL Is Actually Waiting On

Wait Event Heatmaps: See What PostgreSQL Is Actually Waiting On

Comments
4 min read
From SQLite to PostgreSQL: My First Integration Attempt (Failures, Learning & Direction Change)

From SQLite to PostgreSQL: My First Integration Attempt (Failures, Learning & Direction Change)

4
Comments
2 min read
Adding a Scripting Engine to a Rust CLI with Rhai

Adding a Scripting Engine to a Rust CLI with Rhai

1
Comments
6 min read
SQLite and PostgreSQL — Both in One Rust Application

SQLite and PostgreSQL — Both in One Rust Application

Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.