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.
Supabase vs Firebase: What I Chose and Why

Supabase vs Firebase: What I Chose and Why

1
Comments
3 min read
MongoDB read and write concerns compared to PostgreSQL synchronous commit

MongoDB read and write concerns compared to PostgreSQL synchronous commit

7
Comments
7 min read
How to Connect PostgreSQL to Power BI using Local PostgreSQL.

How to Connect PostgreSQL to Power BI using Local PostgreSQL.

Comments
2 min read
# How to Connect Power BI to PostgreSQL: Local and Aiven Cloud Setup

# How to Connect Power BI to PostgreSQL: Local and Aiven Cloud Setup

Comments
3 min read
Aurora Serverless v2: When "I/O Optimized" Actually Costs You More

Aurora Serverless v2: When "I/O Optimized" Actually Costs You More

22
Comments
4 min read
New PostgreSQL Features I Developed in 2025

New PostgreSQL Features I Developed in 2025

3
Comments
5 min read
Building SynthDB: A Context-Aware Database Seeder in Rust (and Why I Need Your Help!)

Building SynthDB: A Context-Aware Database Seeder in Rust (and Why I Need Your Help!)

Comments
3 min read
Day 18 Django learnings

Day 18 Django learnings

Comments
2 min read
Snowflake + Postgres: A Small Feature That Signals a Big Shift

Snowflake + Postgres: A Small Feature That Signals a Big Shift

Comments
6 min read
PostgreSQL Backup Myths Developers Still Believe: Comparison & Truth

PostgreSQL Backup Myths Developers Still Believe: Comparison & Truth

Comments
11 min read
Database Migration Strategies for Zero-Downtime

Database Migration Strategies for Zero-Downtime

Comments
9 min read
Your Project Shouldn’t Break When You Switch Branches. So I Fixed It

Your Project Shouldn’t Break When You Switch Branches. So I Fixed It

43
Comments
5 min read
PostgreSQL Backup Myths Developers Still Believe: Comparison & Truth

PostgreSQL Backup Myths Developers Still Believe: Comparison & Truth

Comments
11 min read
When ANALYZE Isn't Enough: Debugging Bad Row Estimation in PostgreSQL

When ANALYZE Isn't Enough: Debugging Bad Row Estimation in PostgreSQL

5
Comments 4
8 min read
Adaptive Join in Amazon Aurora PostgreSQL

Adaptive Join in Amazon Aurora PostgreSQL

3
Comments 3
9 min read
2025: Building Real Backend Systems, Not Just Writing Code

2025: Building Real Backend Systems, Not Just Writing Code

1
Comments
3 min read
How to Connect PostgreSQL to Power BI Using Local PostgreSQL and Aiven

How to Connect PostgreSQL to Power BI Using Local PostgreSQL and Aiven

2
Comments
3 min read
Why Backups Fail in PostgreSQL: Common Mistakes and How to Avoid Them

Why Backups Fail in PostgreSQL: Common Mistakes and How to Avoid Them

1
Comments
5 min read
Physical vs Logical Backups in PostgreSQL: Decisive Comparison & Guide

Physical vs Logical Backups in PostgreSQL: Decisive Comparison & Guide

1
Comments
12 min read
How computers actually see time?

How computers actually see time?

1
Comments
2 min read
The Ultimate Guide to Prisma ORM + PostgreSQL (2025 Edition)

The Ultimate Guide to Prisma ORM + PostgreSQL (2025 Edition)

2
Comments
2 min read
Building Multi-Tenant SaaS as a Solo Developer

Building Multi-Tenant SaaS as a Solo Developer

Comments
4 min read
Signal-driven health monitoring for HNSW indices w/ pgvector

Signal-driven health monitoring for HNSW indices w/ pgvector

Comments
3 min read
JSONB vs. BSON: Tracing PostgreSQL and MongoDB Wire Protocols

JSONB vs. BSON: Tracing PostgreSQL and MongoDB Wire Protocols

7
Comments 2
13 min read
База данных Финальный проект

База данных Финальный проект

Comments
3 min read
loading...