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.
Installing PostgreSQL on Ubuntu 26.04

Installing PostgreSQL on Ubuntu 26.04

Comments
2 min read
Two days lost to PGRST116: when Supabase RLS hides a successful write

Two days lost to PGRST116: when Supabase RLS hides a successful write

Comments
3 min read
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
We built an enterprise integration stack for .NET from scratch: EAV + DSL + runtime

We built an enterprise integration stack for .NET from scratch: EAV + DSL + runtime

Comments
5 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
Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data

Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data

Comments 1
5 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.