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.
Notifying Admins When Users Confirm Their Email — The Right Way with Supabase and Next.js"

Notifying Admins When Users Confirm Their Email — The Right Way with Supabase and Next.js"

Comments
2 min read
Structuring the Database: Building an AI Task System [Floxis #2]

Structuring the Database: Building an AI Task System [Floxis #2]

Comments
4 min read
Database Optimization Strategies That Cut Query Execution Time by 60%: A Practical Guide

Database Optimization Strategies That Cut Query Execution Time by 60%: A Practical Guide

1
Comments
9 min read
Stop Pasting \timing — Run Your SQL 100 Times and Get p99

Stop Pasting \timing — Run Your SQL 100 Times and Get p99

Comments
6 min read
Rewriting My MCP Server from PHP to Go

Rewriting My MCP Server from PHP to Go

1
Comments
8 min read
37 Alembic Migrations, Zero Downtime: How We Moved a Live SaaS From Single-Tenant to Multi-Tenant

37 Alembic Migrations, Zero Downtime: How We Moved a Live SaaS From Single-Tenant to Multi-Tenant

Comments
6 min read
Amazon Aurora DSQL: A Practical Guide to AWS's Distributed SQL Database

Amazon Aurora DSQL: A Practical Guide to AWS's Distributed SQL Database

1
Comments
25 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
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
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.