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.
Building an Authentication Starter: Lessons from Integrating Next.js, PostgreSQL, Prisma, and NextAuth

Building an Authentication Starter: Lessons from Integrating Next.js, PostgreSQL, Prisma, and NextAuth

Comments
4 min read
Two SQL primitives for when alert clustering gets it wrong

Two SQL primitives for when alert clustering gets it wrong

Comments
12 min read
I scanned my own Supabase project and found 17 tables anyone could read with the anon key

I scanned my own Supabase project and found 17 tables anyone could read with the anon key

Comments
4 min read
Filter on Children, Sort by Parent: One-to-Many Compound Index Strategies in PostgreSQL

Filter on Children, Sort by Parent: One-to-Many Compound Index Strategies in PostgreSQL

Comments
16 min read
Engineering and security approaches used in open-source PostgreSQL backup tool Databasus

Engineering and security approaches used in open-source PostgreSQL backup tool Databasus

1
Comments
7 min read
I scanned 1,066 Prisma migrations. Here are the risky patterns that kept showing up

I scanned 1,066 Prisma migrations. Here are the risky patterns that kept showing up

Comments 1
3 min read
Why your Supabase mutations lie about their errors

Why your Supabase mutations lie about their errors

Comments 3
2 min read
Live, Snapshot, Cache : la décision à trois voies avant de stocker une valeur dérivée

Live, Snapshot, Cache : la décision à trois voies avant de stocker une valeur dérivée

Comments
6 min read
PostgreSQL to Go REST API, Generated

PostgreSQL to Go REST API, Generated

Comments
7 min read
PgBouncer: Effectively Managing Your PostgreSQL Connection Pool

PgBouncer: Effectively Managing Your PostgreSQL Connection Pool

1
Comments
4 min read
pgAssistant 2.8 — Deterministic PostgreSQL Analysis with the new Global Advisor

pgAssistant 2.8 — Deterministic PostgreSQL Analysis with the new Global Advisor

2
Comments
3 min read
I Built a Personal Knowledge Graph. Apple Had Already Built One on My Laptop.

I Built a Personal Knowledge Graph. Apple Had Already Built One on My Laptop.

1
Comments 1
6 min read
I Built a PostgreSQL Admin Tool in Rust — ~6MB, No Electron, Sub-1s Startup

I Built a PostgreSQL Admin Tool in Rust — ~6MB, No Electron, Sub-1s Startup

1
Comments
3 min read
Before you connect AI to PostgreSQL through MCP, run this checklist

Before you connect AI to PostgreSQL through MCP, run this checklist

1
Comments
2 min read
Smart Support Desk-AI-Enabled Ticket Management System

Smart Support Desk-AI-Enabled Ticket Management System

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