Livecode SQLite

[Pi Digital]

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