Re: Which sqlite?
That is excellent news Mark, thank you. Mark Waddingham wrote... > > 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. > That is excellent > Thanks to this list, I know about "do in widget" that can cause some > javascript to be evaluated in the current page in the browser widget. Which > is > great. > ___ 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
Re: Which sqlite?
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
Re: Which sqlite?
neville noticed, >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. It seems to me that several years ago I briefly used an external SQLite, but I cannot remember how I started with mysql (on livecode’s server, come to think of it, or was it still runrev?), but performance was beyond molasses, as livecode cannot do a compound query on mysql. I shifted to hosting my own postgreSQL, and then (if I have the order straight) switched from an array of variables to the included SQLite for local storage, updating periodically. The problem with trying to use the Mac-supplied databases is that they sometimes change without notice. I started using the internal postgres, and then, one day, my whole system suddenly stopped working. It turned out that apple had changed major postgres releases on a minor maintenance release. And the postgres's weren’t compatible with one another! I had to install an older postgres to export my data, and at that point stayed with running my own postgres. If you’re going to use the built-in, you need to be *very* careful. ___ 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
Which sqlite?
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? Neville Smythe ___ 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