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.
I built a fast, driver-less TUI for browsing PostgreSQL, with ER diagrams

I built a fast, driver-less TUI for browsing PostgreSQL, with ER diagrams

1
Comments
5 min read
How TimescaleDB Chunks Actually Work (And Why Size Matters)

How TimescaleDB Chunks Actually Work (And Why Size Matters)

1
Comments
4 min read
How We Built Data Retention for SendRec

How We Built Data Retention for SendRec

2
Comments
6 min read
Your pgvector Queries Are Doing Sequential Scans — Here's Why

Your pgvector Queries Are Doing Sequential Scans — Here's Why

1
Comments
4 min read
Message queues in Postgres Pro: ditching external brokers for true transactional reliability

Message queues in Postgres Pro: ditching external brokers for true transactional reliability

1
Comments
5 min read
Day 2/100: From In-Memory to PostgreSQL - Database Integration with SQLAlchemy

Day 2/100: From In-Memory to PostgreSQL - Database Integration with SQLAlchemy

1
Comments
9 min read
3 Production Cases: How I Built AI Systems That Actually Make Money

3 Production Cases: How I Built AI Systems That Actually Make Money

1
Comments
7 min read
PostgreSQL as a Vector Database: When to Use pgvector vs Pinecone vs Weaviate

PostgreSQL as a Vector Database: When to Use pgvector vs Pinecone vs Weaviate

11
Comments
8 min read
DocumentDB on Kubernetes: Resilient, Highly Available Databases with Automatic Failover

DocumentDB on Kubernetes: Resilient, Highly Available Databases with Automatic Failover

6
Comments
10 min read
Anthropic recognized PostgreSQL backup tool Databasus as a valuable open source project

Anthropic recognized PostgreSQL backup tool Databasus as a valuable open source project

1
Comments
4 min read
IVFFlat vs HNSW in pgvector: Which Index Should You Use?

IVFFlat vs HNSW in pgvector: Which Index Should You Use?

1
Comments
4 min read
How to Setup NestJS with Prisma and PostgreSQL (2026 Complete Guide)

How to Setup NestJS with Prisma and PostgreSQL (2026 Complete Guide)

1
Comments
2 min read
Why I Switched from Firebase to Supabase + PostgreSQL (And Cut My Costs 80%)

Why I Switched from Firebase to Supabase + PostgreSQL (And Cut My Costs 80%)

2
Comments
5 min read
Choosing the Right chunk_time_interval for Your Workload

Choosing the Right chunk_time_interval for Your Workload

1
Comments
4 min read
Optimizing Continuous Aggregate Performance for Large Datasets

Optimizing Continuous Aggregate Performance for Large Datasets

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