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.
PostgreSQL 19 Slips to November as AI Code Review Finds Bugs Faster Than Humans Can Fix Them

PostgreSQL 19 Slips to November as AI Code Review Finds Bugs Faster Than Humans Can Fix Them

Comments
4 min read
The page headed "Accept your invite" has a Google button that makes accepting the invite impossible

The page headed "Accept your invite" has a Google button that makes accepting the invite impossible

1
Comments
4 min read
I built an open-source RAG engine with org-level access control, because I couldn't find one

I built an open-source RAG engine with org-level access control, because I couldn't find one

Comments
2 min read
How I got PostgreSQL 18 running inside an Android app

How I got PostgreSQL 18 running inside an Android app

Comments
3 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
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
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
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
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.