~/talk

JSON Support: news, non-news, and the bigger picture

Talkat FOSDEM 2021 · on Saturday, 2021-02-06· at 14:20· D.mariadb· [databases]

speaker

name:Sergei Petrunia

website:http://petrunia.net/

resources

video:https://youtu.be/ZkmwHPqA790

slides:https://fosdem.org/2021/schedule/event/mariadb_json/attachments/slides/4614/export/events/attachments/mariadb_json/slides/4614/mariadb_json_fosdem2021.pdf

summary

MariaDB adds JSON_TABLE (targeted for 10.6), a table function that unnests JSON into rows with nested-path support, error-handling on conversion, and lateral joins but omits the PLAN clause MySQL also skips. JSONPath support is lax mode only, supports single-index array access (no LAST or M-to-N) and lacks filters; both servers implement a recursive wildcard $ recursive search for deep lookups. Low-hanging contributions: add LAST/M-to-N indexing, implement filtering, and improve JSON_DETAILED pretty-printing.

AI-written summary · about

chapters (6)

related talks