RethinkDB, SageMath, Andreessen-Horowitz, Basecamp and Open Source Software

Re:RethinkDB, SageMath, Andreessen-Horowitz, Basecamp and Op... by tiglionabbit on Friday October 07, 2016 @05:59PM (#12664234)

I've never done it, but I think it's possible to do this in Postgres as well using LISTEN and NOTIFY. You may want to do all of your database mutations through functions that ultimately call NOTIFY for this to work though. But uh, that's how you'd do it in postgraphql or postgrest anyway.

https://github.com/calebmer/postgraphql

http://postgrest.com/

[ Parent | on HN ]

Re:RethinkDB, SageMath, Andreessen-Horowitz, Basecamp and Op... by bjt on Friday October 07, 2016 @06:27PM (#12664400)

You can definitely use LISTEN and NOTIFY to watch for changes in Postgres. Here's a presentation I did on that last year, though oriented more towards web apps than analytics. https://www.youtube.com/watch?v=PsorlkAF83s

For analytics I would want stronger guarantees than LISTEN and NOTIFY alone can provide. I explore options for that here: http://btubbs.com/streaming-updates-from-postgres.html

[ Parent | on HN ]