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.
Flyway vs Liquibase for PostgreSQL: An Honest Comparison

Flyway vs Liquibase for PostgreSQL: An Honest Comparison

Comments
5 min read
Squawk vs MigrationPilot: PostgreSQL Migration Linters Compared

Squawk vs MigrationPilot: PostgreSQL Migration Linters Compared

Comments
6 min read
Which ALTER TABLE Operations Lock Your PostgreSQL Table?

Which ALTER TABLE Operations Lock Your PostgreSQL Table?

Comments
4 min read
PostgreSQL Migration Best Practices for Zero-Downtime Deployments

PostgreSQL Migration Best Practices for Zero-Downtime Deployments

1
Comments
6 min read
The 5 PostgreSQL Migration Mistakes That Cause Production Outages

The 5 PostgreSQL Migration Mistakes That Cause Production Outages

1
Comments
8 min read
Atlas Paywalled Their Migration Linter — Here Are Your Free Alternatives

Atlas Paywalled Their Migration Linter — Here Are Your Free Alternatives

1
Comments
7 min read
What Most CSV Ingestion Scripts Get Wrong (And How to Fix It)

What Most CSV Ingestion Scripts Get Wrong (And How to Fix It)

1
Comments
2 min read
The Complete Guide to PostgreSQL Lock Types for Schema Changes

The Complete Guide to PostgreSQL Lock Types for Schema Changes

1
Comments
5 min read
PostgreSQL JSONB: When to Use It and How to Query It Like a Pro

PostgreSQL JSONB: When to Use It and How to Query It Like a Pro

Comments
3 min read
PostgreSQL Internals: Inside the Storage Engine

PostgreSQL Internals: Inside the Storage Engine

1
Comments
9 min read
Why Your TimescaleDB Compression Ratio Is Bad (And How to Fix It)

Why Your TimescaleDB Compression Ratio Is Bad (And How to Fix It)

Comments
4 min read
How to use pg_dump for PostgreSQL backups — the complete 2026 tutorial

How to use pg_dump for PostgreSQL backups — the complete 2026 tutorial

Comments
9 min read
I deleted my entire AI microservice and just used Postgres (here is why) 🐘⚡

I deleted my entire AI microservice and just used Postgres (here is why) 🐘⚡

1
Comments
3 min read
Comparing Today's Multi-Model Databases

Comparing Today's Multi-Model Databases

5
Comments 1
22 min read
Understanding TimescaleDB Background Workers and Jobs

Understanding TimescaleDB Background Workers and Jobs

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