I want to connect my django project to 2 diffrent databases, one of them is MS-SQL with read-only access and the other is a PostgreSQL with full access
what I want to do is read from the MS-SQL by using celery beat and write the aggrigated data on the Postgres
what is the best solution to update my Postgres DB with the most performance?
What is the most sample way which is already said in django documentation is this:
https://docs.djangoproject.com/en/5.0/topics/db/multi-db/
I want to know that is if i use router.py file is better of just create an API which I read the some functions as a python script which are contatains the SQL query and insert or update them into the PostgreSQl
What is the best solution?