[Request]: multiple database connection

[johnzakariasabry]

Summary

i want to create another database in same project to use it, but i dont know how i can make it

Why is it needed?

it is needed because i will have a huge table and i dont want it to be in my database on front end

i only need it in back end section

Suggested solution(s)

No response

Related issue(s)/PR(s)

No response

[jsanta]

Don't know if it may solve your problem, but in the database config file you can add a schema parameter that uses an environment variable. That should connect to a different schema in your database and use it instead of creating all tables in th public schema (default). I think Strapi won't be able to create neither new schemas or databases by itself so you will have to do those tasks by hand directly to the database using a DB ide or SQL commands.

[pwizla]

Hi. I'm sorry you didn't get any reply to this issue sooner. I'm cleaning up old issues in this repository and I will close this one. Community user jsanta properly described how it should be handled and this is a bit outside the scope of the core Strapi documentation. Feel free to open another issue in this repo or ask for help on the forum if you still encounter the problem.