News for hackers. Stuff that matters.
Re:EventReduce: An algorithm to optimize database queries th... by fahrradflucht on Thursday April 16, 2020 @08:14AM (#22888579)
There is also noria [0] which is basically a SQL database with integrated materialized views with memcached like perf. - But I think it is more in a research state.

[0]: https://github.com/mit-pdos/noria

Re:EventReduce: An algorithm to optimize database queries th... by scott_s on Thursday April 16, 2020 @09:29AM (#22889119)
Any database which offers what are called "continuous queries" also solves this problem. I'm glad the ACM Digital Library is open right now, because I can just point to: https://dl.acm.org/action/doSearch?AllField=continuous+queri...

The work in general purpose streaming grew out of the continuous query work in the early 2000s. Marrying truly general purpose streaming with transactional databases is not a solved problem (as opposed to transactional databases providing streams), but the notion of continuously running database queries has been around for a long time.