Amazing. Awesome. Well, but what is it? We could store json data in Pg since PostgreSQL 9.2 – so it's been there for over 12 years now. How is the new shiny thing different? What does it allow you to do? Let's see if I can shed some light on it… For starters: SQL/JSON is … Continue reading "SQL/JSON is here! (kinda “Waiting for Pg 17”)"| select * from depesz;
About| theory.github.io
Link: https://theory.github.io/sqljson/ Based on the recently-released Go [JSONPath] and [JSONTree] playgrounds, I've updated the design and of the [SQL/JSON Playground][play]. It now comes populated with sample JSON borrowed from [RFC 9535], as well as a selection of queries that randomly populate the query field on each reload. I believe this makes the playground nicer to start using, not to mention more pleasing to the eye. The playground has also been updated to use the recently-released ...| Just a Theory