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.
Beyond the API: DocumentDB vs. Aurora PostgreSQL for JSON Workloads

Beyond the API: DocumentDB vs. Aurora PostgreSQL for JSON Workloads

Comments
8 min read
Consistency

Consistency

Comments
3 min read
I Built an Open-Source Platform Foundation for Document-Driven Business Apps

I Built an Open-Source Platform Foundation for Document-Driven Business Apps

Comments
4 min read
Atomicity - Design a Reliable Wallet Transfer System with ACID Guarantees

Atomicity - Design a Reliable Wallet Transfer System with ACID Guarantees

1
Comments
3 min read
Visualizing Lock Chains: Find the Root Blocker in Seconds

Visualizing Lock Chains: Find the Root Blocker in Seconds

1
Comments
4 min read
I built a managed pgvector service and here's what I learned about vector search performance

I built a managed pgvector service and here's what I learned about vector search performance

1
Comments
4 min read
Creating Tables using constraints

Creating Tables using constraints

1
Comments
2 min read
Build an AI teammate to help with your Postgres

Build an AI teammate to help with your Postgres

Comments 2
7 min read
SQL Building Blocks: How Subqueries and CTEs Shape Your Data

SQL Building Blocks: How Subqueries and CTEs Shape Your Data

1
Comments
3 min read
Migrating From a JSON Column to a Proper Schema in Postgres

Migrating From a JSON Column to a Proper Schema in Postgres

1
Comments
6 min read
My 14-Year Journey Away from ORMs - How I Built pGenie, the SQL-First Postgres Code Generator

My 14-Year Journey Away from ORMs - How I Built pGenie, the SQL-First Postgres Code Generator

2
Comments
4 min read
Rebuild a CQRS Read Model With Zero Downtime

Rebuild a CQRS Read Model With Zero Downtime

1
Comments
7 min read
Redis vs Read Replica vs Materialised View: Pick the Right One

Redis vs Read Replica vs Materialised View: Pick the Right One

Comments
7 min read
Hybrid Search in 100 Lines: BM25 + pgvector with RRF Merge

Hybrid Search in 100 Lines: BM25 + pgvector with RRF Merge

Comments
6 min read
Outbox Pattern in Postgres, End to End: Producer, Relayer, Consumer

Outbox Pattern in Postgres, End to End: Producer, Relayer, Consumer

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