Re: sqLite delete memory database

2020-05-01 Thread JB via use-livecode
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 > wrote: > > Is there an LC function that clears trash from memory? Does "hasMemory"? If > not, it seems like t

Re: sqLite delete memory database

2020-05-01 Thread Phil Davis via use-livecode
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: hmmmyou can try set the pragma to zero out flag (i am pretty sure there is one) .. and drop all tabl

Re: sqLite delete memory database

2020-05-01 Thread Tom Glod via use-livecode
hmmmyou 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-liveco

Re: sqLite delete memory database

2020-05-01 Thread JB via use-livecode
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 data

Re: sqLite delete memory database

2020-04-30 Thread JB via use-livecode
I am not saying I know how to do it but are you able to read the memory like you can with a regular variable? If so maybe you can just assign each block of memory a null character. If you actually can get the memory address of the data it would be easy to delete it using C code. JB > On Apr 30