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.
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
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
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
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
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
No-login magic links for field crews: hashed, scoped, revocable, and usable offline

No-login magic links for field crews: hashed, scoped, revocable, and usable offline

1
Comments 2
7 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
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
Four email switches stored as an array of the ones you turned off, and consent that belongs to the address

Four email switches stored as an array of the ones you turned off, and consent that belongs to the address

Comments
6 min read
Recording who was in the room: session history, two partial unique indexes, and the RLS hole it uncovered

Recording who was in the room: session history, two partial unique indexes, and the RLS hole it uncovered

Comments 1
7 min read
Why Your Coding Agent Forgets Your Refactors (And How I Fixed It in PostgreSQL)

Why Your Coding Agent Forgets Your Refactors (And How I Fixed It in PostgreSQL)

Comments
9 min read
Restic Backup for a Small VPS: Script, Retention and Restore Test

Restic Backup for a Small VPS: Script, Retention and Restore Test

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