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.
El camino hacia Amazon Aurora DSQL

El camino hacia Amazon Aurora DSQL

7
Comments
10 min read
The Path to Amazon Aurora DSQL

The Path to Amazon Aurora DSQL

3
Comments
9 min read
🧠 Optimizing PostgreSQL Queries in a Full-Stack App: A Developer’s Playbook

🧠 Optimizing PostgreSQL Queries in a Full-Stack App: A Developer’s Playbook

1
Comments
3 min read
How I got into open source in 2025 (with a PostgreSQL backup tool) after almost losing a ~$1,500/mo project in 2023

How I got into open source in 2025 (with a PostgreSQL backup tool) after almost losing a ~$1,500/mo project in 2023

1
Comments 2
6 min read
Streaming PostgreSQL Backups with pgrwl: Now with Time & Count-Based Retention!

Streaming PostgreSQL Backups with pgrwl: Now with Time & Count-Based Retention!

Comments
2 min read
Dump and Sync PostgreSQL Schema with Python (No Data, No BS)

Dump and Sync PostgreSQL Schema with Python (No Data, No BS)

22
Comments
2 min read
How we built a real-time service that handles 20,000 updates per second

How we built a real-time service that handles 20,000 updates per second

24
Comments
6 min read
Database latency with PostgreSQL and MongoDB: it's the data model that makes it fast

Database latency with PostgreSQL and MongoDB: it's the data model that makes it fast

2
Comments 1
14 min read
Build a Full-Stack App with Next.js 14, Prisma, and PostgreSQL

Build a Full-Stack App with Next.js 14, Prisma, and PostgreSQL

Comments
1 min read
PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup

PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup

Comments
3 min read
Top Free ER Diagram Tools for PostgreSQL in 2025

Top Free ER Diagram Tools for PostgreSQL in 2025

11
Comments 1
7 min read
From JSONL to a normalized relational database. Is a tool necessary?

From JSONL to a normalized relational database. Is a tool necessary?

5
Comments 4
2 min read
Install PostgreSQL 16 with pgaudit Support on Ubuntu 24.04 LTS

Install PostgreSQL 16 with pgaudit Support on Ubuntu 24.04 LTS

Comments
3 min read
Create ER Diagrams for PostgreSQL with a Free Design Tool

Create ER Diagrams for PostgreSQL with a Free Design Tool

11
Comments 1
5 min read
The Cartesian Product Trap in Django ORM

The Cartesian Product Trap in Django ORM

1
Comments 2
3 min read
How I Cut My Local Development Setup Time by 95% Using Makefile

How I Cut My Local Development Setup Time by 95% Using Makefile

1
Comments
4 min read
Tired of Writing SQL Just to Explore Your DB? Me too. So I Built This.

Tired of Writing SQL Just to Explore Your DB? Me too. So I Built This.

1
Comments
2 min read
ALTER TABLE ... ADD COLUMN

ALTER TABLE ... ADD COLUMN

5
Comments
12 min read
Safeguarding Your PostgreSQL Data: A Practical Guide to pg_dump and pg_restore

Safeguarding Your PostgreSQL Data: A Practical Guide to pg_dump and pg_restore

Comments
5 min read
What is an Embedding? And Why Should Devs Care?

What is an Embedding? And Why Should Devs Care?

Comments
3 min read
Setting Up PostgreSQL on macOS: A Fresh Start Guide

Setting Up PostgreSQL on macOS: A Fresh Start Guide

1
Comments
5 min read
Just Use Postgres 🐘

Just Use Postgres 🐘

1
Comments
9 min read
Handling Concurrency with Row Level Locking in PostgreSQL

Handling Concurrency with Row Level Locking in PostgreSQL

Comments 2
6 min read
RDS Blue/Green Deployments while using IaC

RDS Blue/Green Deployments while using IaC

6
Comments
10 min read
Postgres on a Budget: 3 Free Solutions You Should Know

Postgres on a Budget: 3 Free Solutions You Should Know

2
Comments
2 min read
loading...