Yep… I just found that too. and related 4-yr old discussion
http://use-livecode.runrev.narkive.com/ntBLeXGM/relative-performance-of-two-dimensional-array-and-in-memory-sqlite-database What I don't get is "don't give it a name" open/create in memory, but the data is on SQLite dbase on disk, so you *have* to read it one way or another. (scratch his head…) On 8/23/17, 2:13 PM, "use-livecode on behalf of Alex Tweedly via use-livecode" <use-livecode-boun...@lists.runrev.com on behalf of use-livecode@lists.runrev.com> wrote: On 24/08/2017 01:04, Sannyasin Brahmanathaswami via use-livecode wrote: >2) "create an in-memory SQLite Database." > > this is news! Where do we find docs on this? right now the SQLite data base is in > > specialFolderPath("documents")/jnanam.sqlite > >how do you "create in memory? > > According to an old message (i.e. I've not tried it :-): On Fri, Jun 15, 2012 at 5:21 PM, Bob Sneidar <bobs at twft.com <http://lists.runrev.com/mailman/listinfo/use-livecode>> wrote: //>//>/On Jun 15, 2012, at 4:13 PM, Mike Bonner wrote: />//>/ > Don't specify a database name and it will open the db in memory. />/ > />/ > get revopendatabase("sqlite",,,,,,) --not sure how many commas off the />/top />/ > of my head. />/ > />/ > On Fri, Jun 15, 2012 at 5:08 PM, Bob Sneidar <bobs at twft.com <http://lists.runrev.com/mailman/listinfo/use-livecode>> wrote: />/ > />/ >> I am just certain that I read on this forum that you could create an />/ >> sqLite database in memory! But when looking through the dictionary and />/in />/ >> the LiveCode lessons there seems to be no mention of how! Can someone />/point />/ >> me to the right docs for this? />/ >> />/ >> Bob />/ >> />/ >> / _______________________________________________ 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
