300 likes | 465 Views
Increase Your Oracle APEX Development Productivity with Open Source Tools. 18-Jun-2008 | ODTUG Kaleidoscope 2008. Agenda. Firebug YSlow Web Developer Live HTTP Header Oracle APEX Builder Plugin Oracle APEX Essentials jQuery ApexLib Framework. About Sphinx. Founded 1993
E N D
Increase Your Oracle APEX Development Productivity with Open Source Tools 18-Jun-2008 | ODTUG Kaleidoscope 2008
Agenda • Firebug • YSlow • Web Developer • Live HTTP Header • Oracle APEX Builder Plugin • Oracle APEX Essentials • jQuery • ApexLib Framework
About Sphinx • Founded 1993 • Creates mission-critical individual software • Consulting for Databases & Java Middleware • Specialized in Oracle • Located in Vienna, Austria/Europe • More information at http://www.sphinx.eu/
About Patrick Wolf • 15 years of Oracle experience (SQL, PL/SQL and Oracle Forms, Oracle APEX) • Oracle Competence Center Manager & Senior Solution Architect • Oracle APEX Developer of the Year 2007 andOracle ACE • Author of several Oracle APEX related Open Source Projects – http://www.oracleapex.info/ • APEX Blog – http://www.inside-oracle-apex.com/ • Contact mail: patrick.wolf@sphinx.at
Firebug • “The” tool for Web Developers • Javascript Debugger • DOM Tree inspector • On the fly CSS/HTML modifications • Addon for Firefox • Download at http://www.getfirebug.com/
Firebug • Demo
YSlow • Performance advisor • Plugin for Firebug • Download at https://addons.mozilla.org/en-US/firefox/addon/5369
YSlow • Demo
Web Developer • A lot of features (to many to count) • Cookies • Outline Tables • View all CSS • View all Javascript • Browser Sizing • … • Addon for Firefox • Download at https://addons.mozilla.org/en-US/firefox/addon/60
Web Developer • Demo
Live HTTP Header • Trace of HTTP Header traffic • What is sent to APEX • What does APEX response • Download at https://addons.mozilla.org/en-US/firefox/addon/3829
Live HTTP Header • Demo
Oracle APEX Builder Plugin • Productivity and UsabilityEnhancements for Oracle APEX IDE • Works with Firefox andInternet Explorer • Download at http://builderplugin.oracleapex.info/
Oracle APEX Builder Plugin • Resizable Textareas • Width Adjustment of Textareas • Anchor Highlighting • Split “Display As” select list • Keyboard shortcuts • “Set” feature • …
Oracle APEX Builder Plugin • Demo
Oracle APEX Essentials • Collection of Oracle APEX Tools • 1. APEX Advisor • Compiler/LINT/Best Practices/QA checker for Oracle APEX Applications • Extendable • 2. More to come • Download at http://essentials.oracleapex.info/
Oracle APEX Advisor • 22 Checks • PL/SQL Code and SQL Statements • Bind Variables, Substitutions, Page Itemsin Links, … • Page Exists • Is Page Item of Target page • Security Checks • Unconditional Branches before other Branches • Report/LOVs have ORDER BY • …
Oracle APEX Advisor • Demo
jQuery • JavaScript Library • Simplifies DOM Tree traversing • Searching elements • Manipulation • Event Handling • Animations • AJAX • Download at http://jquery.com/
jQuery • Include into Page Template • Definition/Header • <script type="text/javascript" src="#IMAGE_PREFIX#jquery.js"></script>
jQuery • DOM Tree Selection • By ID: #OBJECT_NAME eg. #P7_CUSTOMER_ID • By Class: .CLASS_NAME eg. .t12data • Objects: eg. table or :text • Attributes: eg. :text[value=Test] • Combinations: eg. td.t12data • Very well documented at http://docs.jquery.com/Selectors
jQuery • DOM Tree Manipulation • wrap • wrapInner • after • before • … • See http://docs.jquery.com/Manipulation
jQuery • Animations • show • hide • fadeOut • fadeIn • … • See http://docs.jquery.com/Effects
ApexLib - Framework • Development Framework for Oracle APEX applications • Easy to integrate (15 minutes) • Works with Oracle APEX 2.x and 3.x • Solution for a lot of small problems • Less JavaScript and PL/SQL code required • Seamless integration into Oracle APEX Builder IDE • Download at http://apexlib.oracleapex.info/
ApexLib - Architecture • PL/SQL Packages, Views and JavaScript Libraries • Installation into Application schema or ApexLib schema • Control data stored in APEX Meta Data repository • No extra tables • Normal Oracle APEX Export/Import • No synchronisation problems • Uses regular APEX events, … • Reuses application meta data
ApexLib - Architecture • PL/SQL Packages, Views and JavaScript Libraries • Installation into Application schema or ApexLib schema • Control data stored in APEX Meta Data repository • No extra tables • Normal Oracle APEX Export/Import • No synchronisation problems • Uses regular APEX events, … • Reuses application meta data
ApexLib - Usage • $APEXLIB_XXX$ hints in comment text field of object. Eg. $APEXLIB_IGNORE_VALIDATION$ • Or use APEX Builder Plugin for seamless integration
ApexLib - Features • Cascading LOVs • Automatic Browser Validation for Required, Date Picker and Numeric Items • Min-/Max-Value Check • Case Restriction Check • Tabular Form Enhancements • Access Tabular Form columns by column name • On Error Page Hack • …
ApexLib • Demo