I always thought MemSQL was a strong contender with the commitment to the MySQL wire protocol and SQL. The addition of a column store for larger than memory storage also seemed like a really good way to balance the concerns of speed of access vs storage cost.<p>I always wished we had taken a few pages from their playbook when I was @ VoltDB. Including ignoring BEGIN and END transaction :-)
This page: <a href="http://blog.memsql.com/powerstream-demo/" rel="nofollow">http://blog.memsql.com/powerstream-demo/</a> 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?
Props. May not be a tool I'm personaly likely to use (my colleagues and I work on a db meant for a very different work load in a perpendicular space), but I'm always in favor of more investment in real tech, even if it's c++ heavy :p<p>Also enjoyed meeting Eric in NYC a few years ago. Props!
For MemSQL folks here...implement stored procedure support please. I would love to move all legacy apps I have over to MemSQL but I can't because of this.