I need to develop a WordPress plugin for a project I have in mind…The main data source would be this public info:
It is a list of plate numbers and the corresponding date of expiration. the list is almost 800.000 rows. A new list is published every month with some items already listed previously and others new…
The total list items, after a year of monthly lists updates…can count approximately a total of 15.000.000 items…plates numbers and expiration dates…
And every month, some items are updating the expiration dates…the cycle repeats continuously. The plugin should update the corresponding expiration date for the plate number associated.
Question 1: Can this raw info (a .pdf file) be transformed and be uploaded to the planned WP plugin database as the main data source? would it be a simple conversion process?
Question 2: The handling of that amount of data in a wp website can be achieved with a standard wp hosting plan?
Initially, the monthly visitor can be relatively low compared to the total items in the database…50.000 or 100.000
If question 1 and 2 are feasible…then I would go a step further with the development idea…I have already minded mapped the whole plugin idea.
Thanks in advance for your feedback.