Change tests to use SQLite in-memory with a shared cache

[mtlynch]

There's a race condition documented in the mattn/gosqlite driver where multiple clients of the DB pool can get separate copies of the database and have distinct views. Using a shared cache works around this issue.