1. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    Say you have a helpdesk package which you use to record details of customer reported problems with their computer hardware/software. This package has an underlying Oracle database(both the helpdesk server and Oracle database lie on a Solaris platform on a SunSparc. You actually perform view, modify, and submit entries using the app user tool;the user tool send any request for view, modify, update to the application's API, which in turn sends the information to the application's server process, which in turn then goes to the Oracle database.(phew!)
    If you want to create a web app tool that can view, modify and create entries on this package, is it better to:

    1)Use/Create an api program(using the helpdesk package API libraries) that interacts with the application's own API, or

    2)Use PHP/ASP to create a web tool that bypasses the helpdesk package altogether and interacts directly with the Oracle database.

    I am looking for the best solution in terms of speed of pick up(i.e learning the server-side environment/learning about API's), performance, etc.

    If the above is not confusing, can anyone suggest ideas on this?
    Thanks in advance.

  2. #2
  3. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    Don't know the specifics, but it sounds like using the provided API (assuming it is robust enough to provide all the features you need) might be the safer route. Writing a web interface straight to the SQL database requires you re-writing all the business logic that is normally taken care of by the application. I'd expect your development time to be significantly greater.

    Also using the API is more likely to shield your web app from future data structure or logic changes.

Similar Threads

  1. Which server side technology?
    By Giraffe bird in forum Web Design Help
    Replies: 1
    Last Post: February 16th, 2004, 07:18 AM
  2. Replies: 0
    Last Post: February 7th, 2004, 05:19 AM
  3. cant work out how to validate form server side properly....
    By ralphuk100 in forum PHP Development
    Replies: 21
    Last Post: February 6th, 2004, 02:35 PM
  4. client side vs server side validation + client side md5....
    By ralphuk100 in forum PHP Development
    Replies: 8
    Last Post: February 4th, 2004, 07:45 PM
  5. I am new to server side languages and am a little confused.
    By dynasty in forum ColdFusion Development
    Replies: 4
    Last Post: January 15th, 2004, 09:42 AM

IMN logo majestic logo threadwatch logo seochat tools logo