Livecode SQLite

[Mark Waddingham]

On 2022-08-11 16:16, Tom Glod via use-livecode wrote:
> I was interested in implementing a relatively new feature where you can
> index and query json documents and read the keys directly.
> 
> https://dgl.cx/2020/06/sqlite-json-support
> 
> I guess, if this is true, is there any documentation about which 
> features
> of sqlite are implemented and which are not?

The version of SQLite is currently 3.34 built with FTS3, 
FTS3_PARANTHESIS, FTS4, FTS5, RTREE and JSON1 options.

So the JSON features (at least as far as those included in 3.34) should 
be included - perhaps the queries you are trying rely on features 
(perhaps not JSON related) included in more recent versions?

If you file a bug report with what examples of what isn't working, then 
we'll look into updating to the latest version of the library.

Warmest Regards,

Mark.

-- 
Mark Waddingham ~ mark at livecode.com ~ http://www.livecode.com/
LiveCode: Everyone can create apps