After the Keynote about “Oracle Application Express – Ahead of it’s time. Leading the way forward” by Joel Kallmann (Director of Software Development for APEX) and some overall presentation about Development with APEX 5.1, I decided to attend presentations on following topics oriented towards tools to make developer’s life easier:
\n– APEX OOS Tools and helper
\n– Useful APEX plugins
\n– LESS is more
\n– JavaScript Debugging and Tuning
\n– Introduction to Oracle JET<\/p>\n
Oracle Application Express – Ahead of it’s time. Leading the way forward<\/strong>: Upcoming features in APEX 5.2:<\/strong> APEX OOS Tools and helper:<\/strong>: Useful APEX plugins:<\/strong>: LESS is more:<\/strong>: JavaScript Debugging and Tuning:<\/strong>:
\nIn 2008 APEX was already matching the definition of cloud given by the NIST (National Institute of Standards and Technology) and even matching the definition of PaaS in 2002: APEX was ahead of it’s time!
\nAPEX allows to increase productivity and consistency, reducing complexity due to it’s declarative framework setup. It’s therefore to be seen as lowcode development environment: https:\/\/apex.oracle.com\/lowcode\/<\/a>
\nWhat is impressive about APEX is that a packaged app written in 2008 is still able to run on apex.oracle.com today.
\nIt’s the most used development platform within Oracle for running there internal business.
\nThere is now an online APEX curriculum available for free on Oracle academy: APEX on Oracle academy<\/a>
\nOracle database free services online will be launched, replacing apex.oracle.com.<\/p>\n
\nThe next version of APEX may contain features like:
\n– Blueprint wizard: allows to integrate features from existing packaged apps in your on application declaratively
\n– Improved packaged apps
\n– Update of JET and JQuery versions
\n– Enhancements in Page designer:
\n -* Dialogs\/pop-overs
\n -* Client side dialogs
\n -* Adaptive UI based on preference options declaratively enabled\/disabled
\n -* Removal of legacy component view
\n– Enhancements on JET Charts:
\n -* New Gantt chart
\n -* New pyramid report
\n -* New Box Plot
\n -* New interactive report and websheet charts
\n -* Removal of 32k limit of data visualization
\n– Improved interactive grids
\n -* Flexible row height
\n -* Group by view
\n -* Pivot view
\n -* Region button position
\n -* Printing
\n -* Subscription
\n -* Computation
\n -* Required filtering
\n -* Complex filtering and highlighting
\n -* No stretch columns
\n -* Copy down facility
\n -* API documentation
\n -* Migration for interactive reports
\n– Improved REST services
\n -* Declarative support of REST services
\n -* REST services as data source for APEX components
\n -* Simple access to Cloud services
\n -* ORDS remote SQL data access
\n -* SQL execution on remote DB
\nAll very nice and promising features \ud83d\ude42<\/p>\n
\nOracle Open Source Tools and other useful Open Source projects can be found in GitHub within different repositories.
\nMost famous OOS tools for APEX developers are:
\n– oracle-db-tools
\n– oraclejet
\n– db-sample-schemas
\n– node-dboracle
\n– docker-images
\nLink to oracle GitHub: https:\/\/github.com\/oracle<\/a>
\nBeside that to Open Source community provides various other tools for APEX developers:
\n– oxar (automated installation of full development environment)https:\/\/github.com\/OraOpenSource\/OXAR<\/a>
\n– docker images https:\/\/github.com\/Dani3lSun\/docker-db-apex-dev<\/a>
\n– Logger https:\/\/github.com\/OraOpenSource\/Logger<\/a>
\n– APEX Diff (comparison of application exports based on JSON using node.js and sqlcl) https:\/\/github.com\/OraOpenSource\/apex-diff<\/a>
\n– APEX Client extension https:\/\/github.com\/OraOpenSource\/apex-frontend-boost<\/a>
\n– PL\/SQL libraries like Alexandria https:\/\/github.com\/mortenbra\/alexandria-plsql-utils<\/a>
\n– APEX backup scripts https:\/\/github.com\/OraOpenSource\/apexbackup<\/a>
\nThere is a lot out there to make you life easier. Enjoy them!
\nThanks a lot to all contributors!<\/p>\n
\nAPEX is a very nice development framework but it sometimes needs more than what is provided by Oracle.
\nFortunately APEX allows to write extensions to fill-in the gap: plug-ins
\nThere are many to be found on apex.world
\nHere is an non exhaustive list of useful plug-ins that were presented at APEX connect:
\n– select2 https:\/\/select2.github.io\/<\/a>
\n– Date range (based on JS moment library) http:\/\/apex.pretius.com\/apex\/f?p=105:DATERANGE:::NO:::<\/a>
\n– Help text tooltip http:\/\/apex.pretius.com\/apex\/f?p=105:HELPTEXT:::NO:::<\/a>
\n– Dropzone (for multiple file upload) https:\/\/github.com\/Dani3lSun\/apex-plugin-dropzone<\/a>
\n– Excel to collections http:\/\/www.apex-plugin.com\/oracle-apex-plugins\/process-type-plugin\/excel2collections_271.html<\/a>
\n– Enhanced notification http:\/\/apex.pretius.com\/apex\/f?p=105:NOTIFICATIONS:::NO:::<\/a>
\n– Nested reports http:\/\/apex.pretius.com\/apex\/f?p=105:NESTED_REPORTS:::NO:::<\/a>
\nThanks to all developers who provide those plug-ins and make APEX be even more enjoyable!<\/p>\n
\nWhat is LESS?
\nLESS is a CSS pre-processor which allows to use variable, mix-ins and nested rules to facilitate the rules CSS management.
\nIt’s already in use in APEXso that you can leverage thattool to adjust your application to your Corporate identity guidelines.
\nThe Theme roller of APEX 5.x make use of it, but the core.css of APEX is not modified that way.
\nI would suggest you to visit following website if you are interested in who LESS works:
\nhttp:\/\/lesscss.org\/<\/a><\/p>\n
\nAPEX makes use of JQuery.
\nIn some cases you might run into performance issues while loading or using your application pages.
\nHere are some tips and tricks to optimize JavaScript in your application based on experience.
\n– Use the right selector to reducing searches in the DOM (from the most to the less selective: id, element, class, attribute, pseudo)
\n– Use loops the right way (arrays can help)
\n– Use variables to reduce DOM access
\n– Use detach function to have an “offline” DOM and reduce the cost of parsing and accessing the DOM
\n– In some case native JavaScript is faster than JQuery
\nThere are tools to help you measure the performance of your page:
\n– jsperf.com
\n– ESBench.com
\n– Chrome Canary developer tools
\nWhen it comes about page load performance, the size of your JavaScript library file is key. This can be reduced using tools like uglifyJS.
\nFor Debugging and Logging purpose you can make use of the client console.log or even better the APEX.debug wrapper on it. Unfortunately those logs are only visible on the client console during runtime. One option to centralize them would be to write the result of the logs into a DB table using AJAX. Also stacktrace.js is of help as it captures the user context which can then be put with the logs to better understand the issue.
\nUltimately REST service could also be an alternative to send back the logs to the DB.<\/p>\n