On 17/08/2022 11:22 pm, Mike Bayer wrote:
you can query the three databases with one session, docs on that are at
https://docs.sqlalchemy.org/en/14/orm/persistence_techniques.html#simple-vertical-partitioning
you can query the three databases with one session, docs on that are at
https://docs.sqlalchemy.org/en/14/orm/persistence_techniques.html#simple-vertical-partitioning
from there, you can make *really basic* relationships between classes that are
in two databases. as far as how they load, it
On 17/08/2022 10:31 pm, Philip Semanchuk wrote:
Hi Carl,
I have no experience with this so I might be making a poor suggestion, but
Postgres’ foreign data wrappers might help you. They can expose the schema of
other databases, so your Postgres database could be the host for all three
> On Aug 17, 2022, at 3:55 AM, Carl Brewer wrote:
>
>
> I have three databases to work with, a PostgreSQL database on one server, and
> two MySQL databases on another.
>
> I've set up three different engines to connect to and reflect each one, the
> databases and tables within don't have
I have three databases to work with, a PostgreSQL database on one
server, and two MySQL databases on another.
I've set up three different engines to connect to and reflect each one,
the databases and tables within don't have relationships defined in the
databases themselves, there's not a