In this part, we are going to create a free-tier AWS RDS instance and write a script to connect this database by using the RPostgreSQL library. After writing this script, we will create a cronjob that automatizes web scraping and sending data to the database based on the scheduled time.
Storing data and creating schedule jobs for web scraping
Creating an AWS RDS Instance
Let's take a look at how to create the PostgreSQL database on AWS. In this section, we will talk about how to create an AWS account and how to create an RDS instance step by step:
- First, visit the AWS page by using the following URL: https://aws.amazon.com/
- Then click My Account to go to the login screen, as shown in the following screenshot:
AWS...