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.
PostgreSQL Log Viewing

PostgreSQL Log Viewing

Comments
1 min read
Junior Me: ‘I’ll just add a class_group_id to enrollment’ Future me looking at 2023 data: ‘why is this broken’

Junior Me: ‘I’ll just add a class_group_id to enrollment’ Future me looking at 2023 data: ‘why is this broken’

Comments
2 min read
PostgreSQL | Calc Age in Year, Month, Day

PostgreSQL | Calc Age in Year, Month, Day

Comments
1 min read
PostgreSQL Menu Tree

PostgreSQL Menu Tree

Comments
1 min read
How to Backup and Restore a Single PostgreSQL Table with pg_dump

How to Backup and Restore a Single PostgreSQL Table with pg_dump

Comments
5 min read
PostgreSQL DBA Path: Setup, Table Creation, and Database Maintenance Labs

PostgreSQL DBA Path: Setup, Table Creation, and Database Maintenance Labs

Comments
2 min read
PostgreSQL and JSON in 2025

PostgreSQL and JSON in 2025

Comments
1 min read
Top 10 pg_dump Options You Should Know for Reliable PostgreSQL Backups

Top 10 pg_dump Options You Should Know for Reliable PostgreSQL Backups

Comments
6 min read
Seaography 2.0: A Powerful and Extensible GraphQL Framework 🧭

Seaography 2.0: A Powerful and Extensible GraphQL Framework 🧭

Comments
8 min read
Comparing sync/async PostgreSQL18(Amazon RDS)

Comparing sync/async PostgreSQL18(Amazon RDS)

Comments
6 min read
Serverless applications with Java and Aurora DSQL - Part 3 Integrated query editor

Serverless applications with Java and Aurora DSQL - Part 3 Integrated query editor

3
Comments
2 min read
The road to SeaQuery 1.0

The road to SeaQuery 1.0

2
Comments 1
11 min read
A Sneak Peek at SeaORM 2.0

A Sneak Peek at SeaORM 2.0

Comments
7 min read
How to Back Up a PostgreSQL Database Using pg_dump

How to Back Up a PostgreSQL Database Using pg_dump

1
Comments
4 min read
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
Why Tenant Context Must Be Scoped Per Transaction

Why Tenant Context Must Be Scoped Per Transaction

1
Comments 3
4 min read
Adaptive Join in Amazon Aurora PostgreSQL

Adaptive Join in Amazon Aurora PostgreSQL

2
Comments 3
9 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
The N+1 Insert Loop That Slowed Our API to a Crawl

The N+1 Insert Loop That Slowed Our API to a Crawl

1
Comments 3
2 min read
Unnesting Scalar Subqueries into Left Outer Joins in SQL in Aurora and PostgreSQL

Unnesting Scalar Subqueries into Left Outer Joins in SQL in Aurora and PostgreSQL

1
Comments 3
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
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
COPY FROM Exploits: When PostgreSQL Reads Your Filesystem

COPY FROM Exploits: When PostgreSQL Reads Your Filesystem

Comments
4 min read
search_path Hijacking: The PostgreSQL Attack You've Never Heard Of

search_path Hijacking: The PostgreSQL Attack You've Never Heard Of

Comments
2 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
loading...