{"id":3656,"date":"2024-10-25T13:40:55","date_gmt":"2024-10-25T06:40:55","guid":{"rendered":"https:\/\/www.sqlitetutorial.net\/?page_id=3656"},"modified":"2024-10-25T13:40:57","modified_gmt":"2024-10-25T06:40:57","slug":"sqlite-json_pretty-function","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-json-functions\/sqlite-json_pretty-function\/","title":{"rendered":"SQLite json_pretty() Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the SQLite json_pretty()<\/code> function to make JSON human-readable.<\/p>\n\n\n\n

Introduction to the SQLite json_pretty() function<\/h2>\n\n\n\n

The json_pretty()<\/code> function works like the json()<\/a> function but makes the JSON value prettier. This means that the json_pretty()<\/code> function adds extra whitespace to make the JSON value more human-readable.<\/p>\n\n\n\n

Note that SQLite added the json_pretty() function since version 3.46.0 on May 23, 2024.<\/p>\n\n\n\n

Here’s the syntax of the json_pretty()<\/code> function:<\/p>\n\n\n

json_pretty(json_value, format)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax:<\/p>\n\n\n\n
    \n
  • json_value<\/code> is a valid JSON value to format.<\/li>\n\n\n\n
  • format is an optional argument used for indentation. If you omit the second argument or use NULL<\/code>, the function will use four spaces to indent each level.<\/li>\n<\/ul>\n\n\n\n
    SQLite json_pretty() function examples<\/h2>\n\n\n\n
    The following example uses the json_pretty()<\/code> function to format a JSON value:<\/p>\n\n\n
    SELECT<\/span> json_pretty('{\"name\": \"Alice\"     ,\"age\" : 25 , \"address\": {\"street\": \"101 N 1st Street\", \"city\": \"San Jose\"} }'<\/span>);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    {\n    \"name\": \"Alice\",\n    \"age\": 25,\n    \"address\": {\n        \"street\": \"101 N 1st Street\",\n        \"city\": \"San Jose\"\n    }\n}<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    In this example, we do not use the second argument, the indentation is four spaces per level.<\/p>\n\n\n\n
    Like the json()<\/code> function, the json_pretty<\/code> function validates the JSON value before formatting it:<\/p>\n\n\n
    SELECT<\/span> json_pretty('{\"name\": \"Alice\" \"age\" : 25}'<\/span>);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    Runtime error: malformed JSON<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    If you want the indentation to be one space per level, you can pass a space character to the second argument of the json_pretty()<\/code> function like this:<\/p>\n\n\n
    SELECT<\/span> json_pretty('{\"name\": \"Alice\"     ,\"age\" : 25 , \"address\": {\"street\": \"101 N 1st Street\", \"city\": \"San Jose\"} }'<\/span>,' '<\/span>);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    {\n \"name\": \"Alice\",\n \"age\": 25,\n \"address\": {\n  \"street\": \"101 N 1st Street\",\n  \"city\": \"San Jose\"\n }\n}<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Summary<\/h2>\n\n\n\n
      \n
    • Use SQLite json_pretty()<\/code> function to make a JSON value prettier by formatting it to make it more human-readable.<\/li>\n<\/ul>\n
      \n\t
      \n\t\t
      Was this tutorial helpful ?<\/div>\n\t\t
      \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
      \n\t\t
      \n\t\t\t
      <\/div>\n\t\t\t\n\t\t\t