Working with JSON

1. JSON for Humans & Machines

JSON strikes a balance between readability and efficiency, making it ideal for both developers and systems.

2. Formatting & Compacting

JSON can be formatted for readability or compacted to reduce size. Compacting removes whitespace, which helps reduce bandwidth usage and improves performance.

{
  "name": "JSONFriend",
  "active": true
}

{"name":"JSONFriend","active":true}

In production systems like APIs, compact JSON is preferred to minimize payload size and speed up data transfer.

3. Validating JSON

JSON must follow strict syntax rules. Even small mistakes like missing commas or incorrect quotes can break parsing.

    {
  "name": "Invalid JSON"
  "missingComma": true
}
  

Validation tools help detect and fix errors before the data is used in applications.

4. Editing JSON

JSON is often edited to update values, add fields, or remove unnecessary data.

    {
  "name": "JSONFriend",
  "active": true,
  "tags": ["tools", "json", "api"]
}
  

Editing is common when working with APIs, configuration files, and user data.

5. Converting JSON to Other Formats

JSON is often converted into other formats depending on system requirements and tools.

Conversion helps integrate JSON data across different platforms and tools.

6. Parsing & Stringifying

Applications convert JSON strings into objects and back when sending or storing data.

const obj = JSON.parse('{"key":"value"}');

const str = JSON.stringify(obj);

7. Transforming JSON

Transformation involves reshaping data by filtering, mapping, or extracting specific values.

    {
  "users": [
    { "name": "Alice", "age": 25 },
    { "name": "Bob", "age": 30 }
  ]
}
  

8. Using JSON in Databases

JSON is widely used for storing structured and semi-structured data in modern databases. Many databases support JSON as a native type.

    {
  "name": "JSONFriend",
  "active": true,
  "tags": ["tools", "json", "api"]
}
  

    SELECT data->>'name' AS name
FROM users
WHERE data->>'active' = 'true';
  

9. Common Use Cases