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

17
Comments 2
8 min read
My FOSDEM 2026 watchlist

My FOSDEM 2026 watchlist

1
Comments 1
4 min read
How I Cut API Latency by 95% by Fixing One Hidden Loop ❤️‍🔥

How I Cut API Latency by 95% by Fixing One Hidden Loop ❤️‍🔥

2
Comments 1
11 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
Building a True Lakehouse via Snowflake Postgres and pg_lake

Building a True Lakehouse via Snowflake Postgres and pg_lake

1
Comments
15 min read
Optimizing PostgreSQL in Multi-Tenant Kubernetes: Addressing Inefficiency, Resource Waste, and Scalability Challenges

Optimizing PostgreSQL in Multi-Tenant Kubernetes: Addressing Inefficiency, Resource Waste, and Scalability Challenges

2
Comments
9 min read
I Built a Free PostgreSQL Internals Course — Here's What I Learned

I Built a Free PostgreSQL Internals Course — Here's What I Learned

Comments
3 min read
The "bus factor" risk in MongoDB, MariaDB, Redis, MySQL, PostgreSQL, and SQLite

The "bus factor" risk in MongoDB, MariaDB, Redis, MySQL, PostgreSQL, and SQLite

4
Comments
4 min read
Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL

Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL

2
Comments
9 min read
Solving the N+1 Query Problem: A Developer's Guide to Database Performance

Solving the N+1 Query Problem: A Developer's Guide to Database Performance

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

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

3
Comments
2 min read
How We Replaced Goroutines With a Database Queue for Video Transcription

How We Replaced Goroutines With a Database Queue for Video Transcription

5
Comments
5 min read
The Easiest Way to Sync Stripe Data to Neon Postgres

The Easiest Way to Sync Stripe Data to Neon Postgres

2
Comments
5 min read
PostgreSQL backup retention policies — How to set up backup retention policies

PostgreSQL backup retention policies — How to set up backup retention policies

Comments
7 min read
Supabase vs Firebase in 2026: Which Backend Should You Choose?

Supabase vs Firebase in 2026: Which Backend Should You Choose?

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