to make the sqlite work in-memory, it's got to be connected to ':memory:' dbfile.