added a test for persistent transactions on memory resident sqlite databases
* implemented a (somewhat hacky) solution to provide persistent transactions on memory resident sqlite databases