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.
MVCC Explained: Build Postgres-Style Snapshots in 100 Lines of TypeScript
jatin510 profile

MVCC Explained: Build Postgres-Style Snapshots in 100 Lines of TypeScript

#postgres #database #systemdesign #typescript
Comments
12 min read
My app could read the database. pgAdmin couldn't. Both were pointing at "localhost:5432"
vidhidixit2000 profile

My app could read the database. pgAdmin couldn't. Both were pointing at "localhost:5432"

#docker #postgres #beginners #devops
Comments
3 min read
Database Connections in Serverless: Field Notes on Pool Math, PgBouncer Transaction Mode, and the Singleton HMR Kept Recreating
ahmed_mahmoud360 profile

Database Connections in Serverless: Field Notes on Pool Math, PgBouncer Transaction Mode, and the Singleton HMR Kept Recreating

#postgres #serverless #node #webdev
1
Comments
5 min read
Your audit log is probably lying to you. Postgres 18 fixes it in one statement.

Concurrently logged ghosts hide lost transactions
remdore profile

Your audit log is probably lying to you. Postgres 18 fixes it in one statement.

#postgres #sql #database #webdev
12
Comments 6
5 min read
A Shapefile Is Four Files, and the Important One Is Optional
srdjan_poppovic profile

A Shapefile Is Four Files, and the Important One Is Optional

#python #gis #fastapi #postgres
Comments
5 min read
Building a RAG Retrieval Service: pgvector, Embedding Migrations, and Provenance Tracking
humzakt profile

Building a RAG Retrieval Service: pgvector, Embedding Migrations, and Provenance Tracking

#rag #pgvector #embeddings #postgres
Comments
3 min read
Building a Notification Service: Cloud Tasks Delivery, Circuit Breakers, and Webhook Dispatch
humzakt profile

Building a Notification Service: Cloud Tasks Delivery, Circuit Breakers, and Webhook Dispatch

#cloudtasks #webhooks #fastapi #postgres
Comments
5 min read
I put reminders, contacts and recipes in the same Postgres table. Here is the SQL, and what it cost.
xneuronal profile

I put reminders, contacts and recipes in the same Postgres table. Here is the SQL, and what it cost.

#postgres #database #architecture #ai
Comments
5 min read
Using an AST to validate AI-generated PostgreSQL before it runs
nur-zaman profile

Using an AST to validate AI-generated PostgreSQL before it runs

#postgres #ai #security #typescript
Comments
3 min read
The RLS Policy Was Correct. The Write Was Still Wrong.
toddsullivan profile

The RLS Policy Was Correct. The Write Was Still Wrong.

#security #supabase #postgres #devops
Comments
3 min read
MCP vs. a Direct Database Connection: A Security and Workflow Comparison
vivekdraxlr profile

MCP vs. a Direct Database Connection: A Security and Workflow Comparison

#sql #database #ai #postgres
Comments
7 min read
One View Per Layer: Four Sharp Edges I Found in My Own Code
srdjan_poppovic profile

One View Per Layer: Four Sharp Edges I Found in My Own Code

#postgres #gis #django #webdev
Comments
6 min read
A Small Fintech Challenge, and Why I Let Postgres Hold the Money
jeyem profile

A Small Fintech Challenge, and Why I Let Postgres Hold the Money

#postgres #go #fintech #concurrency
Comments
4 min read
Moving Oracle to PostgreSQL with a Single `INSERT` — No Oracle Client, No Python
sergey_rudenko_40963c1b7f profile

Moving Oracle to PostgreSQL with a Single `INSERT` — No Oracle Client, No Python

#dataengineering #duckdb #oracledatabase #postgres
Comments
11 min read
Redis Caching in NestJS: I Cut Database Calls by 60% in Production
arihantjain916 profile

Redis Caching in NestJS: I Cut Database Calls by 60% in Production

#nextjs #redis #backend #postgres
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.