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.
Just Shipped FilmTailor's Scheduling Feature and Chose Event Sourcing. Sorry Not Sorry

Just Shipped FilmTailor's Scheduling Feature and Chose Event Sourcing. Sorry Not Sorry

Comments
9 min read
PostgreSQL vs MySQL vs NoSQL: The Complete Guide to Understanding Modern Databases

PostgreSQL vs MySQL vs NoSQL: The Complete Guide to Understanding Modern Databases

Comments
5 min read
On benchmarking

On benchmarking

Comments
11 min read
Don't parse SQL to make a query runner read-only

Don't parse SQL to make a query runner read-only

Comments
3 min read
Your AI Agent Can Run DROP TABLE on Production

Your AI Agent Can Run DROP TABLE on Production

Comments
3 min read
PostgreSQL Query Optimization: Performance Tuning for Full-Stack Applications

PostgreSQL Query Optimization: Performance Tuning for Full-Stack Applications

Comments
4 min read
Operational Registers in NGB Platform: Tracking Operational Business State

Operational Registers in NGB Platform: Tracking Operational Business State

Comments
3 min read
JSONB Was Fine. The Side Effects Needed a State Boundary.

JSONB Was Fine. The Side Effects Needed a State Boundary.

Comments
5 min read
PostgreSQL 22030 Error: Causes and Solutions Complete Guide

PostgreSQL 22030 Error: Causes and Solutions Complete Guide

Comments
3 min read
CloudNativePG: Running PostgreSQL in Kubernetes Without the Pain

CloudNativePG: Running PostgreSQL in Kubernetes Without the Pain

Comments
10 min read
PostgreSQL on Kubernetes — Complete Setup Guide with CloudNativePG

PostgreSQL on Kubernetes — Complete Setup Guide with CloudNativePG

Comments
2 min read
Database Decisions: Choosing Between PostgreSQL, MongoDB, and MySQL

Database Decisions: Choosing Between PostgreSQL, MongoDB, and MySQL

Comments
5 min read
PostgreSQL 2200S Error: Causes and Solutions Complete Guide

PostgreSQL 2200S Error: Causes and Solutions Complete Guide

Comments
3 min read
SELECT MAX()+1 Is a Race Condition Waiting to Happen

SELECT MAX()+1 Is a Race Condition Waiting to Happen

Comments
3 min read
PostgREST can't upsert against partial unique indexes

PostgREST can't upsert against partial unique indexes

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