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.
Finding a Column Shouldn't Take a SQL Query

Finding a Column Shouldn't Take a SQL Query

Comments
5 min read
Building a Kafka-free CDC Pipeline in Go (and the DDL bug that almost broke my brain)

Building a Kafka-free CDC Pipeline in Go (and the DDL bug that almost broke my brain)

Comments 1
5 min read
Buying a phone number is a distributed transaction

Buying a phone number is a distributed transaction

Comments 1
6 min read
I Spent Two Years Deleting My Backend. This Is What's Left

I Spent Two Years Deleting My Backend. This Is What's Left

1
Comments
5 min read
Elasticsearch Isn't Dead. You Probably Don't Need It

Elasticsearch Isn't Dead. You Probably Don't Need It

Comments
5 min read
PostgreSQL Connection String: Supabase, Neon, Railway

PostgreSQL Connection String: Supabase, Neon, Railway

1
Comments 3
4 min read
Durable workflows — and durable AI agents — on Supabase alone

Durable workflows — and durable AI agents — on Supabase alone

Comments
5 min read
World Cup Data Pipeline

World Cup Data Pipeline

Comments
5 min read
I tried to build a DNA-inspired database. I accidentally made a Postgres index checker.

I tried to build a DNA-inspired database. I accidentally made a Postgres index checker.

Comments 1
4 min read
Before You Add Kafka, Redis, and Elasticsearch: Try One Postgres First

Before You Add Kafka, Redis, and Elasticsearch: Try One Postgres First

Comments
8 min read
FATAL: no pg_hba.conf entry for host: a diagnostic flow for a symptom with sever

FATAL: no pg_hba.conf entry for host: a diagnostic flow for a symptom with sever

Comments 1
7 min read
How Does a Database Actually Store Your Data?

How Does a Database Actually Store Your Data?

Comments
10 min read
Self-Hosted Chatwoot: 5 Failures the Docs Don't Warn You About

Self-Hosted Chatwoot: 5 Failures the Docs Don't Warn You About

Comments 2
7 min read
Barman vs pgBackRest: a decision tree for PostgreSQL backup in production

Barman vs pgBackRest: a decision tree for PostgreSQL backup in production

1
Comments
9 min read
How to Fix PostgreSQL 'cannot execute CREATE TABLE in a read-only transaction' Error

How to Fix PostgreSQL 'cannot execute CREATE TABLE in a read-only transaction' Error

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