sqLite delete memory database

JB sundown at pacifier.com
Fri May 1 20:42:36 EDT 2020


I think SOLite intentionally fills the memory with
garbage as part of its secure deletion when the
database is closed.

JB


> On May 1, 2020, at 12:39 PM, Phil Davis via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Is there an LC function that clears trash from memory? Does "hasMemory"? If not, it seems like that would be a nice feature.
> 
> Phil Davis
> 
> 
> On 5/1/20 12:25 PM, Tom Glod via use-livecode wrote:
>> hmmm....you can try set the pragma to zero out flag (i am pretty sure there
>> is one) .. and drop all tables on close?
>> 
>> its strange that it does not 'delete' from memory.  Are we sure on
>> this?..... is this dependent on the garbage collector in LC?
>> 
>> 
>> 
>> 
>> 
>> On Fri, May 1, 2020 at 7:14 AM JB via use-livecode <
>> use-livecode at lists.runrev.com> wrote:
>> 
>>> I have been testing SQLite 3 using the command line interface and it
>>> looks to me like SQLite is designed to securely delete the memory of
>>> the database automatically after it closes the database.
>>> 
>>> I could be wrong but if you can’t read the memory it is probably already
>>> securely deleted when the database was closed.
>>> 
>>> JB
>>> 
>>> 
>>>> On Apr 30, 2020, at 6:43 PM, Bob Sneidar via use-livecode <
>>> use-livecode at lists.runrev.com> wrote:
>>>> I can create memory databases, but how do I delete it once created?
>>> revdb_disconnect still leaves it in memory. revCloseDatabase is just a
>>> synonym of revdb_disconnect.
>>>> Bob S
>>>> 
>>>> 
>>>> _______________________________________________
>>>> 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
>>>> 
>>> 
>>> _______________________________________________
>>> 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
>>> 
>> 
> 
> -- 
> Phil Davis
> 503-307-4363
> 
> 
> _______________________________________________
> 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