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.
Do You Really Need Kafka? A Practical Alternative with Postgres

Do You Really Need Kafka? A Practical Alternative with Postgres

Comments
6 min read
Spring Boot 4 入門教學 - Part 8 (常見問題與排錯)

Spring Boot 4 入門教學 - Part 8 (常見問題與排錯)

Comments
1 min read
Spring Boot 4 入門教學 - Part 6 (JDBC 資料庫連接)

Spring Boot 4 入門教學 - Part 6 (JDBC 資料庫連接)

Comments
6 min read
Simplifying PostgreSQL RLS in JPA with JPA Postgres RLS

Simplifying PostgreSQL RLS in JPA with JPA Postgres RLS

Comments
1 min read
PostgreSQL JSONB GIN Indexes: Why Your Queries Are Slow (And How to Fix Them)

PostgreSQL JSONB GIN Indexes: Why Your Queries Are Slow (And How to Fix Them)

17
Comments
5 min read
15-Minute Node.js Setup: From Zero to Production (GraphQL, PostgreSQL, Docker & CI/CD)

15-Minute Node.js Setup: From Zero to Production (GraphQL, PostgreSQL, Docker & CI/CD)

2
Comments
7 min read
Relational composition and Codd's "connection trap" in PostgreSQL and MongoDB

Relational composition and Codd's "connection trap" in PostgreSQL and MongoDB

2
Comments
7 min read
OpenAI Is Running PostgreSQL at Millions of QPS (Here’s How It Didn’t Explode)

OpenAI Is Running PostgreSQL at Millions of QPS (Here’s How It Didn’t Explode)

5
Comments
3 min read
Hey dev.to 👋

Hey dev.to 👋

1
Comments
1 min read
Horizontal Scaling PostgreSQL with Citus: A Practical Deep Dive

Horizontal Scaling PostgreSQL with Citus: A Practical Deep Dive

Comments
10 min read
PostgreSQL Didn’t Fail at Scale -My Architecture Assumptions Did

PostgreSQL Didn’t Fail at Scale -My Architecture Assumptions Did

Comments
2 min read
Manual vs Automated Database Backups: What SaaS Founders Should Choose?

Manual vs Automated Database Backups: What SaaS Founders Should Choose?

3
Comments
4 min read
PostgreSQL – Storing Time Without Lying to Yourself

PostgreSQL – Storing Time Without Lying to Yourself

Comments
6 min read
Queue vs Direct Insert: What Happens When 10,000 Users Hit Your Database at Once

Queue vs Direct Insert: What Happens When 10,000 Users Hit Your Database at Once

7
Comments
6 min read
MongoDB vs PostgreSQL: When to Choose Which One? (With Real-World Examples)

MongoDB vs PostgreSQL: When to Choose Which One? (With Real-World Examples)

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