While writing a series of articles on how to answer various business questions using SQL, I needed to find public datasets. Wanting to use real data instead of curated Kaggle datasets, I set up my database instances across various cloud platforms. I am sharing these database setup experiences. The first implementation is AWS MySQL.

Why AWS MySQL?

I will start and end any argument with ‘Free Tier.’

AWS is obviously a popular platform. Not every interaction with AWS is a smooth process, though this experience went well.

While the database instance for MySQL worked as expected, the MySQL Workbench leaves much to be desired. My insert SQL file to build the data rows kept freezing up my app. Once the data was loaded, the query performance from the Workbench to AWS and back was reasonably quick.

#database #mysql #data-science #aws