Livecode SQLite

[Tom Glod]

Hey Mark, I'm using very simple examples to run it, so I don't think its my
query, but you are eight I shouldreport this. This would be really great to
have. Esp since  almost everything is json these days.
I will report it in the next few days. Thanks,

On Fri, Aug 12, 2022 at 12:57 AM Mark Waddingham via use-livecode <
use-livecode at lists.runrev.com> wrote:

> 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
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>