Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28272

JSON functions should create compact format by default

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: JSON
    • Labels:
      None

      Description

      It seems strange to me that JSON functions create loose/non-compact json by default. People would choose the compact format for maximum performance, and if you need to make an extra function call (JSON_COMPACT()), it will kill some of the advantage. Furthermore there should be a minor performance gain in not adding spaces in the first place.
      JavaScript's JSON.stringify() also makes the compact format by default. For those who prefer "looser" formats, they still have the JSON_LOOSE and JSON_DETAILED functions, so why not make the JSON_COMPACT the default? At least there could be a server option to select the preferred format.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            tgj1970 Thomas G. Jensen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.