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