a connection to an in-memory sqlite database is unique to itself; theres no way to connect to it twice. when using SQLite, all connections within a particular thread are using the same "thread local" connection (i.e. it uses the SingletonThreadPool by default), so in your example above the two Connection objects reference the same underlying pysqlite connection instance.
if you want to see it use the regular connection pool, send the sqlalchemy.pool.QueuePool class to the create_engine's "pool_class" argument. youll see it fails pretty badly with "memory:" (and as i recall doesnt work so great with file-based databases either but i havent tried in a long time). --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
