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

APEX Connect 2024

Philipp Hartenfeller

24.04.2024 | Düsseldorf

$whoami

Philipp Hartenfeller

  • Düsseldorf, Germany
  • Oracle APEX Developer since 2016
  • Product Lead at United Codes
  • WebDev and Databases
Blog: hartenfeller.dev/blog
Twitter: @phartenfeller

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

Thank you!

Questions? Feedback?

Connect with me!

hello@hartenfeller.dev

hartenfeller.dev