memory databases fail in Windows
Richard Gaskin
ambassador at fourthworld.com
Tue Apr 3 16:12:39 EDT 2018
Bob Sneidar wrote:
>> On Apr 3, 2018, at 11:38 , Richard Gaskin wrote:
>>
>> What is the goal?
>>
>> Arrays and memory-based SQLite are both in-memory stores with hashed
>> access. I'm guessing there's something more to this use-case than my
>> limited thinking currently grasps.
>
> You would be correct. :-)
>
> I posted a little while ago that I wrote some code to gather certain
> properties of all the objects on a card into an array. Converting that
> array into a memory database allows me to find all the objects that
> are for example, visible and groups and then get the top, left, bottom
> and right of each of these objects (because I passed those in a list
> to the thing that generates the array).
>
> Essentially it's for finding things in an array. You might say I could
> do the same thing by iterating through all the elements of an array,
> but what if I wanted to do multiple queries? It's easier for me to
> write SQL queries than it is to code repeat loops.
I hear ya'. I find myself tempted way more than I have time for to
write an xquery-like library for working with arrays. We could sure use
one.
--
Richard Gaskin
Fourth World Systems
Software Design and Development for the Desktop, Mobile, and the Web
____________________________________________________________________
Ambassador at FourthWorld.com http://www.FourthWorld.com
More information about the use-livecode
mailing list