Xojo SQLite and json extensions

Databases
1

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) ?

2

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

3

Thanks Norman.

4

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

I filled a Feedback case to ask for it : <https://xojo.com/issue/45996>

5

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.

6

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

7

[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.

8

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

9

Thanks @Paul Lefebvre !

10

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