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.
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
PostgreSQL Replication Slots: Create, Monitor & Troubleshoot

PostgreSQL Replication Slots: Create, Monitor & Troubleshoot

Comments
3 min read
Supabase vs Neon vs Railway (2026): Which PostgreSQL for SaaS?

Supabase vs Neon vs Railway (2026): Which PostgreSQL for SaaS?

Comments
10 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.