Hi! I am trying to figure out the best practice about making admin API. I have a frontend with a comment system. The users can see verified comments and post comments and replies. Now I am building the admin section where I can approve the comments. I would like to separate these controls to a different database so i can get a clean database for the frontend tasks (users) and one for admin tasks.
I know there is currently no way to make this work multi-tenant.
But i was wondering if there could be a way to seperate admin udfs from users udfs?
Aslo do anyone has a best practice to do something like that? In terms of roles and databases.