JSON Toolkit

Starting from RFC 8259 and ECMA-404, this category lays out JSON's grammar, types, encoding, and parsing boundaries — the foundation every piece of JSON work rests on.

1. 01Reading JSON grammar boundaries from RFC 8259Beginner · ~11 min read
2. 02Six types, number precision, and encoding pitfallsBeginner · ~12 min read
3. 03How to fix JSON parse errors: checking Unexpected token step by stepBeginner · ~12 min read
4. 04What a JSON file is, what to open it with, and how to edit itBeginner · ~9 min read
5. 05JSON Error Message Lookup: From Error Text Straight to the FixAdvanced · ~8 min read

JSON5, JSONC, JSON Lines and NDJSON solve real needs such as comments, trailing commas and streaming, and bring compatibility and selection problems of their own.

1. 01JSON5 and JSONC: JSON with CommentsBeginner · ~10 min read
2. 02JSON Lines and NDJSON: Streaming DataIntermediate · ~10 min read
3. 03JSON Text Sequences (RFC 7464): Streaming JSON Delimited by RSIntermediate · ~9 min read
4. 04JSON, TOML, YAML, or CSON: Choosing a Configuration FormatBeginner · ~9 min read
5. 05Binary JSON: Choosing Between MessagePack, CBOR, and BSONIntermediate · ~10 min read

Taking one value out of JSON or changing one field looks simple, but once standardized it becomes four specifications: JSONPath, JSON Pointer, JSON Patch, and Merge Patch.

1. 01JSONPath Query Language in PracticeIntermediate · ~12 min read
2. 02JSON Pointer, Patch, and Merge PatchIntermediate · ~12 min read
3. 03JSONPath Filters in Depth: Recursion, Slices, and Multi-Condition MatchingIntermediate · ~10 min read
4. 04JSON Patch in Production: Atomicity, Idempotency, and Concurrent ConflictsAdvanced · ~10 min read
5. 05JMESPath for Beginners: Projection Queries That Beat JSONPathBeginner · ~9 min read

Describe the shape of your data with JSON Schema, turn verbal agreements into executable validation, and let it drive TypeScript types and form generation in turn.

1. 01JSON Schema: From Basics to ProductionIntermediate · ~14 min read
2. 02Two-Way Sync Between Schema and TypeScript TypesIntermediate · ~11 min read
3. 03Why Auto-Generated JSON Schema Keeps Rejecting Real DataIntermediate · ~14 min read
4. 04Reusing JSON Schema: $ref, $defs, and allOf/oneOf CompositionIntermediate · ~11 min read
5. 05When JSON Schema Errors Make No Sense: Ajv Error Location and Message GovernanceAdvanced · ~10 min read

Converting between JSON and YAML, XML, CSV, TypeScript, Java, Go, and SQL is never lossless. What matters is being explicit about where the loss happens.

1. 01The Boundaries of JSON ↔ YAML and XML ConversionIntermediate · ~12 min read
2. 02Converting JSON to and from CSV and Tabular DataBeginner · ~10 min read
3. 03JSON to Excel: Four Approaches and Where Each One Loses FidelityBeginner · ~11 min read
4. 04JSON to SQL: INSERT Statements, Table Design, and Type Mapping TrapsIntermediate · ~10 min read
5. 05JSON to TypeScript: Interfaces, Type Guards, and the Limits of GenerationIntermediate · ~9 min read

A JSON file of tens of megabytes can freeze the main thread, and carefully crafted JSON can punch through a service; this category covers both throughput and defenses.

1. 01Parsing, Rendering, and Streaming Large JSONIntermediate · ~13 min read
2. 02Security Risk Checklist for JSON ProcessingIntermediate · ~12 min read
3. 03Stop Doing JSON Compression in the Wrong Order: minify vs gzip vs brotli, MeasuredIntermediate · ~7 min read
4. 04The JSON Memory Ledger: What Strings, Objects, and Big Arrays Actually CostAdvanced · ~11 min read
5. 05Why Big JSON Trees Stutter: Virtual Scrolling and Collapse StrategiesAdvanced · ~10 min read

Parsing libraries, command-line tools, and editor plugins form the everyday JSON toolchain; the key to choosing between them is error-location quality and ecosystem maintenance health.

1. 01JSON Parsing and Processing Library ComparisonIntermediate · ~11 min read
2. 02Editors, Command Line, and Automation ToolchainsBeginner · ~10 min read
3. 03Choosing a JSON Diff Tool: Text Diff, Structural Diff, and VisualizationIntermediate · ~9 min read
4. 04JSON Validation in CI: A Pipeline with jsonlint, ajv, and jqIntermediate · ~10 min read
5. 05JSON Visualization Tools: Tree View, Folding, and the Trade-offs of Large DataBeginner · ~9 min read

Putting JSON into real systems: how to define API contracts, how to manage configuration and fixtures, how to handle version compatibility, and how to maintain test data.

1. 01Key Points for Designing JSON API Data ContractsIntermediate · ~13 min read
2. 02Managing JSON for Configuration, Fixtures, and Local DataBeginner · ~10 min read
3. 03When two JSON documents differ: positional diff, id-based diff, or normalize firstBeginner · ~6 min read
4. 04Git merge conflicts in JSON files: why merge=union writes broken JSONIntermediate · ~7 min read
5. 05Versioning JSON Contracts: Compatibility, Deprecation, and Data MigrationAdvanced · ~10 min read

Collects the most frequently asked questions about the tools on this site and about the JSON specification, grouped by scenario, with an answer you can act on directly instead of a vague conclusion.

1. 01Tool Usage FAQ: Data, Files, and ExportBeginner · ~10 min read
2. 02Syntax and Format FAQ: Comments, Trailing Commas, and PrecisionBeginner · ~12 min read
3. 03Query and Validation FAQ: JSONPath and SchemaIntermediate · ~12 min read
4. 04Performance and Security FAQ: Slow, Janky, and Untrusted DataIntermediate · ~13 min read
5. 05Team Collaboration FAQ: Contracts, Config, and FixturesIntermediate · ~12 min read