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.
CDC without Kafka: keeping Postgres, OpenSearch, and Redis in sync with one binary

CDC without Kafka: keeping Postgres, OpenSearch, and Redis in sync with one binary

Comments
8 min read
Supabase stops auto-granting new tables on Oct 30. Don't fix the 42501 with GRANT ALL

Supabase stops auto-granting new tables on Oct 30. Don't fix the 42501 with GRANT ALL

1
Comments 2
8 min read
How to Build a Production-Grade RAG Agent with Hybrid Search in 30 Minutes

How to Build a Production-Grade RAG Agent with Hybrid Search in 30 Minutes

Comments
4 min read
I Built a Distributed Task Queue from Scratch with Go and PostgreSQL

I Built a Distributed Task Queue from Scratch with Go and PostgreSQL

Comments
14 min read
Database Isolation: Why Two Committed Transfers Can Create Money

Database Isolation: Why Two Committed Transfers Can Create Money

6
Comments 2
8 min read
Snowflake IDs de 64-bits em Elixir e Ecto: Como Otimizar ĂŤndices e Eliminar UUIDs em Sistemas DistribuĂ­dos

Snowflake IDs de 64-bits em Elixir e Ecto: Como Otimizar ĂŤndices e Eliminar UUIDs em Sistemas DistribuĂ­dos

Comments
3 min read
CRUD Was the Easy Part: What I Learned Building a Self-Hosted Judging System

CRUD Was the Easy Part: What I Learned Building a Self-Hosted Judging System

2
Comments 1
6 min read
Your edge rate limit is not protecting the database

Your edge rate limit is not protecting the database

1
Comments
4 min read
Postgres Internals in Simple Words: One Example to Understand Tables, Pages, Tuples, and Indexes

Postgres Internals in Simple Words: One Example to Understand Tables, Pages, Tuples, and Indexes

Comments 1
4 min read
Simulating a football match one minute at a time

Simulating a football match one minute at a time

Comments 1
4 min read
Why ALTER TABLE Still Takes Down Production Postgres in 2026

Why ALTER TABLE Still Takes Down Production Postgres in 2026

Comments
4 min read
The scoring bugs we almost shipped in a hackathon judging platform

The scoring bugs we almost shipped in a hackathon judging platform

1
Comments
7 min read
Leaving Supabase Cloud: the three failures that produce no error

Leaving Supabase Cloud: the three failures that produce no error

1
Comments 6
6 min read
PostgreSQL Row-Level Security: Multi-Tenancy Without Leaking Tenant Data

PostgreSQL Row-Level Security: Multi-Tenancy Without Leaking Tenant Data

Comments
2 min read
One booking. Three answers. Only one was true.

One booking. Three answers. Only one was true.

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