SQLite releases JSON features

[ShaunR]

SQLite has added the json1 extension module in the source tree. It implements eleven SQL functions and two table-valued functions that are useful for managing JSON content stored in an SQLite database.

 

This is a huge feature feature improvement that effectively allows transparent queries of embedded JSON strings in the DB and will be of special interest to LabVIEW web enabled applications with SQLite back-ends for direct to DB insertions and remote queries. It achieves an impressive pars speed of over 300 MB/s (allegedly)

Edited October 19, 2015 by ShaunR

[ShaunR]

This is awesome.

 

How much of a pain in the backside WAS flattening JSON objects so we can deal with them as self indexing arrays or name/value tables?

 

 

And we can filter them on the fly too.

 

 

 

How easy is that?

Edited October 21, 2015 by ShaunR