I'm new to Wix! Please forgive my ignorance. I'm trying to retrieve data from an external MySQL DB. I first approached the task by creating a back end "web module" on Wix using Node.js. I was able to install the node MySQL package and successfully connect to the external DB.
However, I've since been advised that this is not the smartest or safest way to go about doing this since credentials are exposed on the client side. Does anyone have suggestions for how this can be achieved?
I just want to make sure my efforts are being spent pursuing the correct approach. I've heard mention of creating an API on my DB and consuming on Wix via HTTP requests? This is new to me and I would have to research this but if it the preferred method then I will certainly look into.