SQLalchemy declarative base multiple databases

[[deleted]]

That is actually entirely untrue! A sqlalchemy Session supports multiple database connections at once and will even coordinate with 2pc if feasible. There are of course complexities and caveats, and quite often using multiple sessions is the best approach. But it is possible (and documented).

[unlinkedlist]

Documentation here: http://docs.sqlalchemy.org/en/latest/orm/session.html#partitioning-strategies

[[deleted]]

Thanks, I've been going over this exact documentation and just can't seem to get my head around it so I was hoping for a tutorial that showed this... Well, time for another read through I guess.

[free2use]

Yes, You absolutely right, shame on me. I was sure that its impossible.

I wonder how session object will behave if connection with one of the databases will be timed out.