Re: sqLite delete memory database
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 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 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@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@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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: sqLite delete memory database
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 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@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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: sqLite delete memory database
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-livecode < use-livecode@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@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@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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- Tom Glod Founder & Developer MakeShyft R.D.A (www.makeshyft.com) Mobile:647.562.9411 ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: sqLite delete memory database
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 > 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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: sqLite delete memory database
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, 2020, at 6:43 PM, Bob Sneidar via use-livecode > 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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
sqLite delete memory database
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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode