Blog
Practical notes on databases, SQL workflows, and building better developer tools.
SQL SELECT Statement: Syntax, Examples, and Best Practices
Learn how to use SQL SELECT to retrieve, filter, sort, group, and join relational data, with practical examples and database-specific notes.
September 14, 2026 · 8 min read
Mobin Yazdanparast
MySQL Architecture Explained: Layers, InnoDB & Query Flow
Understand how MySQL handles connections, parses and optimizes SQL, delegates work to storage engines, and uses InnoDB memory and disk structures to manage data.
September 13, 2026 · 14 min read
Mobin Yazdanparast
PostgreSQL EXPLAIN ANALYZE: How to Read Query Plans
Learn how to read PostgreSQL EXPLAIN ANALYZE output, compare planner estimates with actual rows, interpret loops and buffers, and diagnose slow queries.
September 12, 2026 · 9 min read
Mobin Yazdanparast
PostgreSQL B-Tree Index Explained: How It Really Works
How the PostgreSQL B-tree index works: page structure, search and write behavior, and production maintenance with fillfactor, pgstattuple, amcheck, and REINDEX CONCURRENTLY.
September 11, 2026 · 9 min read
Mobin Yazdanparast
Understanding PostgreSQL EXPLAIN
Learn to read PostgreSQL EXPLAIN output: cost, rows, and actual time, scan and join nodes, BUFFERS, and the red flags that point to missing indexes or stale statistics.
September 10, 2026 · 9 min read
Mobin Yazdanparast
PostgreSQL Query Optimization: A Step-by-Step Guide
A practical, step-by-step workflow for PostgreSQL query optimization: find slow queries, read plans with EXPLAIN ANALYZE, apply proven fixes, and verify results.
September 6, 2026 · 13 min read
Mobin Yazdanparast
PostgreSQL Index Performance Tuning: Practical Guide
A practical guide to PostgreSQL index performance tuning: diagnose slow queries with EXPLAIN ANALYZE, choose the right index type, and eliminate bloat and unused indexes.
September 5, 2026 · 10 min read
Mobin Yazdanparast
How to Find Missing Indexes in PostgreSQL: 5 Proven Methods
A practical, four-step workflow for PostgreSQL missing index detection using pg_stat views, pg_stat_statements, EXPLAIN (ANALYZE, BUFFERS), and log-based tools — plus a checklist for creating the right index.
September 4, 2026 · 10 min read
Mobin Yazdanparast
Find Unused Indexes in PostgreSQL: A Quick Guide
Learn how to find unused indexes in PostgreSQL using pg_stat_user_indexes. Improve database performance and reduce bloat with our step-by-step guide.
September 3, 2026 · 7 min read
Mobin Yazdanparast
What We Learned Building DBO Studio 1.1.0
DBO Studio 1.1.0 is about removing uncertainty: schema diagrams for unfamiliar databases, Safe Mode for the wrong connection, typed editors for real column types, and pagination so a SELECT without LIMIT no longer means fetch everything.
September 3, 2026 · 8 min read
Mobin Yazdanparast