Guides and articles

Long-form guides for developers who connect applications to SQL databases.

• 10 SQL query optimization techniques that actually work

  Measure first with EXPLAIN ANALYZE, then fix the patterns that cause most slow queries.

• Database indexing: how to index for performance

  B-tree, composite, partial and covering indexes, with PostgreSQL and MySQL examples.

• Data integrity and validation: building reliable database systems

  Constraints, transactions, validation layers and auditing.