I want to implement a client application that uses PERL and CURL to send messages via http from one remote server to another database server. THe database will query the database or update the database and send the results back to the perl/http client. perl scripts on the remote server will be running continuously and perform file management on the server based on the XML data coming out from the database. I am going to format db output as an XML because it is easier to parse by perl on the other server.
I read on another site that http is not robust for this kind of application. Also, there will be issues on how to handle timeouts and errors from the database program.
The problem is that my database server is behind a firewall and can only be accessed via http calls.
Has anyone done a similar application and is it true that the client API will have issues with timeouts, transactions, errors, etc.