260 likes | 284 Views
Learn about essential frameworks to optimize your Apex development process. Discover useful tips on parameters, logger, mail wrapper, audit, and security to save time and maintain standards.
E N D
5 Lifehacks for the Apex Development environment Five frameworks you should use for every Apex business application Koen Lostrie Developer, Curriculum Development Oracle Corporation March 8th, 2016 koen.lostrie@oracle.com @koenlostrie
Introduction The idea • “Things I do in every project” • Requirement “assumptions” • Save time later • Standards
And the lifehacks are Parameters Logger Mail wrapper Audit Security 1 2 3 4 5
Parameters Lets start with a simple one... • Business problem: How to make xxx “Configurable” • No hardcoding of any data that can change or can be different in dev and prod
Logger The most used one • Business problem: log errors, information, debug. • What tools are available ? • Always: PRAGMA AUTONOMOUS TRANSACTION !
Logger Use it for • Code instrumentation • Debugging… in both apex & pl/sql • All exception handling in pl/sql, in jobs
Logger Why ? Because it has such cool features • Open source • Does basic logging • Easy install • Can be configured • Great for Apex
Logger Make it even better • Apex front end • Alerts
Logger But... • Limitation: logger schema needs CREATE ANY CONTEXT database priv
Mail Wrapper The lifesaver • Business problem: Test mails • Tools available: none.Options: don’t use apex_mail (instead utl_mail) or wrap around apex_mail
Mail Wrapper There is an app for that • Features: Test and Toggle on/off • Procs/functions with same signature as apex_mail procs/functions
Basic Audit Solution I know what you did • Basic • Who/when/what • Not up to scale with Oracle products • Limitations
Security App Lock it. • Central “hub” app. • Group / Users data model • Roles and Responsibilities • Data security