cloud to premise push notifications

Boro-Oracle

Has node.js been integrated with any of Oracle messaging technologies? If yes then which one?

What would be the best pattern for sending a message to some of a many thousands of subscribers that are in a wait-polling state for their message?

Christopher Jones-Oracle

I can answer about the node-oracledb driver integration part: you can access Oracle Advanced Queuing via its PL/SQL API.

Boro-Oracle

Wouldn't that create one connection and one database process/thread for each client? I.E. 100,000 clients would create 100,000 database processes.

Christopher Jones-Oracle

Any access from node-oracledb to the DB will need a connection.  But node-oracledb has inbuilt connection pooling.  And the database has DRCP pooling, so the number of database processes could be much, much less than the number of "users'.  In a small synthetic benchmark with a DRCP pool of 100 we handled 20000 "users".

This may not give you a 'pattern', but it is something to consider when you evaluate your options.

I'd really like to hear what you find.