Status: Open (View Workflow)
Fix Version/s: None
Instead of https://jira.mariadb.org/browse/MDEV-16590, this feature would provide a simpler and more developer-friendly SQL based API to be notified quickly when new records become available.
The experience may be like the following
Where an external process could use a client driver like this
I am not familiar with the source code for MySQL.
Perhaps implementation could effectively be like a long-poll or cursor. I'm not sure if the internal mechanisms would require a complete overhaul though. At the highest database driver level, the client library is waiting for another network packet with more data for that resultset, so there should be no significant resources used up, except potentially for the resultset context on the serverside.
System-defined Views would be available per table, or may be defined using new keywords like `WITH Trigger(Sales, Insert)`.
Such Views may be joined to other tables, but MUST BE the first FROM-SOURCE of the View, and the only Trigger-View.
Learning from SQL Server, perhaps these should be Queue-Views, but simpler, where triggers are enqueuing to active Views at the time; not requiring a broker.