Practical notes, architecture patterns, and production lessons from real systems
Turn nested JSON APIs into query-ready datasets in Oracle APEX — no transformation layers required. Many public APIs expose responses where metadata and data are separated at the root level — a structure that breaks typical low-code consumption patterns. This article shows how to handle this scenario natively in Oracle APEX, using the World Bank … Read more
Build a live analytics dashboard in Oracle APEX using a public REST API — no middleware, no local tables. This example uses the World Bank API with native REST Data Sources to retrieve and visualize economic indicators dynamically. The integration is implemented using only standard APEX components, focusing on a clean and reproducible pattern. To … Read more
This article comes from a practical Oracle APEX scenario I faced while preparing an application for testing and review. At some point, an application reaches a stage where external testing is required, and someone asks: “Can you send me a login so I can test it?” Sharing an Oracle APEX application for testing can unintentionally … Read more
This article comes from a real issue I encountered during hands-on development and later shared with the Oracle APEX community. A practical Oracle APEX pattern to keep a JET Chart title aligned with user selections — both on initial page load and after dynamic refresh. While building a JET Chart in Oracle APEX, I ran … Read more
Notifications are everywhere in enterprise applications, but they are often treated as an afterthought. A button is clicked, a PL/SQL process runs, APEX_MAIL.SEND is called, and the application moves on. When everything works, no one thinks about it. When something fails, the only question left is: “Did it even go out?” Instead of treating delivery … Read more