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.
Top 10 Mistakes Developers Make with pg_dump (And How to Avoid Them)

Top 10 Mistakes Developers Make with pg_dump (And How to Avoid Them)

Comments
4 min read
PostgreSQL backup tools comparison — Databasus, WAL-G, pgBackRest and Barman

PostgreSQL backup tools comparison — Databasus, WAL-G, pgBackRest and Barman

Comments
9 min read
Why Tenant Context Must Be Scoped Per Transaction

Why Tenant Context Must Be Scoped Per Transaction

1
Comments 3
4 min read
pg-status - a lightweight microservice for checking PostgreSQL host status

pg-status - a lightweight microservice for checking PostgreSQL host status

1
Comments
7 min read
🐳 How Docker Saved My Full-Stack Project (And My Sanity)

🐳 How Docker Saved My Full-Stack Project (And My Sanity)

Comments
4 min read
UPDATE...RETURNING in MongoDB: ACID and idempotency with findOneAndUpdate()

UPDATE...RETURNING in MongoDB: ACID and idempotency with findOneAndUpdate()

1
Comments
5 min read
One INSERT Loop Made Our CSV Import 500x Slower. One ESLint Rule Catches It Before It Ships.

One INSERT Loop Made Our CSV Import 500x Slower. One ESLint Rule Catches It Before It Ships.

1
Comments 3
4 min read
How to Sync Stripe Data to PostgreSQL in 5 Minutes (No Code)

How to Sync Stripe Data to PostgreSQL in 5 Minutes (No Code)

Comments
3 min read
Prisma + StackRender: Design Your Database and Start Building Your Backend

Prisma + StackRender: Design Your Database and Start Building Your Backend

5
Comments
6 min read
13 PostgreSQL Backup Best Practices for Developers and DBAs

13 PostgreSQL Backup Best Practices for Developers and DBAs

1
Comments
12 min read
PostgreSQL's COPY FROM Can Read /etc/passwd Into Your Database. One ESLint Rule Blocks It.

PostgreSQL's COPY FROM Can Read /etc/passwd Into Your Database. One ESLint Rule Blocks It.

Comments
5 min read
search_path Hijacking: the PostgreSQL Attack That Turns SELECT * FROM users Into the Attacker's Table

search_path Hijacking: the PostgreSQL Attack That Turns SELECT * FROM users Into the Attacker's Table

Comments
4 min read
Using Postgres Full-Text Search on a Next.JS Fullstack App

Using Postgres Full-Text Search on a Next.JS Fullstack App

Comments
5 min read
Self-Hosted vs Cloud PostgreSQL Backups: Full Pros and Cons Guide

Self-Hosted vs Cloud PostgreSQL Backups: Full Pros and Cons Guide

Comments
5 min read
Cutting My Self-Hosted Analytics Stack Memory by 45%

Cutting My Self-Hosted Analytics Stack Memory by 45%

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