sqlfmt▍
Category
Team practices for shipping SQL safely: CI checks, code review, and collaboration conventions.
18 posts
By 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
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
Master database connection pooling. Learn the HikariCP sizing formula, PgBouncer transaction pooling, timeout settings, and leak detection.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
How to unit test SQL queries and database logic. Explore pgTAP, ephemeral test databases with Testcontainers, and test assertion strategies.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
Learn how to completely prevent SQL injection. Understand parameterized queries, prepared statements, and safe dynamic SQL identifier quoting.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
Best practices for SQL database seeding. Build idempotent fixtures, handle foreign key dependencies, and seed deterministic test data.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
Explore SQL soft delete architectures. Compare deleted_at timestamps vs boolean flags, unique constraint collisions, partial indexes, and RLS policies.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
Master database indexing strategies for software engineers. Learn composite index column ordering, the leftmost prefix rule, and covering index design.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
A 10-step checklist to diagnose and optimize slow SQL queries. Learn how to spot table scans, non-SARGable WHERE predicates, and unindexed joins.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
Prevent and resolve Git merge conflicts in migration directories. Learn timestamp vs sequential numbering and branch collision mitigation strategies.
Read postBy Sharon Ben-Moshe · Oct 13, 2026
Learn the expand-and-contract pattern for zero-downtime database migrations. Safely rename columns, add NOT NULL constraints, and migrate data in batches.
Read postBy Sharon Ben-Moshe · Aug 8, 2026
Inconsistent naming — orders vs order, customer_id vs customerId, is_active vs active_flag — costs a team more review time than almost any formatting choice. Here's a standard worth adopting before the schema outgrows a cheap fix.
Read postBy Sharon Ben-Moshe · Aug 2, 2026
A pre-commit hook that formats and validates SQL catches bad queries before they ever reach a pull request — earlier and cheaper than CI. Here's a working setup using the sqlfmt API.
Read postBy Sharon Ben-Moshe · Jul 13, 2026
A practical SQL code review checklist for pull requests: naming, missing indexes, transaction safety, backward-compatible migrations, and injection risk.
Read postBy Sharon Ben-Moshe · Jul 13, 2026
SQL linting in CI catches syntax errors, keyword typos, and style drift before merge. Here's what it can catch, what it can't, and how to set it up.
Read post