Re: [sqlalchemy] Multiple Database Connection

2022-03-22 Thread Mustafa Demiraslan
Yes all of these are a database not schema. Thank you for response. Mike Bayer , 22 Mar 2022 Sal, 18:27 tarihinde şunu yazdı: > a single Engine only points to one database URL at a time. so to that > extent, as an Engine assumes there's a "default database" when it connects, > any concept of

Re: [sqlalchemy] Multiple Database Connection

2022-03-22 Thread Mike Bayer
a single Engine only points to one database URL at a time. so to that extent, as an Engine assumes there's a "default database" when it connects, any concept of multiple "databases" beneath that is not something the Engine is aware of. PostgreSQL itself has no "USE" command, so if you have

Re: [sqlalchemy] Multiple Database Connection

2022-03-22 Thread Mustafa Demiraslan
Current structure is like this: [image: image.png] I can't manage pooling for green colored databases. Mike Bayer , 22 Mar 2022 Sal, 17:12 tarihinde şunu yazdı: > for one engine with 18 databases, what is "switching the bindings" ? do > you mean you call "USE " on the connection ? > >

Re: [sqlalchemy] Multiple Database Connection

2022-03-22 Thread Mike Bayer
for one engine with 18 databases, what is "switching the bindings" ? do you mean you call "USE " on the connection ? creating 18 separate engines would not be that big a deal if that's what works best for the code, no issue doing that. On Tue, Mar 22, 2022, at 9:41 AM, Mustafa Demiraslan

[sqlalchemy] Multiple Database Connection

2022-03-22 Thread Mustafa Demiraslan
Hi team, I am using 3 database engines at the same time, 1(include 1 database) + 1(include 1 database) + 1(include 18 database). I use the database containing 18 databases by switching the bindings. I connect to database using sessions with session_maker for each engine. During the load test, I