mitsuhiko/flask-sqlalchemy — pull request #227 by chason (2014-10-17 02:38:04+00:00)
Title: Use StaticPool when SQLite database is :memory:

When SQLite database is memory, any changes will be lost after db is committed unless pool is set to StaticPool.
Reference: http://docs.sqlalchemy.org/en/rel_0_8/dialects/sqlite.html#using-a-memory-database-in-multiple-threads