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.
Supabase RLS — 5 Common Mistakes I Broke and Fixed Myself

Supabase RLS — 5 Common Mistakes I Broke and Fixed Myself

Comments 1
11 min read
Demystifying the AWS Advanced JDBC Driver: Pools, Plugins, and the Traps I Hit

Demystifying the AWS Advanced JDBC Driver: Pools, Plugins, and the Traps I Hit

2
Comments
32 min read
pgvector Cosine Distance: How <=> Actually Works

pgvector Cosine Distance: How <=> Actually Works

1
Comments
3 min read
Why Your AWS RDS Bill Keeps Increasing: Here’s What No One Tells You (2026)

Why Your AWS RDS Bill Keeps Increasing: Here’s What No One Tells You (2026)

Comments
12 min read
RAG Without Embeddings: When BM25 Beats Your $0.20-per-1K Vector Index

RAG Without Embeddings: When BM25 Beats Your $0.20-per-1K Vector Index

Comments
7 min read
Durability in Wallet Transfer System

Durability in Wallet Transfer System

1
Comments
2 min read
PostgreSQL Full-Text Search for Video Metadata

PostgreSQL Full-Text Search for Video Metadata

Comments
3 min read
ISOLATION

ISOLATION

Comments
2 min read
ISOLATION

ISOLATION

Comments
2 min read
Consistency

Consistency

Comments
2 min read
PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale

PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale

Comments
3 min read
PostgreSQL Read Replicas with Docker: A Step-by-Step Guide

PostgreSQL Read Replicas with Docker: A Step-by-Step Guide

6
Comments
24 min read
# Setting Up PostgreSQL Locally and Connecting It to My Project (Beginner Journey)

# Setting Up PostgreSQL Locally and Connecting It to My Project (Beginner Journey)

1
Comments
2 min read
JSONB Video Analytics Dashboards in PostgreSQL

JSONB Video Analytics Dashboards in PostgreSQL

1
Comments
3 min read
Beyond the API: DocumentDB vs. Aurora PostgreSQL for JSON Workloads

Beyond the API: DocumentDB vs. Aurora PostgreSQL for JSON Workloads

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