Postgresql

PostgreSQL 18 — Async I/O, UUIDv7, Virtual Generated Columns, and What Actually Matters

A focused walkthrough of PostgreSQL 18 for application developers — async I/O, native uuidv7(), virtual generated columns, OAuth auth, EXPLAIN buffer reporting by default, logical replication improvements, and what to know before you upgrade.

PostgreSQL JSONB Advanced Patterns — Indexing, Performance, and Pitfalls

JSONB beyond the basics — GIN with jsonb_path_ops, partial and expression indexes, generated columns for hot fields, partitioning, jsonb_set rewrites, and the mistakes that turn 12ms queries into 4 seconds.

pgvector Deep Dive — HNSW, IVFFlat, and Tuning Postgres for Vector Search

Everything you need to make pgvector fast in production: HNSW vs IVFFlat, distance operators, m and ef_construction, ef_search at query time, partial indexes for multi-tenant data, and benchmarking your real workload.

PostgreSQL Full-Text Search Without an Extra Service

Postgres ships with surprisingly capable full-text search built-in. Here’s how to use it for ranked text search without adding Elasticsearch to your stack.

PostgreSQL Indexing and EXPLAIN: Make Slow Queries Fast

Learn to read EXPLAIN ANALYZE output, pick the right index type for the query, and turn slow Postgres queries into fast ones — without guessing.

FastAPI + SQLAlchemy + PostgreSQL: A Modern Setup

Build a production-ready FastAPI + SQLAlchemy 2.0 + PostgreSQL stack with async sessions, dependency-injected DB access, and Alembic migrations.

PostgreSQL Fundamentals Every Backend Developer Should Know

A primer on the parts of PostgreSQL that backend developers use every day — proper data types, indexing strategies, transactions, JSONB, CTEs, and more.

How to Connect PostgreSQL with Django

Step-by-step guide to creating a PostgreSQL database, a dedicated user with sane defaults, and wiring it into a Django project via environment variables.