tests with SQLite and other improvements