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 have to handle dropping the tables before actually closing the connection?
