Notifying clients from backend servers in stateless environments like web applications with HTTP protocol is a challenge, here a great bundle where you can achieve this goal in APEX applications.
For a long time I was struggling with having to use a JS library ( https://bashooka.com/coding/10-javascript-libraries-and-tools-to-work-with-pdf/ ) to view pdfs or images from the database, but with no luck because my files are stored in the database as BLOBs, it may seem simple for someone, but was not obvious for me to have a URL for my BLOBs to server the JS libraries. The following post will show how this is done. Preview PDF Uploads in an APEX App (Cross-post)
For production installation, you surely need to have a layer in front (Reverse Proxy) of your ORDS, here are samples of configuration for the most popular web servers 1. Apache Reverse Proxy Configuration using Apache 2. NGINX The Oracle APEX Reverse Proxy Guide using NGINX
Running a long process from APEX application will force the browser to hang and the web server to send a timeout error. Here how you can run such a process. Run PL/SQL in the background and display a progress bar
Comments
Post a Comment