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 RLS Policies Safely with Neon Branching

Test RLS Policies Safely with Neon Branching

Comments
7 min read
One Null in the Subquery and Your NOT IN Returned Nothing

One Null in the Subquery and Your NOT IN Returned Nothing

Comments
2 min read
# A Practical Guide to Advanced SQL: Window Functions, Joins, CTEs, and Subqueries Using a Hospital Database

# A Practical Guide to Advanced SQL: Window Functions, Joins, CTEs, and Subqueries Using a Hospital Database

Comments
21 min read
pg_vectorsearch vs pgvector HNSW: 42 Hours vs 49 Minutes. Here's the Catch

pg_vectorsearch vs pgvector HNSW: 42 Hours vs 49 Minutes. Here's the Catch

Comments 1
7 min read
Scaling Node.js REST APIs with TypeScript and PostgreSQL: Beyond Basic CRUD

Scaling Node.js REST APIs with TypeScript and PostgreSQL: Beyond Basic CRUD

Comments
1 min read
One optional phone number, eleven files, five kinds of empty, and no migration

One optional phone number, eleven files, five kinds of empty, and no migration

Comments
7 min read
Setting an env var above your imports does not run before them, and our integration test works anyway

Setting an env var above your imports does not run before them, and our integration test works anyway

Comments
6 min read
A malformed uuid is a 500, not an empty result, which is why one five line function has 19 call sites

A malformed uuid is a 500, not an empty result, which is why one five line function has 19 call sites

Comments
5 min read
Append-Only Audit Logs in Postgres with Triggers and Node.js

Append-Only Audit Logs in Postgres with Triggers and Node.js

Comments
5 min read
Stopping Chat Spam on Netlify with a Simple Rate‑Limit

Stopping Chat Spam on Netlify with a Simple Rate‑Limit

Comments
2 min read
Wait, How Did Hackers Steal the Encryption Key Too?" 5 Supabase Security Traps I Fixed in Production

Wait, How Did Hackers Steal the Encryption Key Too?" 5 Supabase Security Traps I Fixed in Production

1
Comments 2
6 min read
Scaling Node.js REST APIs with TypeScript and PostgreSQL: Beyond Basic CRUD

Scaling Node.js REST APIs with TypeScript and PostgreSQL: Beyond Basic CRUD

Comments
1 min read
Our newest commit changed zero files, and the 27 lines it was really about are all pooler workarounds

Our newest commit changed zero files, and the 27 lines it was really about are all pooler workarounds

Comments
5 min read
Two postgres-js clients for one database, and every number in them is different

Two postgres-js clients for one database, and every number in them is different

Comments
5 min read
Completo, incremental y PITR en PostgreSQL 17: guía práctica con restauración verificada

Completo, incremental y PITR en PostgreSQL 17: guía práctica con restauración verificada

Comments 1
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.