Idea Summary
Provide native integration of NATS and MQTT in Oracle REST Data Services (ORDS) so that Oracle APEX and PL/SQL can interact in real-time with events, notifications, and messages published in these messaging systems. This would enable APEX applications to handle live events without relying solely on external WebSockets or custom solutions.

Use Case
  1. Real-Time Notifications: Allow APEX applications to receive and send real-time events without requiring constant database polling.

2. Asynchronous Event Processing: Facilitate event-driven processes without overloading the database with frequent queries.

3. IoT and Distributed System Integration: Improve communication between IoT devices and APEX via MQTT.

4. Multi-User Collaboration Applications: Instantly synchronize data in dashboards, chats, and other collaborative functionalities.

5. Business Process Automation: Trigger events in APEX based on database changes without the need for scheduled jobs.

Preferred Solution (Optional)
This could be implemented as follows:

• ORDS Extension to handle message subscription and publication in NATS and MQTT from PL/SQL.

• PL/SQL Procedures to interact with message queues, allowing developers to use these features declaratively.

• APEX Events that react to messages published in these messaging systems to update components live without requiring custom WebSockets.

• Support for Oracle Database Notifications, integrating NATS and MQTT with native database events.

Benefits

✔ Reduced Database Load by eliminating unnecessary polling.

✔ Improved User Experience with real-time updates in applications.

✔ Greater Flexibility for integrations with other systems and IoT devices.

✔ Simplified Implementation of real-time solutions in Oracle APEX.