What your trying to do is very difficult (particularly since your data views are relying upon joins and group queries.) You may need layered solutions. I've been looking at https://deepstream.io for keeping clients in sync. You will still have to watch the db, though the client and back end sync is handled! - Source: Hacker News / about 1 month ago

Https://deepstream.io/ - a popular open source realtime server and https://golden-layout.com/ - the leading layout manager for Web Apps - among many other things. You can find more examples of my work at https://wolframhempel.github.io/me/ My specialties are complex, graphically demanding Web Apps and Cloud server architectures. Over the years I've gotten incredibly good at helping my clients deliver some of the... - Source: Hacker News / 5 months ago

Wolfram previously built https://arcentry.com/, https://deepstream.io/ and https://golden-layout.com/, Adam is Director of Engineering for a trading tech company and. - Source: Hacker News / 11 months ago

OS projects: https://deepstream.io/, https://vramework.io/. - Source: Hacker News / over 1 year ago

Deepstream is an open-source library for real-time web application development. The library, which is built with Node.js and Engine.io, helps developers build frontend web applications that perform real-time updates while requiring minimal backend code. - Source: dev.to / over 1 year ago

To fully leverage the data is the new oil concept, companies require a special database designed to manage vast amounts of data instantly. This need has led to different database forms, including NoSQL databases, vector databases, time-series databases, graph databases, in-memory databases, and in-memory data grids. Recent years have seen the rise of cloud-based streaming databases such as RisingWave, Materialize,... - Source: dev.to / 3 months ago

Some recent solutions to this problem include Differential Dataflow and Materialize. It would be neat if postgres adopted something similar for live-updating materialized views. https://github.com/timelydataflow/differential-dataflow. - Source: Hacker News / 7 months ago

Materialize | Full-Time | NYC Office or Remote | https://materialize.com Materialize is an Operational Data Warehouse: A cloud data warehouse with streaming internals, built for work that needs action on what’s happening right now. Keep the familiar SQL, keep the proven architecture of cloud warehouses but swap the decades-old batch computation model for an efficient incremental engine to get complex queries that... - Source: Hacker News / 8 months ago

Materialize | EM (Compute), Senior PM | New York, New York | https://materialize.com/ You shouldn't have to throw away the database to build with fast-changing data. Keep the familiar SQL, keep the proven architecture of cloud warehouses, but swap the decades-old batch computation model for an efficient incremental engine to get complex queries that are always up-to-date. That is Materialize, the only true SQL... - Source: Hacker News / 12 months ago

Materialize | NY, NY | https://materialize.com/ The Cloud Database for Fast-Changing Data. We put a streaming engine in a database, so your team can build real-time data products without the cost, complexity, and development time of stream processing. Cloud team openings: https://grnh.se/0ad6ab6b4us Senior PM openings: https://grnh.se/415c267f4us. - Source: Hacker News / about 1 year ago