[Zope-dev] zope.sqlalchemy and in-memory sqlite

[Malthe Borch]

With an in-memory engine, I seem to lose track of the tables after the 
first response.

Turn of events:

1. Request comes in
2. Create some tables
3. Add content and commit transaction
4. Query content
5. Return response

Now...

6. New request comes in
7. Query content

(OperationalError) no such table: mytable ...

With a disk-based database, no errors occur. The point of my little 
story line was to illustrate that this does not have anything to do with 
transactions being committed.

\malthe