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.
Why Real-Time Analytics Eventually Changes Your Database Architecture

Why Real-Time Analytics Eventually Changes Your Database Architecture

3
Comments
4 min read
Rewriting My MCP Server from PHP to Go

Rewriting My MCP Server from PHP to Go

1
Comments
8 min read
Time-Series Databases (InfluxDB/TimescaleDB)

Time-Series Databases (InfluxDB/TimescaleDB)

1
Comments
8 min read
PostgreSQL Monitoring Tools Compared (2026)

PostgreSQL Monitoring Tools Compared (2026)

Comments
4 min read
Why We Stopped Using Row-Level Security After 1M Rows

Why We Stopped Using Row-Level Security After 1M Rows

Comments 1
6 min read
Your agent forgets yesterday's lessons by tomorrow. Here's the layer we built to fix that.

Your agent forgets yesterday's lessons by tomorrow. Here's the layer we built to fix that.

Comments
5 min read
PostgreSQL to Snowflake: A Hands-On CDC Streaming Guide

PostgreSQL to Snowflake: A Hands-On CDC Streaming Guide

Comments
13 min read
Don't Calculate Distances in PHP: Master PostGIS in Laravel 🗺️

Don't Calculate Distances in PHP: Master PostGIS in Laravel 🗺️

Comments
2 min read
Building a Scalable Backend Architecture with NestJS, Kafka, and PostgreSQL

Building a Scalable Backend Architecture with NestJS, Kafka, and PostgreSQL

Comments
1 min read
I vibe-coded a Postgres workspace because pgAdmin and DBeaver don't fit how I work

I vibe-coded a Postgres workspace because pgAdmin and DBeaver don't fit how I work

Comments 2
2 min read
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
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
Building a Horse Racing AI Pipeline: PostgreSQL + Claude for Automated Race Predictions

Building a Horse Racing AI Pipeline: PostgreSQL + Claude for Automated Race Predictions

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