Hacker News new | ask | show | jobs
by oomkiller 3494 days ago
Doesn't include everything that Horizon does, but it provides a good foundation for building it http://postgrest.com/
1 comments
smac8 3494 days ago
Cool, hadn't seen that. There is also postgraphql, which I have become a big fan of and is a great foundation:

https://github.com/calebmer/postgraphql

That said, the real-time aspect is what I'm really dying for, plus a company supporting a BAAS. The ease of firebase is so nice, and you can make really cool real time apps with it very fast. I'm not sure if switching to a relational model would make impose some technical limitation that json stores don't (besides obvious complexity). Postgraphql + socket.io is kind of what i'm thinking is the start

link
ianbicking 3494 days ago
Some clever use of NOTIFY might help with real-time? It's basically publish/subscribe directly in Postgres itself, but I've never actually used it.
link
smac8 3494 days ago
I had forgotten about this actually. Thanks for the reminder :) Curious if anyone has tried using this for real time apps and what their experience was
link
oomkiller 3492 days ago
Unfortunately NOTIFY doesn't work across nodes.
link