How I Created a Database of Flight Ticket Prices and Send Myself the Cheapest Flights Weekly
Collecting flight ticket prices from the Internet, storing them in a DB, and sending a message via WhatsApp.
Introduction
As a Brazilian guy living in the USA, I have to search for flight tickets every once in a while.
On the other hand, as a Data Scientist with some coding skills, I also like to create new personal projects to test modules, try new tools that I learn, and keep my skills sharp.
That is how I came up with the idea of creating a project to search for flights between the USA and Brazil. But I wanted something else. I wanted to keep those records to be able to analyze them in the future when I have enough data, to check when the prices decrease, or how long before the flight is the best time to purchase a ticket. If possible, I also would like to send some information about the search to my phone.
That said, let’s move on and define the problem that needs to be solved in the project.
Problem
The problem can be simply defined as follows.
Get weekly flight prices and store them in a relational DB.
