[sqlite] Creating & Dropping memory databases

2016-03-09 Thread Dan Kennedy
On 03/09/2016 12:48 AM, Simon Slavin wrote: > On 8 Mar 2016, at 4:35pm, Dan Kennedy wrote: > >> I don't think it does that. sqlite3_shutdown() is for embedded platforms to >> shutdown sub-systems initialized by sqlite3_initialize(). Calling it with >> open connections will usually either leak

[sqlite] Creating & Dropping memory databases

2016-03-08 Thread Dan Kennedy
On 03/08/2016 09:14 AM, Simon Slavin wrote: > On 8 Mar 2016, at 2:10am, Stephen Chrzanowski wrote: > >> Out of curiosity, from a memory management standpoint, if I create a memory >> database, populate simple tables and such, to what falls the responsibility >> with cleaning up the memory used?

[sqlite] Creating & Dropping memory databases

2016-03-08 Thread Simon Slavin
On 8 Mar 2016, at 4:35pm, Dan Kennedy wrote: > I don't think it does that. sqlite3_shutdown() is for embedded platforms to > shutdown sub-systems initialized by sqlite3_initialize(). Calling it with > open connections will usually either leak resources or crash. > > More here:

[sqlite] Creating & Dropping memory databases

2016-03-08 Thread Simon Slavin
On 8 Mar 2016, at 2:10am, Stephen Chrzanowski wrote: > Out of curiosity, from a memory management standpoint, if I create a memory > database, populate simple tables and such, to what falls the responsibility > with cleaning up the memory used? > > Will SQLite handle :memory: databases

[sqlite] Creating & Dropping memory databases

2016-03-07 Thread Stephen Chrzanowski
Thanks gents. It is all handled internally by SQLite. Good enough. On Mon, Mar 7, 2016 at 9:14 PM, Simon Slavin wrote: > > On 8 Mar 2016, at 2:10am, Stephen Chrzanowski wrote: > > > Out of curiosity, from a memory management standpoint, if I create a > memory > > database, populate simple

[sqlite] Creating & Dropping memory databases

2016-03-07 Thread Richard Hipp
On 3/7/16, Stephen Chrzanowski wrote: > Out of curiosity, from a memory management standpoint, if I create a memory > database, populate simple tables and such, to what falls the responsibility > with cleaning up the memory used? > > Will SQLite handle :memory: databases internally, flushing out

[sqlite] Creating & Dropping memory databases

2016-03-07 Thread Stephen Chrzanowski
Out of curiosity, from a memory management standpoint, if I create a memory database, populate simple tables and such, to what falls the responsibility with cleaning up the memory used? Will SQLite handle :memory: databases internally, flushing out the tables from memory? Does my application