I am building a system that processes articles from news websites and pushes the content to an analytics engine. The majority of the Azure cost from an SQL database.
This database is used to store a list of the urls to different websites. Each row is the name of the news source and the matching url link. If one wishes to add a news source, a new row is added manually. So the number of records is very little and stay like so when productionising, i.e. in alpha phase now, we have about 5 records, long term we may have 100-200 records maximum.
The bulk of the database cost comes from the read-write operations that happen frequently (every 15 seconds, all the rows are updated).
We feel like there should be a cheaper alternative Azure resource to store this little amount of data, rather than an expensive SQL database. A no SQL database somewhere, a simple JSON file that can be hosted somewhere on Azure, etc...?
What are your thoughts?