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.
Next.js job board: stop indexing expired jobs

Next.js job board: stop indexing expired jobs

Comments
5 min read
GitLab on Kubernetes: Production-Ready PostgreSQL and Redis HA

GitLab on Kubernetes: Production-Ready PostgreSQL and Redis HA

Comments
13 min read
My 14-Year Journey Away from ORMs - How I Built pGenie, the SQL-First Postgres Code Generator

My 14-Year Journey Away from ORMs - How I Built pGenie, the SQL-First Postgres Code Generator

Comments
4 min read
Debugging Postgres LISTEN/NOTIFY Is Finally Pleasant

Debugging Postgres LISTEN/NOTIFY Is Finally Pleasant

Comments
5 min read
How I Fixed a Correlated Subquery That Was Behaving Like an N+1 Problem in Production

How I Fixed a Correlated Subquery That Was Behaving Like an N+1 Problem in Production

Comments
2 min read
PostgreSQL Replication Slots: Create, Monitor & Troubleshoot

PostgreSQL Replication Slots: Create, Monitor & Troubleshoot

Comments
3 min read
Why PostgreSQL Ignores Your Index

Why PostgreSQL Ignores Your Index

Comments
9 min read
Semantic Search in Laravel: Building a Vector-Powered Product Discovery Engine

Semantic Search in Laravel: Building a Vector-Powered Product Discovery Engine

Comments
5 min read
Why Redis Cannot Share the Truth with Postgres - The architecture mistake that will oversell your tickets

Why Redis Cannot Share the Truth with Postgres - The architecture mistake that will oversell your tickets

Comments
9 min read
Patterns for Postgres Traffic Control

Patterns for Postgres Traffic Control

Comments
9 min read
Neon vs Supabase (2026) — Database or Backend? The Real Tradeoffs

Neon vs Supabase (2026) — Database or Backend? The Real Tradeoffs

Comments
4 min read
16GB of RAM, 12GB of JSON, and One Very Loud Fan

16GB of RAM, 12GB of JSON, and One Very Loud Fan

Comments
5 min read
SQL Indexes Explained: Write Queries That Don't Make Your Database Cry

SQL Indexes Explained: Write Queries That Don't Make Your Database Cry

Comments
6 min read
Introduction to Databases with SQL

Introduction to Databases with SQL

2
Comments
6 min read
Managing Academic Data: A Practical Application of SQL in PostgreSQL

Managing Academic Data: A Practical Application of SQL in PostgreSQL

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