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.
Postgres With pgvector vs Pinecone: 1 Million Embeddings, One Honest Comparison

Postgres With pgvector vs Pinecone: 1 Million Embeddings, One Honest Comparison

Comments
8 min read
Rebuild a CQRS Read Model With Zero Downtime

Rebuild a CQRS Read Model With Zero Downtime

1
Comments
7 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
Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs

Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs

Comments 1
8 min read
The Outbox Pattern in PHP from Scratch (No Library, 80 Lines)

The Outbox Pattern in PHP from Scratch (No Library, 80 Lines)

1
Comments
8 min read
Three Ways to Set Up CDC from Postgres to ClickHouse

Three Ways to Set Up CDC from Postgres to ClickHouse

1
Comments
9 min read
Don’t Trust Backups You Haven’t Restored

Don’t Trust Backups You Haven’t Restored

Comments
8 min read
Releasing HeliosProxy, The programmable Postgres data-plane

Releasing HeliosProxy, The programmable Postgres data-plane

1
Comments 1
1 min read
WEB UI in Go? Nothing Can Stop Me!

WEB UI in Go? Nothing Can Stop Me!

Comments
6 min read
Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead

Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead

Comments
6 min read
Indexing Solana Programs in Rust: Notes From a Python Backend Engineer

Indexing Solana Programs in Rust: Notes From a Python Backend Engineer

1
Comments
3 min read
Why our Free was so far behind Pro — and what we just shipped in RedBase 3.0.0 (with the actual SQL)

Why our Free was so far behind Pro — and what we just shipped in RedBase 3.0.0 (with the actual SQL)

Comments
24 min read
$exists and non-sparse indexes in MongoDB and in other DocumentDB

$exists and non-sparse indexes in MongoDB and in other DocumentDB

Comments
10 min read
Advanced PostgreSQL: JSONB, partial indexes and partitioning

Advanced PostgreSQL: JSONB, partial indexes and partitioning

Comments
7 min read
Building a Multi-Tenant Clinic SaaS with NestJS + Prisma: What 12 Months in Production Taught Me

Building a Multi-Tenant Clinic SaaS with NestJS + Prisma: What 12 Months in Production Taught Me

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