memory databases fail in Windows

Richard Gaskin ambassador at
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 

  Richard Gaskin
  Fourth World Systems
  Software Design and Development for the Desktop, Mobile, and the Web
  Ambassador at      

More information about the Use-livecode mailing list