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.
Buying a phone number is a distributed transaction

Buying a phone number is a distributed transaction

Comments 1
6 min read
Row Level Security, explained how i would've wanted it starting out :) .

Row Level Security, explained how i would've wanted it starting out :) .

2
Comments 2
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
The 5 RLS holes that quietly leak data in AI-built Supabase apps

The 5 RLS holes that quietly leak data in AI-built Supabase apps

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

PostgreSQL Connection String: Supabase, Neon, Railway

1
Comments 3
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
World Cup Data Pipeline

World Cup Data Pipeline

Comments
5 min read
Durable workflows — and durable AI agents — on Supabase alone

Durable workflows — and durable AI agents — on Supabase alone

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
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
From 9,663 ms to 18 ms: sorting a 389k-product catalog in Postgres (no magic, three steps)

From 9,663 ms to 18 ms: sorting a 389k-product catalog in Postgres (no magic, three steps)

Comments 2
2 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
7 min read
How Does a Database Actually Store Your Data?

How Does a Database Actually Store Your Data?

Comments
1 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.