I have a simple task do create a script to extract information from external database in JSON format and then loading the information into MySQL table on regular basis.
In particular, it will involve:
- checking when the external database was updated - in regular intervals (this information is published in HTML format but it may be required to query the database directly to check if the latest record has changed)
- if database was updated, extracting information via web service API (specifying time range “from last update time – to current time”). Data is delivered in JSON format.
- appending the data to MySQL database table.
As part of the task you will have to create appropriate MySQL database and the table, run one-off download of historical data and provide corn job configuration for checking of new updates in 15 min intervals.
31 freelancere byder i gennemsnit $164 på dette job
Hi, We can perform the task and complete within 2 days. We have one clarification wether you have the external database access details which will help us to serve you better. Thanks Mrith
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
I have 20 years experience writing tools in PHP/MySQL and other languages. From searchengines to complex analytics tools. I would be happy to discuss this project with you further.