"Best" language /architecture for browser-based app with ODBC and sockets? (subjective)

Posted by mawg on Stack Overflow See other posts from Stack Overflow or by mawg
Published on 2010-05-06T03:49:05Z Indexed on 2010/05/06 3:58 UTC
Read the original article Hit count: 692

Sorry to ask a subjective question, but I would welcome some advice. I am an experienced programmer of embedded s/w, but haven't done much network programming, although I have done a fair bit of hobbyist PHP.

Anyway, I have to develop what is probably a fairly general type of app, as shown in this crude diagram

---------------------------------------------------------------------------------

| Browser / user interface Takes input from user form and writes data to d/b.    |
| Also gets data and updates browser contents when when d/b contents are changed | 
| because of info received over TCP/IP.                                          |

|________________________________________________________________________________|

|        ODBC                                                                    |

|_______________________________________________________________________________|

|      database                                                                 |

|_______________________________________________________________________________|

|        ODBC                                                                   |

|_______________________________________________________________________________|

|    Socket (TCP/IP)                                                            |

|  Send data out when d/b is updated from browser.                              |
| Also, update d/b when data are received over TCP/IP.                          |

|_______________________________________________________________________________|

As I say, I imagine this to be a fairly typical architecture? Am I right?

Then client is insisting on MSIE - unless I can show compelling technical reasons for FireFox or other then it will have to be MSIE (are there any compelling technical reasons?).

So, with MIE (almost) a given, I had though to use PHP, since I know it, but

  1. the client seems awfully keen on Java (which ought to be OK since I am conversant with C++)
  2. it woudl seem to make sense to use the same language for the "upper" interface between the web pages (which that app generates) and the d/b, and for the "lower" interface between the d/b and the socket. (a single language means a single set of tools since text approach, etc)

So, the (probably highly subjective) question is "which language shoudl I choose".

As I say, the client is keen on Java. Any compelling reason why not? Is it generally a good choice for the sort of thing described here?

Any other hints & tips gratefully appreciated (and up-voted): URLs, books, tool chain suggestions, etc, etc

© Stack Overflow or respective owner

Related posts about subjective

Related posts about java