PWA at the Autonomous Oracle Cloud

[Ingolmo]

trafficstars

Did anyone succeed on having a PWA a the ATP instance? Any help on where to allocate the manifest.json would be much appreciated!!

[jmichler]

Have a look over there: https://www.promatis.de/2020/02/25/building-a-minimal-progressive-web-app-pwa-on-autonomous-apex/ Basically you can either mis-use ORDS to set the required HTTP Headers for delivering the Service Worker. An alternative would be to put a load balancer in front of the ATP instance...

[vincentmorneau]

Thank you Johannes, this is a great blog post. I just tweeted about it to give you some more readers.

I will definitely try it. Can you think of any restrictions/limitations/performance hits using this approach?

[jmichler]

Hi Vincent, one limitation (but this is more an apex generic issue) is that it's difficult with different applications on the same ORDS - since APEX does "unfriendly" URLs there for the "scope" attribute. Furthermore we ran into quite some trouble with the free tier when doing pro-active "caching", that leads to the browser hammering the ORDS and that crashes the max. of 20 DB-Sessions. I've tried to convince Oracle to change the jdbc.maxlimit parameter of the ORDS without success so far. Beside from this I don't see a problem, however I've the impression that all this "scope" stuff with PWAs is not yet 100% perfect. Will you be at collaborate?

BR Johannes

[vincentmorneau]

I won't be at Collaborate. Probably Kscope this year.