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.
Karpathy's LLM wiki pattern is missing a data layer. Here's how to add one.

Karpathy's LLM wiki pattern is missing a data layer. Here's how to add one.

Comments 1
9 min read
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
Your Stack Is Colonizing Itself — And You're Paying the Cognitive Tax

Your Stack Is Colonizing Itself — And You're Paying the Cognitive Tax

8
Comments 2
8 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
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
How to Optimize PostgreSQL 18 Performance with PgBouncer 1.23 and Redis 8.1: 2026 Guide

How to Optimize PostgreSQL 18 Performance with PgBouncer 1.23 and Redis 8.1: 2026 Guide

Comments
15 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.