website idea

  • use flightradar api for in out flight data

  • flight price api to determine/highlight cheap destinations

reddit recommended rapidapis

solution architecture

  1. free soln, using aws lambda to crawl data, feed into some data store,
  2. use dbt to transform feed into store / fixated view using athena
    1. the export data store in public s3 bucket will be place behind CDN/API Gateway to rate limit public access.
    2. https://stackoverflow.com/questions/53703781/how-can-i-rate-limit-aws-s3-bucket-access
  3. point hosted power bi /plotly dashboard to store
    1. power bi free account should be able to publish to web from inside the default My Workspaces