This page: http://blog.memsql.com/powerstream-demo/ mentions:
"Real-time notifications push to the UI based on a `select *` query from an events table, which scales up to 2 million records.". But the docs don't really talk about doing things like that. Anymore info on these live queries?
In MemSQL Powerstream, we run queries against MemSQL for events which return in a couple of milliseconds. These queries are run continuously thus they are able to provide the front-end with events as they happen. At this time we do not have in-MemSQL live query support, but given enough interest it could be something we consider.