This is not the usual Waiting for post, but something should be said. Back in March/April of 2022 Andrew Dunstan committed a series of patches that added support for lots of really interesting features from SQL/JSON standard. While I’m not avid user of json in database, I was very, very happy. Wrote couple of blogposts … Continue reading “Waiting for …: SQL/JSON is coming back. Hopefully.”
Back in March and April I wrote couple of blogposts about upcoming new great feature – full SQL/JSON. Unfortunately, as of today SQL/JSON has been reverted (removed from sources), both from development version 16, but also from “almost ready” version 15. There is lengthy discussion about it which you can definitely read if you’re so … Continue reading “SQL/JSON is postponed”
On 8th of April 2022, Andrew Dunstan committed patch: Documentation for SQL/JSON features This documents the features added in commits f79b803dcc, f4fb45d15c, 33a377608f, 1a36bc9dba, 606948b058, 49082c2cc3, 4e34747c88, and fadb48b00e. I have cleaned up the aggregate section of the submitted docs, but there is still a deal of copy editing required. However, I thought … Continue reading “Waiting for PostgreSQL 15 – Documentation for SQL/JSON features”
On 4th of April 2022, Andrew Dunstan committed patch: JSON_TABLE This feature allows jsonb data to be treated as a table and thus used in a FROM clause like other tabular data. Data can be selected from the jsonb using jsonpath expressions, and hoisted out of nested structures in the jsonb to form multiple … Continue reading “Waiting for PostgreSQL 15 – JSON_TABLE”
On 29th of March 2022, Andrew Dunstan committed patch: SQL/JSON query functions This introduces the SQL/JSON functions for querying JSON data using jsonpath expressions. The functions are: JSON_EXISTS() JSON_QUERY() JSON_VALUE() All of these functions only operate on jsonb. The workaround for now is to cast the argument to jsonb. JSON_EXISTS() tests … Continue reading “Waiting for PostgreSQL 15 – SQL/JSON query functions”
On 28th of March 2022, Andrew Dunstan
On 27th of March 2022, Andrew Dunstan committed patch: SQL/JSON constructors This patch introduces the SQL/JSON standard constructors for JSON: JSON() JSON_ARRAY() JSON_ARRAYAGG() JSON_OBJECT() JSON_OBJECTAGG() For the most part these functions provide facilities that mimic existing json/jsonb functions. However, they also offer some useful additional functionality. In addition to text input, the … Continue reading “Waiting for PostgreSQL 15 – SQL/JSON constructors”
On 17th of January 2022, Michael Paquier committed patch: Introduce log_destination=jsonlog "jsonlog" is a new value that can be added to log_destination to provide logs in the JSON format, with its output written to a file, making it the third type of destination of this kind, after "stderr" and "csvlog". The format is convenient … Continue reading “Waiting for PostgreSQL 15 – Introduce log_destination=jsonlog”
Added two new functions, which basically work only for JSON / YAML / XML plans. First – the view of source explain is now syntax highlighted. Just click source button on one of these to see: JSON YAML XML Next additon is text tab, which shows the same explain but converted to text-format. Hope you’ll … Continue reading “More functions for json/yaml/xml plans on explain.depesz.com”
On 16th of March 2019, Alexander Korotkov committed patch: Partial implementation of SQL/JSON path language SQL 2016 standards among other things contains set of SQL/JSON features for JSON processing inside of relational database. The core of SQL/JSON is JSON path language, allowing access parts of JSON documents and make computations over them. This commit … Continue reading “Waiting for PostgreSQL 12 – Partial implementation of SQL/JSON path language”