Data Persistence

[Mike Bonner]

Sorry.. To elaborate, yes you can attach a disk based db to a memory db.
Then you use dot notation to specify which database you're working on.

So it would be a regular attach-- attach pathtodatabase.db as dbname
Then any place you would specify a table name it would be dbname.tablename



On Mon, Jul 30, 2018 at 8:51 AM Mike Bonner <bonnmike at gmail.com> wrote:

> Yes
> <Wait, you can attach a disk based database to a memory database??
>
> On Mon, Jul 30, 2018 at 8:45 AM Bob Sneidar via use-livecode <
> use-livecode at lists.runrev.com> wrote:
>
>> Wait, you can attach a disk based database to a memory database??
>>
>> Bob S
>>
>>
>> > On Jul 27, 2018, at 15:19 , Mike Bonner via use-livecode <
>> use-livecode at lists.runrev.com> wrote:
>> >
>> > On the subject of sqLite/memory databases and preferences/data
>> persistence,
>> > rather than using an array, and doing the encode/decode stuff, would it
>> > make sense to do the following..
>> > 1. open an empty in memory database
>> > 2. attach a disk based database
>> > 3. copy the required table(s) from disk base to memory base
>>
>>
>> _______________________________________________
>> 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
>>
>