Should i learn ASP or Oracle APEX to create Online DBs?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • garyb2008
    New Member
    • Nov 2008
    • 18

    Should i learn ASP or Oracle APEX to create Online DBs?

    My work now needs to share live data with the companies clients. Its simple stuff - based around one table with a few for aux info - and ive been using Zoho Creator DB but this isnt as solid as we would like...

    Whats the best path for me to create these web databases?

    Should i learn web page / ASP programming or is it easier/ better to learn the Oracle APEX platform (Express Edition)?

    Arguments i already have for ASP...
    1. Ive extensive Access experience
    2. Ive used VBA quite a bit
    3. I would be able to use a standard ISP host package as i read mines come with ASP and access database support
    Against
    1. I "know" but am inexperienced in HTML
    2. Id have to learn ASP from scratch, i dont have a lot of DAO/ADO experience
    3. Ive only used vbscript on WSH before

    Arguments for APEX
    1. Logged onto apex.oracle.com and it looks great - what i wish zoho was - easy wizards and able to get down + dirty with SQL
    2. Seems to be good widgets for UI available
    Against
    1. Only heard of it yesterday!
    2. No PL/SQL experience (ive got T-SQL experience)
    3. Will i need to code client scripts, can i use vbscript?
    4. Id have to set it up on my own server or a VPS, ive no HTTP server experience
    5. Are the client web pages solid and reliable?

    What route do you think is best for me?????

    Regards

    Gary
  • Kathryn Gamble
    New Member
    • Sep 2010
    • 3

    #2
    Hi
    This might be a bit late now but ...

    If you want to use APEX you will need a host with Oracle and Apex installed. Most webhosts have MySQL so cost could be an issue but there are hosting companies that provide Oracle. You can only use apex.oracle.com for development work not for commercial applications.

    Although its easy to create simple things with the Apex wizards, to get the best from Apex you'll also need a good understanding of SQL (the language not MS SQLServer) and PL/SQL too. Client side coding is done in the application using Javascript/Jquery.

    I don't know ASP but be warned, Apex is addictive! Let me know if you need any more information. There is a growing Apex community out there.

    Kathryn

    Comment

    Working...