我应该使用PHP或Perl来按摩我的数据并使用MySQL存储/检索它吗？

Question

I have a desktop app that needs to send data to a MySQL Server. The app will be for internal company use, but the MySQL is on a server at a hosting company.

The data will need to be massaged a bit before being inserted and standard simple insert, delete and update.

Which should I use PHP or Perl?

I use PHP now for a variety of database driven web pages, but my current task has no need to any web rendering. (I know PHP could do this without an web-rendering too)

I have used Perl in the past (maybe 4 years ago) for a data mining task and Oracle.

What I don't know: - Can Perl work with MySQL easily? - The Perl scripts would go in cgi-bin on the webserver, correct? - Security issues with either? - Best practice in Perl for connecting to MySQL to insert data? - Where can I store the Insert, Update, Delete MySQL user name and password so it is not stolen, etc?

What would you all choose?

Thoughts are appreciated

-Jason

Answer 1

Well both can work just fine with MySQL. It's really just a preference and level of comfortability. Since you say you do quite a bit with PHP, then that might be more productive for you.