Re: Perl, Java, MySQL?

[dHarry]

Hi wjw

an application written for mobile apps in Java using a MySQL database

This leaves open questions. Depending on how the application is partitioned, i.e. what runs where, and if changes can be made to server-side Java, if any.

If the app was developed with the Android SDK and it connects to a server where mySQL runs with no server-Side Java you just need a database connect:)

If there is server-side Java (there are various flavours ranging from "simple" to Enterprise Edition) there are severalways. It very much depends how it is implemented and if changes can be made to it.

Using one of the mentioned alternatives will likely lose you more than "some performance". I propose a different approach. You can easily expose Java classes as Web services and this can be integrated a lot easier!

Cheers

Harry

[wjw]

Much appreciated Harry! The web services approach is exactly along the lines I was thinking. Thanks for articulating that.

What I would hope to do is let Perl handle the entire web user interface(forms, instructions, ajax calls etc...), and for data entry/manipulation, simply hand the collected results to the Web Service as you pointed out. Thus hopefully excluding the already developed access to the DB.

As a result, the developers working with the main app(mobile) can modify as they wish without having to have updates to the Web front end unless there are schema additions or removals.

Again, as jeffa pointed out, it seems to make more sense to just do the whole thing in Java. On the other hand, I can imagine a scenario where the app developers may not want, or are unable, to expand their internal team and just want to outsource the web portion of the project, thus allowing them to focus completely on the mobile app. I don't know that this is the case, but it seems possible based on my experience with small companies.

Thanks again for the input!