I have a mysql database hosted on another domain, it is my understanding that mysql can be remotely accessed by another script if the ip of other website is added to the cpanel.
Could a Bubble app remotely access some data(securely) I have hosted somewhere else and output it in the app itself?
I don’t think so. I would imagine you have to build a API that reads from mysql and somehow connects back to bubble or writes to it. Of course this depends on what you trying to achieve. Take a look at zapier it has some zaps that work with mysql. Or just build your own using zapier or a custom block on blockspring.
Thanks for the reply!, I will check Zapier
Blockspring would be the way to make it synchronous. So like a “read”. But it doesn’t connect to mysql as far as I can tell. Works with Postgres however.
Zapier can certainly connect to mysql and can do a search. But you would have to make it an asynchronous call. Zapier zaps just trigger, they don’t get anything back.
You would need to have a multi step zap to then do a POST back into Bubble and trigger a workflow.
So…it might be possible. But would take a bit of thought.
We just launched it!
I have a business directory online and would like to pull the details of the directory into Bubble.
My first question would be, if I pull let’s say 50 businesses pictures, address in one query, how many workflows this will be taking?
Will Bubble cache the data or will bubble have to each time pull the new query everytime there is a user search?
Finally, when bubble will be on the Android Market, how will the data be transmitted from a remote mysql into a bubble app that could perhaps download the new data each time the mobile goes online?
hello, do you have any plugin to connect mongoDB database? Thanks