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.
Prisma Postgres Seed: prisma db seed, psql, and the Direct URL
mikh-shytsko profile

Prisma Postgres Seed: prisma db seed, psql, and the Direct URL

#prisma #postgres #node #database
Comments
19 min read
One docker compose up, One Seeded Postgres
mikh-shytsko profile

One docker compose up, One Seeded Postgres

#docker #postgres #devops #database
Comments
6 min read
Five bugs AI wrote for me that never threw an error
igor_potapenko profile

Five bugs AI wrote for me that never threw an error

#ai #webdev #testing #postgres
Comments
6 min read
Nine of Thirteen Corrections Were Wrong: The Fix That Came With a Proof It Couldn't Work
dbartalos profile

Nine of Thirteen Corrections Were Wrong: The Fix That Came With a Proof It Couldn't Work

#postgres #database #datamigration #debugging
Comments 2
10 min read
Replace the Heuristic With a Boundary: Rebuilding a Leave Table as an Append-Only Ledger
dbartalos profile

Replace the Heuristic With a Boundary: Rebuilding a Leave Table as an Append-Only Ledger

#postgres #architecture #database #datamigration
Comments
9 min read
The API Endpoint Explosion: What If AI Agents Could use SQL on User Data Directly?
slipxnot profile

The API Endpoint Explosion: What If AI Agents Could use SQL on User Data Directly?

#ai #mcp #database #postgres
Comments 2
8 min read
What is Information Schema in PostgreSQL?
hrrydgls profile

What is Information Schema in PostgreSQL?

#database #postgres
Comments
2 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
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
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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.