sqlfmt▍
sqlfmt blog
Practical posts on writing cleaner SQL and fixing the errors your database gives back.
By Sharon Ben-Moshe · Oct 13, 2026
The complete blueprint for an enterprise SQL style guide. Standardize formatting, keyword casing, indentation, naming conventions, and CI linting.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
The complete guide to SQL data types across PostgreSQL, MySQL, SQL Server, and SQLite. Numeric precision, character sets, timestamps, and JSON.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
The definitive guide to SQL query optimization. Master EXPLAIN execution plans, SARGable predicates, covering indexes, and keyset cursor pagination.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
The definitive guide to SQL Common Table Expressions (CTEs). Master chaining, recursive hierarchies, data-modifying CTEs, and optimization fences.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
Journey through the SQL query lifecycle. Explore lexical parsing, Abstract Syntax Trees, logical optimization, Cost-Based Optimizers, and Volcano execution.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
The definitive guide to database schema design. Master 1NF, 2NF, 3NF, BCNF normalization, surrogate vs natural keys, UUIDv7, and denormalization.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
Master database transactions and concurrency control. Explore ACID properties, ANSI isolation levels (Read Committed to Serializable), MVCC, and locks.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
Understand database indexing from first principles. Compare B-Trees, Hash, GiST, and GIN index structures, composite column ordering, and write costs.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
The comprehensive guide to SQL window functions. Master OVER, PARTITION BY, ORDER BY, window frames (ROWS vs RANGE), and ranking recipes.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
The definitive guide to SQL joins. Master INNER, LEFT, RIGHT, FULL OUTER, CROSS, and ANTI-JOINs, physical join algorithms, and cardinality pitfalls.
Read post