What I am trying to achieve is that I have an Arduino base which periodically uploads data to AWS IoT-Core. But I am looking for a way to store that data and make it accessible to my web application which is getting developed in the flask.
I want to store the data in a structured manner because I plan to make reports one day from all that data.
Things I looked into:
- I saw a way it stores the data in AWS S3 and using boto3 I can make it accessible from the file.
- Using lambda function to update the IoT core data to the AWS RDS MySQL but still, I was not able to find any satisfactory answer
- Using AWS Amplify and AWS API gateway, which again didn't meet my requirement
- Using API from a third-party application, which again I don't find appropriate in my use-case.
I would really like an insight and open to sugesstions as I am new to IoT part.