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.
Tracking Tableau Viewership with PostgreSQL

Tracking Tableau Viewership with PostgreSQL

Comments
2 min read
Why We Test Row-Level Security Against a Real Postgres Database, Not Mocks

Why We Test Row-Level Security Against a Real Postgres Database, Not Mocks

6
Comments 1
4 min read
The new customer who took down everyone: an ORM include that ate our CRM

Summer Bug Smash: Smash Stories 🐛🛹

The new customer who took down everyone: an ORM include that ate our CRM

1
Comments
4 min read
ORM tipado con migraciones automĂĄticas: Fitz vs SQLAlchemy + Alembic + Pydantic

ORM tipado con migraciones automĂĄticas: Fitz vs SQLAlchemy + Alembic + Pydantic

Comments
9 min read
Typed ORM with automatic migrations: Fitz vs SQLAlchemy + Alembic + Pydantic

Typed ORM with automatic migrations: Fitz vs SQLAlchemy + Alembic + Pydantic

Comments
9 min read
Cutting Latency by 30% on a High-Traffic E-Commerce Platform: A Profiling-First Approach

Cutting Latency by 30% on a High-Traffic E-Commerce Platform: A Profiling-First Approach

1
Comments
3 min read
PostgreSQL Performance Tuning for High-Traffic React Applications

PostgreSQL Performance Tuning for High-Traffic React Applications

Comments
4 min read
Building a world-history map: PostGIS time+bbox search, a full-screen MapLibre UI, and Wikidata ETL lessons

Building a world-history map: PostGIS time+bbox search, a full-screen MapLibre UI, and Wikidata ETL lessons

Comments
8 min read
Re-Indexing a Live RAG System Without Breaking Your AI Assistant

Re-Indexing a Live RAG System Without Breaking Your AI Assistant

Comments 1
5 min read
Hybrid Search for AI Retrieval in Node: When Keywords Beat Embeddings

Hybrid Search for AI Retrieval in Node: When Keywords Beat Embeddings

Comments
5 min read
Multi-Tenant RAG in TypeScript: Keeping One Customer's AI Out of Another's Data

Multi-Tenant RAG in TypeScript: Keeping One Customer's AI Out of Another's Data

1
Comments 1
5 min read
I just published Postgres MCP Server in Go!

I just published Postgres MCP Server in Go!

Comments
2 min read
You Probably Don't Need Kafka: A Durable Outbox and Job Queue in Plain Postgres

You Probably Don't Need Kafka: A Durable Outbox and Job Queue in Plain Postgres

Comments
8 min read
pgvector from Node.js: Indexes, Pools, and the Query That Times Out

pgvector from Node.js: Indexes, Pools, and the Query That Times Out

Comments
6 min read
Your Database MCP Is Lying to You

Your Database MCP Is Lying to You

2
Comments 3
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.