Data Persistence

Mike Bonner bonnmike at gmail.com
Mon Jul 30 17:19:12 CEST 2018


Doh. Been a bit since I did it. Its-- ATTACH DATABASE pathtodb.db as dbname

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

> 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
>>>
>>


More information about the use-livecode mailing list