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.
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
Stop Crashing Production: Zero-Downtime Database Migrations in Laravel 🛑

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

Comments
2 min read
I Lint-Ran 4 Public Supabase Apps. They All Leak Rows.

I Lint-Ran 4 Public Supabase Apps. They All Leak Rows.

Comments 2
4 min read
Building a Healthcare AI Assistant with RAG, .NET, PostgreSQL, and pgvector

Building a Healthcare AI Assistant with RAG, .NET, PostgreSQL, and pgvector

Comments
3 min read
Day 19 of 60: From Raw SQL to a Full Stack FastAPI App.

Day 19 of 60: From Raw SQL to a Full Stack FastAPI App.

Comments
3 min read
1.3.2 How RLS Rewrites Queries (Mechanism)

1.3.2 How RLS Rewrites Queries (Mechanism)

Comments 1
11 min read
Avoiding range overlaps in PostgreSQL with EXCLUDE constraint, better than serializable or assertions

Avoiding range overlaps in PostgreSQL with EXCLUDE constraint, better than serializable or assertions

Comments 1
12 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
Zero-Downtime Database Migrations in Production (2026)

Zero-Downtime Database Migrations in Production (2026)

1
Comments 2
2 min read
What is PostgreSQL? The Database That Powers Modern Web Applications

What is PostgreSQL? The Database That Powers Modern Web Applications

Comments
2 min read
MongoDB vs PostgreSQL: Why the Same Data Looks So Different

MongoDB vs PostgreSQL: Why the Same Data Looks So Different

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

Pourquoi tes mutations Supabase mentent sur leurs erreurs

Comments
3 min read
A Go outbox library that runs inside your own DB transaction

A Go outbox library that runs inside your own DB transaction

1
Comments
7 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.