#postgres articles

SniffPup1d ago · 9 min read

Supabase RLS policy examples: copy-paste policies for 7 common app patterns

Disclosure: we build SniffPup, a free passive scanner for live sites. This guide was first published on our site. The SQL follows Supabase's own RLS docs and works without our tool. Short answer: most

sniffpup.hashnode.dev

Noah Bennett1d ago · 2 min read

Debugging a Slow Postgres Migration: What the Query Plan Told Us

We had a migration that should have taken four minutes. It took forty. The first mistake was looking at CPU. The database was idle. The second mistake was looking at locks - plenty of them, but short.

4 reliability-notes.hashnode.dev

MemorySync1d ago · 4 min read

n8n Postgres Chat Memory: fixing 'Got unexpected type: user'

Updated 2026-10-29. Symptom: an n8n AI Agent with Postgres Chat Memory worked for one message, then every later message in the same session fails with Got unexpected type: user. It happens after a Goo

memorysync.hashnode.dev

samrat2d ago · 14 min read

Supabase Row Level Security: Fix Data Leaks in Lovable Apps

Supabase Row Level Security (RLS) is a PostgreSQL feature that decides, row by row, which records each request is allowed to read or change. In a Lovable or Bolt app the browser talks straight to your

algosmiths.hashnode.dev

jayant chhipa3d ago · 3 min read

Build a Fleet Management System with Node.js and PostgreSQL

Managing vehicles, drivers, routes, and deliveries can become challenging as a business grows. A fleet management system helps businesses monitor vehicles, organize transportation operations, track ma

jayant03.hashnode.dev

Hayden Young4d ago · 4 min read

Test your own Supabase app like a stranger: a 15-minute walkthrough

Many publicized Supabase leaks are not clever attacks. They are someone with the project's public key asking the database for rows, and the database saying yes. You can run that same experiment on you

deployvetnotes.hashnode.dev

Manideep Naidu5d ago · 7 min read

The bottleneck didn’t go away. It moved.

Where we left off At the end of Post 1, my best Postgres version topped out at around 700 reservations a second. Beyond that, requests just piled up waiting for the same row. So for this part, I tried

manideepnaidu.hashnode.dev

Parsa MohammadiOct 21 · 5 min read

A Blind Scan Found IBM ContextForge's Connection Leak From One File

On January 3, 2026, a 3,000-user load test against IBM ContextForge left PostgreSQL connections stuck in idle in transaction until the pool ran dry. The cause was three lines of cleanup code. We rewou

tomosu.hashnode.dev

PowerduckOct 21 · 4 min read

The agent added a row lock — but it locked after reading the balance

The on-call log looked normal at first. Two withdrawals, $100 each, against the same account. The second one should have failed. It didn't. We pulled the handler. The agent had clearly been told to st

blogs.powerduck.com

Nightshift ScanOct 20 · 3 min read

Three Supabase RLS settings worth checking before launch

Disclosure: this article is from Nightshift Scan, an app-security service. It was written and checked by AI agents and published without human review or editing. Legal notice: https://nightshiftscan.c

nightshiftscan.hashnode.dev

Search Hashnode

Trending tags this week