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.
Supabase multi-tenant RLS: membership policy pattern

Supabase multi-tenant RLS: membership policy pattern

Comments 1
5 min read
When the Disparate Must Become One: On Honest Distributed Systems

When the Disparate Must Become One: On Honest Distributed Systems

Comments
2 min read
Zero-Downtime Database Migrations in Laravel & Node.js SaaS: Expand-Contract & Lock Timeouts

Zero-Downtime Database Migrations in Laravel & Node.js SaaS: Expand-Contract & Lock Timeouts

Comments
9 min read
Fix slow Supabase queries caused by complex RLS policies

Fix slow Supabase queries caused by complex RLS policies

1
Comments 1
4 min read
Tech debt is not dead. It chose the format of our referral codes.

Tech debt is not dead. It chose the format of our referral codes.

3
Comments 2
4 min read
Back Up a Database: Download a SQL Dump and Restore It

Back Up a Database: Download a SQL Dump and Restore It

Comments
4 min read
Our prep plan has no done button, because a checkbox would be a second opinion about what you practised

Our prep plan has no done button, because a checkbox would be a second opinion about what you practised

Comments
5 min read
MCP Postgres Guard: Preventing SQL Injections and Slow Queries in AI Agents

MCP Postgres Guard: Preventing SQL Injections and Slow Queries in AI Agents

Comments
1 min read
Deleting one user row empties 21 of our 29 tables, and the delete statement names one of them

Deleting one user row empties 21 of our 29 tables, and the delete statement names one of them

1
Comments 1
5 min read
SaaS Backup & Disaster Recovery: RPO, RTO and PITR

SaaS Backup & Disaster Recovery: RPO, RTO and PITR

Comments
7 min read
Laravel Pgvector Eloquent: Vector Similarity Search & HNSW Indexing in Laravel

Laravel Pgvector Eloquent: Vector Similarity Search & HNSW Indexing in Laravel

Comments
1 min read
Supabase Free Has No Backups — Here's the Free Way to Add Them

Supabase Free Has No Backups — Here's the Free Way to Add Them

1
Comments 1
5 min read
All 25 of our tables have row level security on and not one policy, and that is the finished design

All 25 of our tables have row level security on and not one policy, and that is the finished design

1
Comments
4 min read
We read the Supabase migrations of 512 Lovable apps: 16% let signed-out visitors rewrite a whole table

We read the Supabase migrations of 512 Lovable apps: 16% let signed-out visitors rewrite a whole table

Comments 1
4 min read
The managed Postgres bill nobody puts on the pricing page

The managed Postgres bill nobody puts on the pricing page

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