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 ~ m...@livecode.com ~ http://www.livecode.com/
LiveCode: Build Amazing Things
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode