Xojo SQLite and json extensions

In developer.xojo, I can read: SQLite version used: 3.14.1.

In sqlite.com, I saw: SQL Syntax --> JSON functions.

Apparently, this extension have been added into SQLite 3.9.0 (2015-10-14), 13 months ago.

My question is simple: are these (JSON functions) available in Xojo (2015r3 I suppose) ?

No
The json1 extension is a loadable extension…
Meaning this isn’t compiled in by default

Thanks Norman.

I think this extension could be a great add-on to Xojo.

I filled a Feedback case to ask for it : feedback://showreport?report_id=45996

Honestly ?

I finished my json i/o methods, but I was curious (mostly because I do not recall the sqlite.com note) to know if I wasted my time or not.

Now, it may be more easier to directly deal with SQLite.

You can use MBS SQL Plugin to use built in SQLite library with JSON extension.

[quote=300332:@Norman Palardy]No
The json1 extension is a loadable extension…
Meaning this isn’t compiled in by default[/quote]

@Norm for those that dont have MBS SQLite plugin, with strict Xojo, can you use the json loadable extension?

I have the MBS SQlite plugin but several people dont. and I am just curious for those.

I haven’t tried the JSON extension, but perhaps the SQLiteDatabase.LoadExtensions property can be used with it.

Thanks @Paul Lefebvre !

How to ? (I get an eye there, but I failed to understand / I am in a hurry for a job).