Databases in Depth: SQL, Indexes, Transactions, and When to Use What
Learn SQL, indexes, and transactions by doing, with SQLite built into Python, then see how it carries over to Postgres and when NoSQL, Redis, or a vector database makes sense.
#postgresql
Posts tagged #postgresql
Zero-Downtime Database Migrations Without Breaking Production
How to change a live PostgreSQL schema without freezing tables or breaking running code: the expand and contract pattern, safer versions of risky ALTERs, and tested code.
Database Transaction Isolation: 5 Concurrency Bugs and How to Fix Them
Dirty reads, lost updates and write skew: what each bug looks like, which isolation level stops it, and what PostgreSQL and MySQL really do.
Choosing a Vector Database: pgvector vs Dedicated Stores
When Postgres with pgvector is enough, when a dedicated vector database earns its keep, and how to decide using scale, filtering, and operations.
Postgres Performance Basics: Reading EXPLAIN Output and Fixing Slow Queries
Learn to read EXPLAIN ANALYZE output, spot what actually slows a query down, and fix it with better indexes, statistics, and cleaner SQL.
Supabase in 2026: The Production Playbook for Grants, RLS, Keys, Connections, Realtime and Cost
A practical production guide to Supabase grants, row-level security, API keys, Postgres connections, Realtime, Edge Functions and pricing.
