[rt-devel] kanben view in RT 4.2.12

[Joachim Schiele]

dear rt-developers,

we want to add a kanban view for tickets in RT but in order to do that a
REST interface with websocket support is required.

the current 1.0 interface does not support JSON (will be fixed with the
2.0 REST API AFAIK) which means we have to create java-script objects
from the input in the browser manually (without being able to use
parseJSON(...))

our initial idea is to use mysql with triggers:
  http://dev.mysql.com/doc/refman/5.0/en/triggers.html

as this seems to be an easy way to monitor the tickets table for changes
and then note these ticket IDs down.

the websocket REST-interface then sees all attached clients and every
time a ticket changes it can push the ticket ID(s) to the client and the
client then can apply the change.

=== the question ===
- where in the RT code would be the best place to add the WEBSOCKET REST
extension (into the routing) + it needs an main loop waiting for
'ticket'-table changes
- how to make this a general solution: instead of binding this feature
to MYSQL we could also extend the ticket API with various callbacks on:
 - add/remove/update ticket functionality
=== /the question ===

we plan to release the kanban as open source once we are done with the
implementation.

if you could help us out with implementation details, that'd be a delight.

thanks in advance,
joachim & paul