80 likes | 219 Views
Oracle Application Express (APEX) for Mobile Web Applications. Franç ois Briard GS-AIS-HR CAPPS, 21 June 2013. Disclaimer.
E N D
Oracle Application Express (APEX) for Mobile Web Applications FrançoisBriardGS-AIS-HR CAPPS, 21 June 2013
Disclaimer • Even if widelyused in the past and still in use, Oracle Application Express (APEX) is not the official GS-AIS DevelopmentTool (neither for desktop or mobile web apps) • This presentationisbased on personalexperience made with the tool out of the AIS main scope (i.e. Open Daystools)
APEX in a nutshell • Oracle Application Express is a free rapiddevelopmenttool to create web applications relying on Oracle database data. • PL/SQL and jQuerybased • Graphical interface on the web • Verystrongdevelopmentcommunity (400’000 developers) • Very active forum (3rd in OTN) and completewebsite • Strong support of jQuery (mobile) in a declarativeway • Possibilityto package applications and plugins • Supportedat CERN and course offered by HR training • Competencesneeded: • Main: Oracle, SQL, PL/SQL • Optional: Javascript, jQuery, HTML
Architecture • Simple 2-Tier Architecture (can be 3) • Pages dynamically rendered using database metadata • No code generation or file based compilation • Runs everywhere Oracle Database runs
My experience • Desktop and Mobile versions of a web app are 2 web apps • Desktop UI = much data / few clicks • Mobile UI = few data / much clicks • Proactive reading of jQuery mobile documentation is a plus • ReusewhatjQuery Mobile offers • Make extensive use of the « Dynamic Actions » (AJAX)