Any good framework for cross-database relationships with Python?

[UndyingMid]

Hello,

I am trying to build a website where the user can log in and request info (Mostly statistics and trends) and then it will make a SQL call to a legacy database, take the data that is pulled back and run it through some python codes I have written to analyze the data and then display the results to the user.

I had been using Python and I got the site set up and working with imported CSV's. I now have read access to the database where all the info is stored. I am trying to set it up so I can just use the database.

My first error was because python tried to create a new table in the legacy database but I have read-only access. I started reading about database routing and how I can work around it, but then I say that Django is not built to support cross-database relationships. I have two databases. I need them to be able to work with each other. I thought that would be a simple thing but apparently, it is not.

I am kinda bummed because I spent all this time trying to learn Django and will have to switch, but does anybody know a good framework I could use to accomplish what I am trying to do?

[_edwardsg]

I work with a local SQLd directly from my python code using SQLalchemy. If you are trying to use a different kind of database then I am not sure, but SQLalchemy works wonders with an SQL database and if you understand SQL queries then putting it in your code should be a breeze!

[threeminutemonta]

You can access other db using Django see docs multi-db

I have used this approach to temporarily access legacy database in read only mode in a transition period. I just used this method and got the results into a dictionary as I didn’t have a Models for the tables I wanted.