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@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 _______________________________________________ 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
