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.
How to Use pgvector with Python: A Complete Guide

How to Use pgvector with Python: A Complete Guide

Comments
7 min read
Modifying Tables Safely in PostgreSQL — ALTER TABLE, Constraints, and Defaults

Modifying Tables Safely in PostgreSQL — ALTER TABLE, Constraints, and Defaults

Comments
4 min read
How I Built a Full Helpdesk SaaS from Scratch as a Solo Developer

How I Built a Full Helpdesk SaaS from Scratch as a Solo Developer

2
Comments
2 min read
Aggregate Identity in Go: UUID v7, ULID, or Snowflake?

Aggregate Identity in Go: UUID v7, ULID, or Snowflake?

Comments
8 min read
Adding Semantic Search to Your Postgres App with pgvector

Adding Semantic Search to Your Postgres App with pgvector

Comments 1
6 min read
Why We Chose JSONB for AI: How NextBlock CMS Bypassed the "HTML Wall" for Next.js 16

Why We Chose JSONB for AI: How NextBlock CMS Bypassed the "HTML Wall" for Next.js 16

Comments
3 min read
Interactive Replication Topology: See Your Cluster at a Glance

Interactive Replication Topology: See Your Cluster at a Glance

Comments
4 min read
dbtyper: TypeScript for SQL — a Compile-Time SQL Type Checker

dbtyper: TypeScript for SQL — a Compile-Time SQL Type Checker

19
Comments 3
6 min read
PostgreSQL JSONB for Video Analytics Dashboards

PostgreSQL JSONB for Video Analytics Dashboards

2
Comments
3 min read
Postgres Connection Pooling: Stop the Timeouts

Postgres Connection Pooling: Stop the Timeouts

1
Comments
6 min read
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.