Step-by-Step Creation of an Offline APEX App with Plug-Ins

KScope 2024

Philipp Hartenfeller

17-JUL-2024 | Nashville

$whoami

Philipp Hartenfeller

  • Düsseldorf, Germany
  • Oracle APEX Dev since 2016
  • Product Lead at United Codes
  • WebDev and Databases

Before we start

  • This is Open Source: GitHub phartenfeller/apex-off-grid
  • This is beta (changes planned, might not work for your case in current state)
  • What you need to get started:
    • sw.js
    • Packages and Tables
    • APEX Plug-Ins
    • Set HTTP headers on Webserver/Proxy

APEX Bug #32531037

APEX Bug #32531037

  • Setting headers in APEX does not work
  • Workaround: Set headers in Webserver/Proxy
  • Headers increase security
            
              Cross-Origin-Embedder-Policy: require-corp
              Cross-Origin-Opener-Policy: same-origin
            
          

Demo

Try it out for yourself!

PWAs are here to stay

United Codes

ats.united-codes.com

Thank you!

Questions? Feedback?

Contact me: philipp@united-codes.com

hartenfeller.dev