Articles 73–96 of 105.
Resource naming, status codes, pagination, versioning and error shapes — focusing on the choices that later break.
The TweakPad Team
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 replace normalisation.
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 returns, why LEFT JOIN plus WHERE silently becomes INNER JOIN, and how row multiplication inflates totals.
The TweakPad Team
A fair comparison — attributes, namespaces, schema validation, mixed content — and where XML is still the better choice.
The TweakPad Team
Why splitting on commas breaks real CSV, how RFC 4180 quoting works, and the 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
JSON, YAML and TOML compared for configuration — readability, comments, tooling, and the ways YAML surprises people.
The TweakPad Team
The eight JSON syntax errors behind nearly every parse failure, what the messages mean, and how to find the problem fast.
The TweakPad Team
Naming, date formats, null handling and the structural choices that make JSON easy to consume — plus what the spec allows.
The TweakPad Team
How next/image prevents layout shift, what sizes and priority really do, and the config mistakes that make images slower.
The TweakPad Team
How Server Actions work, why they are safer than an API route for form handling, and the validation and authorisation you must not skip.
The TweakPad Team
The Request Memoization, Data Cache, Full Route Cache and Router Cache — what each one caches, how long for, and how to opt out correctly.
The TweakPad Team
Using the native Metadata API for titles, canonicals, OpenGraph and JSON-LD — and why next-seo is unnecessary now.
The TweakPad Team
A tour of the App Router — layouts, route groups, loading and error boundaries, dynamic segments — and when to use each.
The TweakPad Team
A diagnosis-first guide — how to find the real bottleneck with the Profiler, and the five fixes behind most real wins.
The TweakPad Team
What React does with keys during reconciliation, the concrete bugs index keys cause, and how to pick a key when your data has no id.
The TweakPad Team
What Server Components are, the client boundary, what can cross it, and how to decide which components need use client.
The TweakPad Team
Memoisation has a real price. How to tell which of the three legitimate cases you are in, and why most useMemo is waste.
The TweakPad Team
useState, useEffect, useRef, useReducer and the rest — what each is for, and the mistakes that cause infinite loops.
The TweakPad Team
An incremental path from JavaScript to TypeScript — allowJs, per-file adoption, untyped dependencies, and creeping any.
The TweakPad Team
The real differences — declaration merging, unions, performance and error messages — with a simple rule for choosing.
The TweakPad Team