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.
The Only Guide You Need for Prisma Migration Conflicts (Without Losing Data)

The Only Guide You Need for Prisma Migration Conflicts (Without Losing Data)

1
Comments
6 min read
How I built a free real estate AVM with 375k notary transactions, PostGIS, and a 4€/month VPS

How I built a free real estate AVM with 375k notary transactions, PostGIS, and a 4€/month VPS

3
Comments
4 min read
I made the database compute everything: building an SLA-credit system of record on Aurora PostgreSQL + Vercel

I made the database compute everything: building an SLA-credit system of record on Aurora PostgreSQL + Vercel

1
Comments
7 min read
What It Actually Takes to Audit Aurora PostgreSQL on AWS

What It Actually Takes to Audit Aurora PostgreSQL on AWS

Comments
7 min read
Diagnosing a slow Rails page, layer by layer

Diagnosing a slow Rails page, layer by layer

6
Comments
4 min read
Semantic Search with PostgreSQL: Pragmatism Beats Hype - Most of the Time

Semantic Search with PostgreSQL: Pragmatism Beats Hype - Most of the Time

10
Comments 2
8 min read
Less Database, More Files

Less Database, More Files

1
Comments
14 min read
Streaming a pg_restore through Python without deadlocking

Streaming a pg_restore through Python without deadlocking

Comments
4 min read
Sync Supabase via OAuth: No Connection String Needed

Sync Supabase via OAuth: No Connection String Needed

Comments 1
9 min read
Don t Lock Your API - Lock Your Scheduler Instead

Don t Lock Your API - Lock Your Scheduler Instead

3
Comments 2
5 min read
Preventing double-bookings with PostgreSQL exclusion constraints

Preventing double-bookings with PostgreSQL exclusion constraints

Comments
6 min read
RAG and Vector Search with pgvector and Amazon Bedrock (Part 4)

RAG and Vector Search with pgvector and Amazon Bedrock (Part 4)

Comments 1
8 min read
I fuzzed my own Supabase RLS — and found a cross-tenant leak

I fuzzed my own Supabase RLS — and found a cross-tenant leak

7
Comments 2
2 min read
Natural-language SQL breaks quietly when schema context goes stale

Natural-language SQL breaks quietly when schema context goes stale

1
Comments
1 min read
Your AI database agent should not query the primary by default

Your AI database agent should not query the primary by default

1
Comments
1 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.