I have a CakePHP/MySQL project that has task pipe for processing different types of tasks. Tasks are added to mysql database in single table and fetched with php script and executed. I have done this by using cron but I was wondering if there is simple way to create some kind of listener to watch over table changes. This would result tasks run faster, cause cron loops minimum only once per one minute.
I have researched and tried before RabbitMQ (which is quite good) but in this project I cant do such refactoring (cause of deadlines) at this time and I would like to have simple and working way to do this with php/mysql.
Any suggestions?
I have very little knowledge of other programming languages eg. python etc.. but I was wondering if some other language would have better capabilities to run as service and poll database??