sathorn's comments

sathorn | 4 years ago | on: Ask HN: Is there a way to efficiently subscribe to an SQL query for changes?

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

sathorn | 5 years ago | on: Chatmosphere

> 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?

sathorn | 5 years ago | on: SLS vs. Starship

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/

sathorn | 5 years ago | on: Launch HN: Gather.Town (YC S19) – Spatial video chat for remote teams

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

sathorn | 5 years ago | on: Calla – spatial video conferencing software based on Jitsi Meet

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.

sathorn | 5 years ago | on: Calla – spatial video conferencing software based on Jitsi Meet

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

sathorn | 5 years ago | on: Calla – spatial video conferencing software based on Jitsi Meet

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.

sathorn | 5 years ago | on: Applying “make invalid states unrepresentable”

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.

sathorn | 5 years ago | on: Launch HN: Rally.Video (YC S20) – Dynamic video platform for social groups

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?