Ask HN: Is there a way to efficiently subscribe to an SQL query for changes?
Disclaimer: I work at Materialize.<p>This is the exact problem that we are solving here at Materialize! I wrote an example blogpost that details to how to subscribe to a SQL query in practice:  <a href="https://materialize.com/a-simple-and-efficient-real-time-application-powered-by-materializes-tail-command/" rel="nofollow">https://materialize.com/a-simple-and-efficient-real-time-app...</a><p>Regarding your comment about "focus on streams", it's true that we first focused on extracting event data from other sources (Kafka, Debezium, direct change data capture from external databases such as Postgres, S3, etc). Over time, however, we plan to add additional features that will allow users to also treat Materialize as a general purpose database.<p>Hope this helps and happy to answer any questions!<p>edit: I was imprecise in my usage of the term event streams. Materialize supports inserts, updates and deletes at its core (the topK query shown in the blog post above shows this). Materialize is a more general solution than something focused on append-only event streams.