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).

This works but has significant limitations compared to SQLite's native TCL testing approach. SQLite's test suite uses a TCL interpreter with SQLite compiled in as a native extension, providing direct ...