Which sqlite?

[Mark Waddingham]

On 2023-04-15 12:13, Neville Smythe via use-livecode wrote:
> Is it possible to direct LC to use a custom version of sqlite3 rather 
> than its default?
> 
> I ask because the installed version of sqlite which come installed with 
> macOS, and which I assume LC uses when it initialises its database 
> library, is crippled ---arithmetic functions which come with the 
> standard augmentation of sqlite (such as floor(), log() etc) are not 
> enabled, similarly regular expressions are not enabled. It is easy 
> enough to install a more capable version of sqlite on the Mac, but I 
> don’t see a way to get LC to use it.  Possibly there is an environment 
> variable or an initialisation handler which can be edited? (Note that 
> Apple goes to some lengths to make it difficult to overwrite the 
> installed sqlite in the system, and such a change would be lost on the 
> next os update anyway.)
> 
> If LC is using its own built-in sqlite and dylib rather than the 
> os-provided package, then is there a way to update that to one own 
> version?

The version of sqlite we use is compiled in to the dbsqlite driver and 
thus is independent of any installed libraries. We've already got a 
pending request (https://quality.livecode.com/show_bug.cgi?id=24051) to 
update it to a newer version so if you just drop a note on there 
reminding us to enable the math functions and REGEXP extension then 
we'll enable those at the same time.

The update will likely go into the next 9.6 maintenance release 
(9.6.10), and also appear in a subsequent 10dp.

Warmest Regards,

Mark.

-- 
Mark Waddingham ~ mark at livecode.com ~ http://www.livecode.com/
LiveCode: Build Amazing Things