add support for a memory option in sqlite config

Minor addition which allows use of in-memory sqlite, which is very useful for unit testing.