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.
Taming Open Food Facts: building a fast, searchable nutrition database

Taming Open Food Facts: building a fast, searchable nutrition database

6
Comments 1
2 min read
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
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.