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.
Day 2/100: From In-Memory to PostgreSQL - Database Integration with SQLAlchemy

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

2
Comments 2
9 min read
How We Built Data Retention for SendRec

How We Built Data Retention for SendRec

3
Comments
6 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

18
Comments 3
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
I Built a Simple Log Aggregation and Analytics tool

I Built a Simple Log Aggregation and Analytics tool

2
Comments
1 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
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
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
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
DocumentDB on Kubernetes: Resilient, Highly Available Databases with Automatic Failover

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

7
Comments
10 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.