close

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.
I audited my own Supabase project and found it wide open — with RLS on

I audited my own Supabase project and found it wide open — with RLS on

Comments 19
3 min read
Forgekit: An Open-Source Next.js AI Starter Kit with RAG and pgvector

Forgekit: An Open-Source Next.js AI Starter Kit with RAG and pgvector

Comments
11 min read
'2026-27' is a better database key than a date range

'2026-27' is a better database key than a date range

Comments
4 min read
Applying and undoing migrations: migrate, status, rollback

Applying and undoing migrations: migrate, status, rollback

Comments
6 min read
Generate SQL migrations from your JPA entities

Generate SQL migrations from your JPA entities

Comments
3 min read
Renaming columns and tables without losing data

Renaming columns and tables without losing data

Comments
6 min read
Why Serverless Functions Keep Exhausting Your Postgres Connections

Why Serverless Functions Keep Exhausting Your Postgres Connections

Comments
3 min read
Cost Estimates or Timed Canaries: A Debate for Promoting Agent SQL

Cost Estimates or Timed Canaries: A Debate for Promoting Agent SQL

Comments
9 min read
Code evolves quickly, databases remember everything

Code evolves quickly, databases remember everything

BERJAYA 3
Comments
1 min read
Database Indexing – Part 5: Sequential Scan vs. Index Scan vs. Bitmap Index Scan in PostgreSQL

Database Indexing – Part 5: Sequential Scan vs. Index Scan vs. Bitmap Index Scan in PostgreSQL

Comments
6 min read
Postgres for local dev: one container, one Makefile

Postgres for local dev: one container, one Makefile

Comments
3 min read
Aborting a Fetch Doesn't Stop Your Node.js Server. Here's What Does.

Surprising pitfalls with Postgres and Node signals

Aborting a Fetch Doesn't Stop Your Node.js Server. Here's What Does.

BERJAYA BERJAYA BERJAYA 43
Picked as gem Comments 27
8 min read
I made PostgreSQL refuse to store a lie

I made PostgreSQL refuse to store a lie

Comments
3 min read
How We Cut Postgres p95 Latency from 914ms to 2ms (Serverless vs. Docker + PgBouncer)

How We Cut Postgres p95 Latency from 914ms to 2ms (Serverless vs. Docker + PgBouncer)

Comments
5 min read
Booking availability is a preview, not a reservation

Booking availability is a preview, not a reservation

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