I have a php/mysql based site set up. I want to keep my database layer updated via a python script that will query some other systems, parse data and make the appropriate CRUD calls to my database. My question is might be a simple one but I'm wondering the mechanics of setting up this type of system. I've heard it's fairly common to have a python backend but I'm unsure on how to go about implementing this. Do I write the python scripts and set up a cron job to run at specified intervals or is there some other mechanism that can do this for me?
Thanks in advance!