Technology Choice: MySQL versus MongoDB, News APIs

[mdhsieh]

MongoDB would improve performance over MySQL because information will be written to the database, the disease data and location, much more often than reading from the database itself. MongoDB allows unstructured documents and you can add new columns without suffering as much in speed as MySQL. See: https://blog.panoply.io/mongodb-and-mysql

Also, Google News API is deprecated so there may be problems later. You may need to use other news sites. Using city and regional newspaper sites may be more helpful since those will be local and close to the pharmacy, but these are unlikely to have any APIs to help with scraping. This will make it more difficult to collect trend data.