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.
Enforce, Don't Issue: Remote MCP with OAuth Without Becoming an Authorization Server
takashimatsuyama profile

Enforce, Don't Issue: Remote MCP with OAuth Without Becoming an Authorization Server

#kozou #mcp #oauth #postgres
Comments 4
10 min read
Run AI-Written Migrations on a Throwaway Database Before They Touch Yours
codepy_1473 profile

Run AI-Written Migrations on a Throwaway Database Before They Touch Yours

#postgres #ai #devops #database
Comments 1
4 min read
Why Postgres and Cassandra Made Opposite Bets on Storage Engines
jatinjainsaraf profile

Why Postgres and Cassandra Made Opposite Bets on Storage Engines

#postgres #database #architecture #systemdesign
Comments
6 min read
Rebuilding the Cerebras Knowledge Base: adding hybrid search
faridgnank02 profile

Rebuilding the Cerebras Knowledge Base: adding hybrid search

#rag #vectordatabase #postgres #ai
Comments
6 min read
Rebuilding the Cerebras Knowledge Base: the naive vector baseline
faridgnank02 profile

Rebuilding the Cerebras Knowledge Base: the naive vector baseline

#rag #vectordatabase #postgres #ai
Comments
5 min read
Incremental Backup Using pg_basebackup in PostgreSQL 18
vahidusefzadeh profile

Incremental Backup Using pg_basebackup in PostgreSQL 18

#postgres #database #linux #ai
1
Comments
7 min read
Postgres RLS multi-tenancy: two leaks that survive correct policies
wenceslaudev profile

Postgres RLS multi-tenancy: two leaks that survive correct policies

#postgres #database #security #webdev
Comments 2
8 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
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.