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.
File handling in PostgreSQL: barriers and ways around them

File handling in PostgreSQL: barriers and ways around them

Comments
8 min read
Making Redis Optional: Why I’m pivoting to a 'Postgres-First' Architecture and why chose Valkey as alternative

Making Redis Optional: Why I’m pivoting to a 'Postgres-First' Architecture and why chose Valkey as alternative

19
Comments 4
5 min read
Best Ways to Migrate a Database (What I Learned Doing It in Production)

Best Ways to Migrate a Database (What I Learned Doing It in Production)

2
Comments
3 min read
Upgrading PostgreSQL 13 to 17 on AWS RDS with Minimal Downtime

Upgrading PostgreSQL 13 to 17 on AWS RDS with Minimal Downtime

2
Comments 1
7 min read
PostgreSQL Primary Keys-Why Your UUID Choice Matters

PostgreSQL Primary Keys-Why Your UUID Choice Matters

1
Comments
3 min read
ScholarBridge

ScholarBridge

1
Comments
2 min read
PgBench on MongoDB via Foreign Data Wrapper

PgBench on MongoDB via Foreign Data Wrapper

3
Comments
8 min read
Why you don't need PITR and incremental backups for most PostgreSQL databases in 2026

Why you don't need PITR and incremental backups for most PostgreSQL databases in 2026

Comments
7 min read
I migrated 15M records of 13GB data from Mongo to Rails Postgres on a 512MB budget

I migrated 15M records of 13GB data from Mongo to Rails Postgres on a 512MB budget

2
Comments
6 min read
The Day I Chose VARCHAR(255) and Regretted It: A PostgreSQL String Story

The Day I Chose VARCHAR(255) and Regretted It: A PostgreSQL String Story

2
Comments 1
8 min read
FOR UPDATE SKIP LOCKED in MongoDB

FOR UPDATE SKIP LOCKED in MongoDB

1
Comments
6 min read
New to a Large Project? This Is How I Decode Complex Databases

New to a Large Project? This Is How I Decode Complex Databases

1
Comments
2 min read
Postgresus is live on Product Hunt — the open source PostgreSQL backup tool

Postgresus is live on Product Hunt — the open source PostgreSQL backup tool

Comments
2 min read
IVFFlat Indexing in pgvector

IVFFlat Indexing in pgvector

Comments
3 min read
SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations

SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations

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