sqlfmt▍
sqlfmt blog
Practical posts on writing cleaner SQL and fixing the errors your database gives back.
By 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 · Oct 12, 2026
Format recursive CTEs (WITH RECURSIVE) for hierarchical data. Master clean separation of anchor member, UNION ALL, recursive step, and depth guards.
Read post