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.
Building a True Lakehouse via Snowflake Postgres and pg_lake

Building a True Lakehouse via Snowflake Postgres and pg_lake

1
Comments
15 min read
I Built a Free PostgreSQL Internals Course — Here's What I Learned

I Built a Free PostgreSQL Internals Course — Here's What I Learned

Comments
3 min read
The "bus factor" risk in MongoDB, MariaDB, Redis, MySQL, PostgreSQL, and SQLite

The "bus factor" risk in MongoDB, MariaDB, Redis, MySQL, PostgreSQL, and SQLite

4
Comments
4 min read
Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL

Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL

2
Comments
9 min read
Solving the N+1 Query Problem: A Developer's Guide to Database Performance

Solving the N+1 Query Problem: A Developer's Guide to Database Performance

1
Comments
7 min read
DocumentDB on Kubernetes: Resilient, Highly Available Databases with Automatic Failover

DocumentDB on Kubernetes: Resilient, Highly Available Databases with Automatic Failover

7
Comments
10 min read
How We Replaced Goroutines With a Database Queue for Video Transcription

How We Replaced Goroutines With a Database Queue for Video Transcription

5
Comments
5 min read
How to Setup NestJS with Prisma and PostgreSQL (2026 Complete Guide)

How to Setup NestJS with Prisma and PostgreSQL (2026 Complete Guide)

3
Comments
2 min read
The Easiest Way to Sync Stripe Data to Neon Postgres

The Easiest Way to Sync Stripe Data to Neon Postgres

2
Comments
5 min read
PostgreSQL backup retention policies — How to set up backup retention policies

PostgreSQL backup retention policies — How to set up backup retention policies

Comments
7 min read
Supabase vs Firebase in 2026: Which Backend Should You Choose?

Supabase vs Firebase in 2026: Which Backend Should You Choose?

3
Comments
12 min read
Modeling identity and access hierarchy in Postgres with ltree

Modeling identity and access hierarchy in Postgres with ltree

Comments
7 min read
Ch 4: Connecting Aiven and DBeaver

Ch 4: Connecting Aiven and DBeaver

2
Comments
2 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
Databasus: the most popular PostgreSQL backup tool

Databasus: the most popular PostgreSQL backup tool

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