HNHacker News
TopNewBestAskShowJobs

sathorn

14 karma · joined February 1, 2020

submissionscomments
sathorn··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··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··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··on Launch HN: Gather.Town (YC S19) – Spatial video chat for remote teams
And (shamelessly my own): https://cyberparty.io/
sathorn··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··on Calla – spatial video conferencing software based on Jitsi Meet
This is cool! I've been working on something similar: https://cyberparty.io/
sathorn··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··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··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?