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 PostgreSQL is the default for startups

Why PostgreSQL is the default for startups

Comments
3 min read
Multi-tenant SaaS architecture patterns

Multi-tenant SaaS architecture patterns

Comments
2 min read
Database indexing explained

Database indexing explained

Comments
3 min read
MongoDB vs PostgreSQL: The Arguments Everyone Gets Wrong

MongoDB vs PostgreSQL: The Arguments Everyone Gets Wrong

4
Comments
7 min read
My CI was green. At 150 connections, Postgres said no.

My CI was green. At 150 connections, Postgres said no.

Comments
4 min read
The Postgres Creator Says LLMs Score 0% on Real Databases

The Postgres Creator Says LLMs Score 0% on Real Databases

Comments
6 min read
Database Agnostic Queries: Easing the Pain of Engine Migration

Database Agnostic Queries: Easing the Pain of Engine Migration

Comments
3 min read
Why I chose PGMQ over Redis for IoT sensor ingestion

Why I chose PGMQ over Redis for IoT sensor ingestion

Comments
2 min read
PostgreSQL UPSERT with History: From 90 Seconds to 5 with CTE

PostgreSQL UPSERT with History: From 90 Seconds to 5 with CTE

Comments
4 min read
The budget that actually blocks: the concurrency bug an AI agent's spend guardrail can't afford

The budget that actually blocks: the concurrency bug an AI agent's spend guardrail can't afford

Comments
5 min read
FOR UPDATE SKIP LOCKED: the Postgres feature that saved my digital cloakroom

FOR UPDATE SKIP LOCKED: the Postgres feature that saved my digital cloakroom

Comments
3 min read
PostgreSQL Benchmark: AWS RDS vs Hostim vs Self-Hosted on Hetzner (2026)

PostgreSQL Benchmark: AWS RDS vs Hostim vs Self-Hosted on Hetzner (2026)

Comments
6 min read
Live, Snapshot, Cache: revisiting the 3-way decision after 60 days of running it

Live, Snapshot, Cache: revisiting the 3-way decision after 60 days of running it

1
Comments
6 min read
60 jours sous Live/Snapshot/Cache : trois sauvetages, une trahison, et ce que j'ai changé

60 jours sous Live/Snapshot/Cache : trois sauvetages, une trahison, et ce que j'ai changé

Comments
7 min read
Installing GDOM with PostgreSQL as the Backend Database

Installing GDOM with PostgreSQL as the Backend Database

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