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.
Build a RAG-Powered Database Assistant with PostgreSQL and pgvector

Build a RAG-Powered Database Assistant with PostgreSQL and pgvector

2
Comments 1
6 min read
Why I Used Both Amazon Aurora AND DynamoDB in the Same App — AWS H0 Hackathon

Why I Used Both Amazon Aurora AND DynamoDB in the Same App — AWS H0 Hackathon

Comments
2 min read
How I Solved Double-Booking Race Conditions in a Multi-Tenant SaaS — No Redis, No Distributed Locks

How I Solved Double-Booking Race Conditions in a Multi-Tenant SaaS — No Redis, No Distributed Locks

Comments 4
5 min read
A Generic Table API with Dapper in 80 Lines of C#

A Generic Table API with Dapper in 80 Lines of C#

6
Comments
6 min read
Your event store is already your audit log

Your event store is already your audit log

1
Comments
3 min read
Migrating 200 Million Records in .NET without crashing production: From Row-by-Row to a Crash-Safe Batched Pipeline

Migrating 200 Million Records in .NET without crashing production: From Row-by-Row to a Crash-Safe Batched Pipeline

Comments
7 min read
Why I chose Aurora Serverless v2 + App Runner + Vercel for my SaaS stack

Why I chose Aurora Serverless v2 + App Runner + Vercel for my SaaS stack

Comments
4 min read
SQL window functions: what separates a mid-level from a senior developer

SQL window functions: what separates a mid-level from a senior developer

Comments
5 min read
I needed graph traversal queries and ended up building a full incident response tool

I needed graph traversal queries and ended up building a full incident response tool

Comments
3 min read
Building AgentPulse: An AI-Powered Workforce Management Platform for Customer Experience Teams

Building AgentPulse: An AI-Powered Workforce Management Platform for Customer Experience Teams

Comments
2 min read
Why I Bypassed Git CI/CD and Built a Native HTTP Ingestion Engine for My Content Operations

Why I Bypassed Git CI/CD and Built a Native HTTP Ingestion Engine for My Content Operations

Comments
3 min read
Rails Wasn’t Our Bottleneck. PostgreSQL I/O Was.

Rails Wasn’t Our Bottleneck. PostgreSQL I/O Was.

1
Comments
2 min read
Stuck at "Preparing… 0/0" Forever. My State Machine Had No Exit.

Summer Bug Smash: Clear the Lineup 🐛🛹

Stuck at "Preparing… 0/0" Forever. My State Machine Had No Exit.

11
Comments 3
4 min read
READ COMMITTED isn't as safe as you think

READ COMMITTED isn't as safe as you think

Comments 2
6 min read
Two exploits, one public API key: the day I attacked my own Supabase app

Summer Bug Smash: Smash Stories 🐛🛹

Two exploits, one public API key: the day I attacked my own Supabase app

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