Im currently working on a project that requries me to scrape tweets using one of Apify’s apps. The data I scrape should automatically be inserted into a mysql database the I should host remotly.
I was able to find an app to suit my needs and provides me with the output I want. However, as a complete beginner, Im not sure what remote db or hosting services I need to use to achieve the connection with my Apify tool.
Apify does provide a way to integrate your app with 3rd party tools but I first need to have a remote DB somewhere and then connect it with the results. Currently my DB is on my local device. So Im not entirely sure where to start and what web hosting services to use in this case.
Here is how I envision it working:
- The app on Apify should be scheduled to run daily (This I know)
- Once the data is acquired, integrate make connection with the remote DB and send data as CSV file
- CSV Data is INSERTED it into a remote Mysql DB
I tried looking at web hosting services like Google Cloud or Azure Database but I got overwhelemed with all the options and configurations.
Abdullah Shebani is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.