Search Values of Array in "One Go"

Mike Bonner bonnmike at gmail.com
Wed Aug 23 20:47:37 EDT 2017


I think you need to use ":memory:" as the name actually.  It looks (from
the sqlite docs) that supplying no name creates a temporary db file.
And now i'm curious.. Is there a way to attach the file based db to a
memory db?

IE Open the file database, then use the info here:
https://www.sqlite.org/lang_attach.html and attach a memory database.

Then (way over my head, but I seem to recall reading somewhere..) that one
can use the results of a select to create a temporary table..  If
interested, you might look here under create table as select...
http://sqlite.org/lang_createtable.html

On Wed, Aug 23, 2017 at 6:31 PM, Sannyasin Brahmanathaswami via
use-livecode <use-livecode at lists.runrev.com> wrote:

> 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-bounces at lists.runrev.com on behalf of
> use-livecode at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



More information about the Use-livecode mailing list