wonder if active record couldn’t borrow some pattern from coredata with its managedobjectcontext property associated to every object. This lets you work with objects transparently, not having to carry a « db » property everywhere, and the framework always knowing where the object come from, it can trigger an error if you’re trying to do something unholy by mixing them.
I bet it would not be very hard to write that as an extension for proof of concept. There have been some good flexible operations added for multi-database stuff in activerecord over the past couple versions.
