Systems to provide database updates
View Patent ↗A system includes establishment of a WebSocket connection at a WebSocket endpoint of the system with a WebSocket client, registration of a callback at the WebSocket endpoint for an event associated with an update to data of the database, identification of an update to the data of the database at an HTTP endpoint of the system, sending, in response to the identification of the update, a trigger event from the HTTP endpoint, reception of the trigger event at the WebSocket endpoint, and execution of the callback by the WebSocket endpoint to transmit the update to the WebSocket client.
1. A system comprising:
a memory storing:
a database; and
a processor to execute the processor-executable process steps to cause the system to:
establish a WebSocket connection at a WebSocket endpoint of the system with a WebSocket client;
register a callback at the WebSocket endpoint for an event associated with an update to data of the database;
receive a request via an HTTP endpoint at an application server to update data of the database;
identify an update to the data of the database by the HTTP endpoint of the system, wherein the application server is closely-integrated with a database system;
in response to the identification of the update, send a database trigger event from the database system to an application running in the application server of the system, wherein the database trigger event provides a content update to the application running in the application server;
receive a trigger event at the WebSocket endpoint from the application server via the HTTP endpoint, wherein the trigger event comprises row ids of a database table; and
execute the callback by the WebSocket endpoint to transmit the update to the WebSocket client, wherein execution of the callback by the WebSocket endpoint comprises selection of data of the database associated with the row ids.
2. The system according to claim 1 , wherein the row ids of the trigger event comprise row ids of database table rows which were updated by the update.
3. A computer-implemented method comprising:
establishing a WebSocket connection at a WebSocket endpoint of the system with a WebSocket client;
registering a callback at the WebSocket endpoint for an event associated with an update to data of a database;
receiving a request via an HTTP endpoint at an application server to update data of the database;
identifying an update to the data of the database by the HTTP endpoint of the system, wherein the application server is closely-integrated with a database system;
in response to the identification of the update, sending a database trigger event from the database system to an application running in the applications server of the system, wherein the database trigger event provides a content update to the application running in the application server;
receiving a trigger event at the WebSocket endpoint from the application server via the HTTP endpoint, wherein the trigger event comprises row ids of a database table; and
executing the callback by the WebSocket endpoint to transmit the update to the WebSocket client, wherein execution of the callback by the WebSocket endpoint comprises selection of data of the database associated with the row ids.
4. The method according to claim 3 , wherein the row ids of the trigger event comprise row ids of database table rows which were updated by the update.
5. A non-transitory computer-readable medium storing program code, the program code executable by a computer system to cause to the computer system to:
establish a WebSocket connection at a WebSocket endpoint of the system with a WebSocket client;
register a callback at the WebSocket endpoint for an event associated with an update to data of the database;
receive a request via an HTTP endpoint at an application server to update data of the database;
identify an update to the data of the database by the HTTP endpoint of the system, wherein the application server is closely-integrated with a database system;
in response to the identification of the update, send a database trigger event from the database system to an application running in the applications server of the system, wherein the database trigger event provides a content update to the application running in the application server;
receive a trigger event at the WebSocket endpoint from the application server via the HTTP endpoint, wherein the trigger event comprises row ids of a database table; and
execute the callback by the WebSocket endpoint to transmit the update to the WebSocket client, wherein execution of the callback by the WebSocket endpoint comprises selection of data of the database associated with the row ids.
6. The medium according to claim 5 , wherein the row ids of the trigger event comprise row ids of database table rows which were updated by the update.