I would like to collect data about companies into a database (either MySQL or PostgreSQL) from a website ([url removed, login to view]), in order to query and report. Many reports will be graphic and generated from object oriented applications (thus PostgreSQL may be best).
A second stage will be to perform maintenance through updates at the website (where no notice if given of the changes). The database should version all updates so a history can be maintained. The maintenace aspect should provide a summary of changes.
Collect data from the website into a database.
Version the data from site updates on a regular basis.
Note: The website has company profile informat and news, I only want to manage the profile information. An example profile is:
[url removed, login to view]'a%20Real%20Estate%20Company