With these abstractions you can conveniently define desired structure for an SQLite database including all necessary constraints and data types. Yet you expected to possess some knowledge of SQLite DB ...

sqlite3 rightly complains if a database connection is left open at the end of the program. But it shouldn't if the database is ":memory:", since there's no external resource used in that case (AFAIK).