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.
Adding a foreign key to a big table without locking both of them
bolvrk profile

Adding a foreign key to a big table without locking both of them

#postgres #migrations #foreignkeys #locks
7
Comments
3 min read
One line stops a migration from taking down production. Almost nobody adds it.
bolvrk profile

One line stops a migration from taking down production. Almost nobody adds it.

#postgres #locks #migrations #incidents
6
Comments
4 min read
Visual Search on pgvector + Gemini: Detect, Crop, Embed, Rank (and the Averaging Bug That Broke Exact Match)
sahib_alizada profile

Visual Search on pgvector + Gemini: Detect, Crop, Embed, Rank (and the Averaging Bug That Broke Exact Match)

#ai #postgres #python #machinelearning
Comments
8 min read
Postgres LISTEN/NOTIFY in Production: Safe Reconnects & SSE
engineering profile

Postgres LISTEN/NOTIFY in Production: Safe Reconnects & SSE

#postgres
1
Comments 1
7 min read
Database Index: Why Queries Become Slow as Data Grows
lukman-ss profile

Database Index: Why Queries Become Slow as Data Grows

#database #postgres #sql #backend
5
Comments
3 min read
Schema Linting vs Migration Linting: Which Database Problems Each One Can See
tbson87 profile

Schema Linting vs Migration Linting: Which Database Problems Each One Can See

#database #sql #postgres #architecture
Comments
11 min read
Beyond Pure Relational SQL: Designing Hybrid Multi-Model Persistence with PostgreSQL
abhishekninja_writer profile

Beyond Pure Relational SQL: Designing Hybrid Multi-Model Persistence with PostgreSQL

#databaseengineering #systemdesignconcepts #postgres #dataarchitecture
Comments
4 min read
Two Webhooks, One Rank: Race-Safe Payments with Postgres Advisory Locks
pr0biex profile

Two Webhooks, One Rank: Race-Safe Payments with Postgres Advisory Locks

#postgres #supabase #nextjs #webdev
Comments 1
2 min read
Backups That You Don't Restore Aren't Backups: A Weekly Restore Drill
anand_rathnas_d5b608cc3de profile

Backups That You Don't Restore Aren't Backups: A Weekly Restore Drill

#postgres #devops #githubactions #database
Comments 1
6 min read
Learn PostgreSQL extensibility through a gloriously bad idea: MM/DD/YYYY native datatype and GiST index
franckpachot profile

Learn PostgreSQL extensibility through a gloriously bad idea: MM/DD/YYYY native datatype and GiST index

#postgres #sql #database #extensions
2
Comments
16 min read
What is a database view?
hrrydgls profile

What is a database view?

#database #postgres
1
Comments
2 min read
Why AI-Generated Migrations Need a Different Gate Than Code Patches
github_7727 profile

Why AI-Generated Migrations Need a Different Gate Than Code Patches

#database #postgres #softwareengineering #sql
Comments 1
4 min read
I built a Supabase RLS audit that's just SQL wrapped in a prompt
muhammed_semri_d5a477c02b profile

I built a Supabase RLS audit that's just SQL wrapped in a prompt

#supabase #postgres #security #ai
Comments
4 min read
We found a bug that let our test suite write to production. Here's what we did about it.
conchaestradamiguelangeldroid profile

We found a bug that let our test suite write to production. Here's what we did about it.

#ai #postgres #testing #security
Comments 2
2 min read
The Data Structure Behind Every Database Index: B+ Trees
arnavsharma2711 profile

The Data Structure Behind Every Database Index: B+ Trees

#database #postgres #backend #programming
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.