My Requirments:
- I want to store
real-time events data
coming frome-commerce
websites into a database - In parallel to storing the data, i want to
access the events data
from a database - I want to perform some sort of
ad-hoc analysis(SQL)
- Using some sort of
built-in methods(either from Boto3 or JAVA SDK)
, I want to access the events data - I want to create some sort of
Custom-API's
to access events data stored in database
I recently came across with Amazon Aurora(mysql) database.
I thought Aurora
is one of the good example for my requirements. But when I dig into this Amazon Aurora(mysql), I noticed that we can create a database
using AWS-CDK
BUT
1. No equivalent methods to create tables using AWS-CDK/BOTO3
2. No equivalent methods in BOTO3 or JAVA SDK to store/access the database data
Can anyone tell me how i can create a table using(IAC) in AURORA db?
Can anyone tell me how i can store realtime data into AURORA?
Can anyone tell me how i can access realtime data stored in AURORA?