PyDbLite, a small in-memory database engine (Python recipe) by Pierre Quentel A small, fast, in-memory database management program The database object supports the iterator protocol, so that requests can be expressed with list comprehensions or generator expressions instead of SQL. The equivalent of : cursor.execute("SELECT name FROM table WHERE age=30") rows = cursor.fetchall() is : rows = table(