Let Postgres Do the Work (2013)

Re:Let Postgres Do the Work (2013) by smac8 on Saturday November 26, 2016 @03:05PM (#13045580)

Cool, hadn't seen that. There is also postgraphql, which I have become a big fan of and is a great foundation:

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

[ Parent | on HN ]

Re:Let Postgres Do the Work (2013) by ianbicking on Saturday November 26, 2016 @05:33PM (#13046322)

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.

[ Parent | on HN ]

Re:Let Postgres Do the Work (2013) by smac8 on Saturday November 26, 2016 @08:13PM (#13047114)

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

[ Parent | on HN ]

Re:Let Postgres Do the Work (2013) by oomkiller on Monday November 28, 2016 @12:48PM (#13057039)

Unfortunately NOTIFY doesn't work across nodes.

[ Parent | on HN ]