Advanced JSON — JSONPath, NDJSON, Patch & Databases
JSONPath, JSON Lines, JSON Patch, data modeling, config, and JSON in databases.
SQLite JSON Functions: Store and Query JSON with SQL
SQLite has full JSON support built in — json_extract, the -> and ->> operators, json_each for arrays, and JSONB storage. Query JSON columns without a document database.
Kafka Schema Registry: Avro, JSON Schema & Compatibility Explained
A Schema Registry stops one bad producer from breaking every consumer. How the wire format works, the backward/forward/full compatibility modes, and the rules for evolving a schema safely.
Query JSON with DuckDB: SQL Analytics on JSON Files
DuckDB reads JSON and NDJSON files directly with SQL — no import, no server. read_json, schema inference, the arrow operators, UNNEST for arrays, and multi-file globs.
Structured Data for AI Search: JSON-LD, GEO & Getting Cited by ChatGPT
AI answer engines cite content they can verify. Learn how JSON-LD structured data drives Generative Engine Optimization and gets you cited by ChatGPT.
PostgreSQL JSONB: Store & Query JSON in Postgres
PostgreSQL's JSONB type lets you store and query JSON with full indexing. Learn JSONB vs JSON, the query operators, indexing with GIN, and when to use it.
JSON vs. YAML for CI/CD Config — GitHub Actions, Docker Compose, and Beyond
Most CI/CD tools default to YAML, but many parse JSON just as happily since YAML is a superset of it. Where that actually matters — generated pipelines, templating, programmatic editing.
JSON in Game Development — Save Files, Level Data, and Game State
Why JSON shows up everywhere in game dev outside the hot render loop — save files, level/tilemap data, dialogue trees, and config — and where a binary format still wins instead.
JSON Configuration Files: Best Practices & Patterns
JSON powers package.json, tsconfig, and countless app configs. Learn how to structure, validate, and document JSON config without the common pitfalls.
CloudEvents: The JSON Standard for Event-Driven Systems
How CloudEvents standardizes event payloads across AWS, Azure, Google Cloud, Kafka and Knative — the required fields, the JSON envelope, and why it exists.
JSON Canonicalization (JCS): Making JSON Byte-for-Byte Reproducible
Why the same JSON data can hash differently on different systems, and how RFC 8785's JSON Canonicalization Scheme fixes it for signatures, caching keys and content addressing.
Change Data Capture: JSON Events with Debezium & Kafka
How Change Data Capture turns database row changes into JSON events — the Debezium payload shape, before/after states, and why CDC beats polling.
Web3 JSON: Ethereum JSON-RPC, ABIs & Transaction Receipts
The JSON that powers blockchain development — Ethereum's JSON-RPC calls, contract ABIs, and transaction receipts — explained with real payloads.
JSON for Infrastructure as Code: Terraform & CloudFormation
How Terraform's plan/state files and AWS CloudFormation templates use JSON to describe and track cloud infrastructure — real examples and common pitfalls.
JSON Data Modeling: Designing Schemas for Real-World Applications
Learn best practices for designing JSON data structures: flat vs nested, arrays of objects, ID references, versioning, and common patterns for APIs and databases.
Using JSON in Databases: MySQL, PostgreSQL, and MongoDB
A practical guide to storing, querying, and indexing JSON data in MySQL (JSON column), PostgreSQL (jsonb), and MongoDB — with query examples and indexing strategies for each.
JSON Patch vs JSON Merge Patch: Updating JSON the Right Way
Understand RFC 6902 JSON Patch and RFC 7396 JSON Merge Patch — two standards for describing and applying partial updates to JSON documents in REST APIs, with real code examples.
NDJSON and JSON Lines: Streaming Large JSON Datasets
Learn how NDJSON (Newline Delimited JSON) and JSON Lines format solves the problem of streaming and processing large JSON datasets — with examples in Node.js and Python.
JSONPath: Query JSON Data Like a Pro
Master JSONPath syntax with practical examples. Learn dot notation, wildcards, filters and recursive descent to extract any value from nested JSON.