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.
Design review: Live SQL queries on PostgreSQL

Design review: Live SQL queries on PostgreSQL

Comments
2 min read
Why your async user-creation endpoint silently produces duplicates

Why your async user-creation endpoint silently produces duplicates

Comments
4 min read
Engineering and security approaches used in open-source PostgreSQL backup tool Databasus

Engineering and security approaches used in open-source PostgreSQL backup tool Databasus

Comments
7 min read
Building a RAG Application with pgvector and the OpenAI API

Building a RAG Application with pgvector and the OpenAI API

Comments
3 min read
I scanned 1,066 Prisma migrations. Here are the risky patterns that kept showing up

I scanned 1,066 Prisma migrations. Here are the risky patterns that kept showing up

Comments
3 min read
Stop Crashing Production: Zero-Downtime Database Migrations in Laravel 🛑

Stop Crashing Production: Zero-Downtime Database Migrations in Laravel 🛑

Comments
2 min read
Running Postgres at Scale: Lessons Learned

Running Postgres at Scale: Lessons Learned

Comments
2 min read
PostgreSQL Optimization for Node.js: Complete 2026 Guide

PostgreSQL Optimization for Node.js: Complete 2026 Guide

Comments
11 min read
DuckDB, Postgres, and Parquet: when one SQL query becomes a workflow

DuckDB, Postgres, and Parquet: when one SQL query becomes a workflow

Comments
4 min read
Pourquoi tes mutations Supabase mentent sur leurs erreurs

Pourquoi tes mutations Supabase mentent sur leurs erreurs

Comments
3 min read
Stop using UUID v4 for database primary keys — UUIDv7 is the 2026 default

Stop using UUID v4 for database primary keys — UUIDv7 is the 2026 default

Comments
5 min read
NGB Reports: Canonical + Composable Reporting on .NET and PostgreSQL

NGB Reports: Canonical + Composable Reporting on .NET and PostgreSQL

Comments
3 min read
Full-Text Search on a 2 GB PostgreSQL Instance

Full-Text Search on a 2 GB PostgreSQL Instance

Comments
10 min read
I keep writing the same Pydantic-asyncpg wrapper. So I published it.

I keep writing the same Pydantic-asyncpg wrapper. So I published it.

Comments
6 min read
Multi-Tenancy, Layer by Layer: From Row-Level Security to Whole-Cluster Isolation

Multi-Tenancy, Layer by Layer: From Row-Level Security to Whole-Cluster Isolation

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