support JSON diff function

Open wimacke-cyber opened this issue 2 months ago • 1 comments

JSON diffs are supported via DoltHub and CLI. The request is to implement this also via SQL. Advantages would be:

direct access from SQL
can make use of the way large JSON documents are stored in Dolt using Prolley trees. As such, it would potentially improve memory usage / performance for the CLI and DoltHub too, when a large document has a small diff.

Oct 20 '25 07:10 wimacke-cyber

We've discussed this internally. We're not exactly sure what the interface should be. Dolt can produce these fast at scale. We just need a way to output the structured data to the user.

Oct 20 '25 17:10 timsehn

We added the DOLT_JSON_DIFF function. Just as you said, it makes use of the way large JSON documents are stored to improve performance and memory usage of the diff!

You can read about it here: https://www.dolthub.com/blog/2025-11-24-announcing-dolt-json-diff/

Dec 16 '25 08:12 nicktobey