There is also the research DB Noria[0] that's based on this idea. It maintains materialized views for queries and efficiently updates them when the data changes.

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

the cool thing with noria is that it behave like a cache.

So it only store the row from the materialized view that are frequently needed instead of storing the complete materialized view.

But if you query for a row which is missing it will rematerialize this row on demand with "up-query" without having to run the expensive query that a materialized view refresh normally need.

This approach would be cool if it ran on a database on the frontend too. You could run a complex query against an in-browser DB with a few joins and some params, and then tweak the params, and it would only need to pull down the missing rows. Then your app is offline and super snappy.

Noria looks cool but it requires Zookeeper which is a PITA.

> Gather.town is trying to do this, but I didn't like their implementation when I last checked it.

AFAIK they embed games / etc. in an iframe. What didn't you like about that?

The implementation was buggy and the interaction between the virtual world and games was unintuitive. A better interface would seemlessly embed the games into the virtual world (perhaps inside a "picture frame" or "portal"). This isn't an aesthetic complaint. It would mean that spectators could walk by and see what is going on in the games - just like peeking around a space in real life.

The F1 isn't superior to the SSME. It doesn't really excel at anything (other than being very big maybe.)

From another article on that website: "The RS-25 is still considered to be about the best engine ever made with a fairly high thrust to weight ratio and unmatched efficiency." [1]

[1] https://everydayastronaut.com/raptor-engine/

IIRC the F1 still holds a few thrust records (thrust per one engine maybe ?) but is certainly much less efficient than modern engines from Spacex/Ble Origin & Russian construction bureaus (much worse ISP & TVR).

And (shamelessly my own): https://cyberparty.io/

Well, I built exactly that thing at cyberparty.io!

The video is 320x240 and one stream is about 600 kbit/s and audio is another 30 kbit/s.

So yeah, that works fine for a few users that have maybe 5 mbit/s upstream.

This is cool! I've been working on something similar: https://cyberparty.io/

True, video chat is very expensive especially with the extreme bandwidth costs of the big cloud providers.

I built something similar as OP and chose a mesh solution for this reason even though it's inferior.

It appears that only big video chat companies like Zoom or Skype can afford to have a generous free tier, subsidized by their business offerings.

They build their own DCs, and use cloud as a peak-smoother.

No one doing serious amounts of bandwidth pay outrageous big cloud prices. See: netflix.

This might make sense for a transport schema because you can receive messages from the past or the future but it does not translate to internal program state or database schemas where this is not the case.

Making invalid states unrepresentable is basically the process of taking human-checked invariants and turning them into type-checked invariants. This reduces the likelihood of bugs and guides humans to use the system correctly.

Cool product! I've actually been working on something somewhat similar (WIP: https://cyberparty.io/).

Have you considered or tried playing background music to get more of a bar atmosphere?

We have! We should also chat if you want - ali@rally.video