Articles 19–27 of 50.
Why streams exist, the four types, and how pipeline() fixes the error handling and back-pressure bugs that pipe() leaves you with.
The TweakPad Team
Compound index ordering, the ESR rule, covered queries, and how to read explain() output to confirm an index is actually being used.
The TweakPad Team
The embed-versus-reference decision, the 16 MB document limit, and five schema patterns that solve the problems normalisation would have solved in SQL.
The TweakPad Team
How to diagnose a slow query with EXPLAIN ANALYZE, the index rules that matter, and the eight query patterns that defeat indexes.
The TweakPad Team
What each join type returns, why LEFT JOIN with a WHERE clause silently becomes an INNER JOIN, and how row multiplication inflates your aggregates.
The TweakPad Team
A fair comparison of XML and JSON — attributes, namespaces, schema validation, mixed content — and the cases where XML remains the better choice.
The TweakPad Team
Why splitting on commas breaks real CSV, how RFC 4180 quoting works, and the type-coercion and encoding traps that silently corrupt converted data.
The TweakPad Team
How JSON Schema works, the keywords that matter, and why additionalProperties false is the setting most schemas are missing.
The TweakPad Team
An honest comparison of JSON, YAML and TOML for configuration — readability, comments, tooling, and the specific ways YAML surprises people.
The TweakPad Team