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.
Transaction Hooks: A General Primitive for Post-Commit Side Effects (Case Study: Queuert)

Transaction Hooks: A General Primitive for Post-Commit Side Effects (Case Study: Queuert)

Comments
7 min read
One vector space for photos and words: Bedrock Titan multimodal on Aurora

One vector space for photos and words: Bedrock Titan multimodal on Aurora

2
Comments
3 min read
Your WHERE clause is not a security boundary (multi-tenant RAG with pgvector + RLS)

Your WHERE clause is not a security boundary (multi-tenant RAG with pgvector + RLS)

1
Comments 3
4 min read
PostgreSQL Foreign Key Cycles in Multi-Tenant Hierarchies: Breaking Circular Dependencies Without Violating Referential Integrity

PostgreSQL Foreign Key Cycles in Multi-Tenant Hierarchies: Breaking Circular Dependencies Without Violating Referential Integrity

Comments
4 min read
How I Built a Production Ready Microservice Notification System with NestJS, Redis, Bull Queues, and Docker

How I Built a Production Ready Microservice Notification System with NestJS, Redis, Bull Queues, and Docker

1
Comments
2 min read
Database Partitioning: When, Why, and the Numbers That Matter

Database Partitioning: When, Why, and the Numbers That Matter

Comments
8 min read
Stop Using UUIDs: Why B2B SaaS Needs ULIDs in Laravel 🐘

Stop Using UUIDs: Why B2B SaaS Needs ULIDs in Laravel 🐘

Comments
3 min read
Designing Scalable Architectures for Cloud Storage and Databases

Designing Scalable Architectures for Cloud Storage and Databases

1
Comments
7 min read
Three dumb ways our prod got slow (and not one was a slow algorithm)

Three dumb ways our prod got slow (and not one was a slow algorithm)

13
Comments 3
5 min read
SQL + AI: Real-World Database Solutions You Can Use Today

SQL + AI: Real-World Database Solutions You Can Use Today

1
Comments
9 min read
Infinite recursion in Postgres RLS: a SECURITY DEFINER gotcha

Infinite recursion in Postgres RLS: a SECURITY DEFINER gotcha

Comments
2 min read
Multi-tenant PostgreSQL: row-level security vs schema-per-tenant & when to use which

Multi-tenant PostgreSQL: row-level security vs schema-per-tenant & when to use which

Comments
2 min read
Building a Zero-Leak Postgres MCP Gateway in Go

Building a Zero-Leak Postgres MCP Gateway in Go

4
Comments 3
11 min read
PostgreSQL VACUUM Tuning: A Technical Deep Dive Into Autovacuum Configuration

PostgreSQL VACUUM Tuning: A Technical Deep Dive Into Autovacuum Configuration

Comments
10 min read
$lookup join strategies: understanding the trade-offs with flexible documents

$lookup join strategies: understanding the trade-offs with flexible documents

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