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.
GDPR data minimization with pg_duckdb: join Azure Blob facts to erasable customer data in Postgres

GDPR data minimization with pg_duckdb: join Azure Blob facts to erasable customer data in Postgres

Comments
14 min read
taming N+1 queries in Next.js edge routes with Prisma

taming N+1 queries in Next.js edge routes with Prisma

Comments 1
2 min read
100% activation, three inactive users: a SQL interview trap

100% activation, three inactive users: a SQL interview trap

Comments
9 min read
An n8n ops platform for domain health, leads, and content

An n8n ops platform for domain health, leads, and content

Comments
4 min read
Test Your supabase-js Code Without a Server: An In-Process Backend for Vitest

Test Your supabase-js Code Without a Server: An In-Process Backend for Vitest

Comments
4 min read
Forty-one columns in our schema are enums in TypeScript and plain text in Postgres

Forty-one columns in our schema are enums in TypeScript and plain text in Postgres

Comments
6 min read
Every line of a new support thread gets its own millisecond, because one transaction would stamp them all the same

Every line of a new support thread gets its own millisecond, because one transaction would stamp them all the same

Comments
6 min read
7 Supabase RLS Mistakes That Leak Data in Expo Apps (and the SQL to Fix Them)

7 Supabase RLS Mistakes That Leak Data in Expo Apps (and the SQL to Fix Them)

Comments
4 min read
Our whole database client is twenty lines, and three of its four options exist because of the connection pooler

Our whole database client is twenty lines, and three of its four options exist because of the connection pooler

Comments
6 min read
Fifteen numbers on one admin page, one round trip, and a row count Postgres never counts

Fifteen numbers on one admin page, one round trip, and a row count Postgres never counts

Comments
5 min read
Shipping a feature means editing the data export, and deciding which columns are not about the user

Shipping a feature means editing the data export, and deciding which columns are not about the user

Comments
4 min read
The list shows two numbers, so the query digs them out of the JSON instead of loading a hundred attempts

The list shows two numbers, so the query digs them out of the JSON instead of loading a hundred attempts

Comments
4 min read
What a Supabase database backup leaves out

What a Supabase database backup leaves out

Comments
2 min read
Why Your Connection Pool is Lying to You

Why Your Connection Pool is Lying to You

Comments
2 min read
DBeaver SQL Summary Learning Notes

DBeaver SQL Summary Learning Notes

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