[Ann] xaLib - library to extract data from an array.

Bob Sneidar bobsneidar at iotecdigital.com
Wed Apr 18 11:07:35 EDT 2018


Thanks Alex. Couple questions: 

Does this convert to an SQL database? If so, are there commands for ordering? 

The advantage to converting to a memory based sqLite database is that there are features unique to SQL, like relational queries and sorting by multiple columns that you cannot get by simply extracting matching keys. The downside *might* be the time it takes to convert, but it's one pass through the array (or arrays), which I assume you are having to do anyway. 

I use a memory database, but of course you wouldn't have to. Any SQL database would work but memory makes it so much faster, so long as the array size is not humongous. 

Bob S


> On Apr 18, 2018, at 07:00 , Alex Tweedly via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> So, I was tempted too :-)
> 
> But I decide there was no need for the complexity of xquery, and it was better to keep it simple, along the lines of Andre's DBLib, or revIgniter's Database lIbrary.
> 
> Hence : xaLib  - eXtract from an Array Library
>    which can be found (I hope) at github.com/alextweedly/xalib





More information about the Use-livecode mailing list