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.
Cutting My Self-Hosted Analytics Stack Memory by 45%

Cutting My Self-Hosted Analytics Stack Memory by 45%

6
Comments
2 min read
PostgreSQL backup and restore — Complete guide to backing up and restoring databases

PostgreSQL backup and restore — Complete guide to backing up and restoring databases

2
Comments
8 min read
Stop Grepping Your Monorepo: Real-Time Codebase Indexing with CocoIndex

Stop Grepping Your Monorepo: Real-Time Codebase Indexing with CocoIndex

5
Comments
5 min read
Brex Database Disaster Recovery

Brex Database Disaster Recovery

Comments
3 min read
Implementing a CDC pipeline with Debezium

Implementing a CDC pipeline with Debezium

Comments
8 min read
Seeding users in Supabase with a SQL seed script

Seeding users in Supabase with a SQL seed script

5
Comments
2 min read
A Missing client.release() Exhausted Our Postgres Pool at 3 AM. The ESLint Rule That Catches It.

A Missing client.release() Exhausted Our Postgres Pool at 3 AM. The ESLint Rule That Catches It.

Comments
4 min read
Setting Up a Dev Environment for FastAPI, PostgreSQL, SQLAlchemy & Alembic with Docker

Setting Up a Dev Environment for FastAPI, PostgreSQL, SQLAlchemy & Alembic with Docker

Comments
1 min read
Why Your Business Needs Automated PostgreSQL Backups

Why Your Business Needs Automated PostgreSQL Backups

Comments
3 min read
That Dreaded Alembic NotNullViolation Error (and How to Survive It)

That Dreaded Alembic NotNullViolation Error (and How to Survive It)

3
Comments 1
2 min read
PostgreSQL vs MySQL vs MongoDB in 2026: The Honest Comparison Nobody Asked For

PostgreSQL vs MySQL vs MongoDB in 2026: The Honest Comparison Nobody Asked For

Comments
8 min read
FOR UPDATE SKIP LOCKED in MongoDB

FOR UPDATE SKIP LOCKED in MongoDB

1
Comments
6 min read
BEGIN on a Postgres Pool Scatters Your Transaction Across Connections. One ESLint Rule Stops It.

BEGIN on a Postgres Pool Scatters Your Transaction Across Connections. One ESLint Rule Stops It.

Comments
4 min read
How have I managed Date types in my asyncio python web scraper using PostgreSQL?

How have I managed Date types in my asyncio python web scraper using PostgreSQL?

Comments
3 min read
Generate UUID in PostgreSQL

Generate UUID in PostgreSQL

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