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.
No Redis, No Kafka: I Built a Real-Time Auction System with Just PostgreSQL

No Redis, No Kafka: I Built a Real-Time Auction System with Just PostgreSQL

3
Comments
12 min read
Cómo construí un pipeline RAG de producción con FastAPI, pgvector y cross-encoder reranking

Cómo construí un pipeline RAG de producción con FastAPI, pgvector y cross-encoder reranking

Comments
9 min read
Slapping Secondary Indexes on Random Fields is Silently Killing Your Database.

Slapping Secondary Indexes on Random Fields is Silently Killing Your Database.

2
Comments
2 min read
How to Connect PostgreSQL to Google Apps Script (JDBC Guide)

How to Connect PostgreSQL to Google Apps Script (JDBC Guide)

Comments
15 min read
Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

42
Comments 4
13 min read
Implementing pagination with PostgreSQL and the MantaHQ SDK

Implementing pagination with PostgreSQL and the MantaHQ SDK

4
Comments
5 min read
Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

3
Comments
5 min read
One Database Per Branch — Stop Breaking Your Local DB

One Database Per Branch — Stop Breaking Your Local DB

Comments
1 min read
Partitioning PotgreSQL Database

Partitioning PotgreSQL Database

38
Comments
4 min read
PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

1
Comments
12 min read
Incremental Backup with PostgreSQL 17

Incremental Backup with PostgreSQL 17

4
Comments 1
7 min read
pg-safe-migrate — Stop Shipping Unsafe Postgres Migrations

pg-safe-migrate — Stop Shipping Unsafe Postgres Migrations

5
Comments
3 min read
Building Production RAG Systems with PostgreSQL: Complete Implementation Guide

Building Production RAG Systems with PostgreSQL: Complete Implementation Guide

7
Comments 1
6 min read
PostgreSQL connection pooling — PgBouncer vs Pgpool-II compared in 5 key areas

PostgreSQL connection pooling — PgBouncer vs Pgpool-II compared in 5 key areas

1
Comments
9 min read
Setting Up CocoIndex with Docker and pgvector - A Practical Guide

Setting Up CocoIndex with Docker and pgvector - A Practical Guide

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