Livecode SQLite

Tom Glod tom at makeshyft.com
Thu Aug 11 17:30:43 EDT 2022


Hi Sean,

The SQLite db i want to read json fields from is local.  I know there are
lots of workarounds.

But in link I provided, the premise was using sqlite function to index and
read a jason document's field.

like so:

sqlite> insert into t values(json('{"d":"42"}'));
sqlite> select * from t WHERE d = 42;
{"d":"42"}|42

Thanks Sean, I'm happy you found the help you needed with your email
problem.

On Thu, Aug 11, 2022 at 11:37 AM Pi Digital via use-livecode <
use-livecode at lists.runrev.com> wrote:

> How was you accessing the database? Is it locally based?
>
> The ones I access are stored on a web host server with a cPanel. I have my
> own php I POST my sql request to and receive JSON back. I then use
> JSONtoArray or, recommended, JsonImport encapsulated in a ‘try’ structure
> to convert the data.
>
> To tell the database to respond with json is not done at the LC end but
> must either be set up in the DB itself or, as in my case, whatever is the
> medium for the data, PHP for me.
>
> Sean Cole
> Pi Digital Productions Ltd
>
> eMail Ts & Cs
>
>
> > On 11 Aug 2022, at 16:16, Tom Glod via use-livecode <
> use-livecode at lists.runrev.com> wrote:
> >
> > Hi Folks,
> >
> > I have a question about Livecode's SQLite implementation.
> >
> > Looking at the official SQLite specs there seem to be json related
> > functions.
> >
> > https://www.sqlite.org/json1.html
> >
> > but none of them seem to work using Livecode's driver.
> > I was under the impression we had a full implementation
> >
> > 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?
> >
> > TIA,
> > --
> > Tom Glod
> > _______________________________________________
> > 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
> _______________________________________________
> 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
>


More information about the use-livecode mailing list