News for hackers. Stuff that matters.
Re:Reactive PostgreSQL for Meteor by buckbova on Thursday April 16, 2015 @12:03PM (#9388880)
Creating views and triggers on the fly does sound like insanity. There's got to be a better way.
Re:Reactive PostgreSQL for Meteor by nunwuo on Thursday April 16, 2015 @12:17PM (#9388963)
There is: logical decoding http://www.postgresql.org/docs/9.4/static/logicaldecoding.ht... I wonder why the author chose to waste time on this instead of doing things the proper way.
Re:Reactive PostgreSQL for Meteor by numtel on Thursday April 16, 2015 @06:32PM (#9391118)
See this issue: https://github.com/numtel/pg-live-select/issues/1

I would love to see a pull request for the "proper way." Thank you for your help.

Re:Reactive PostgreSQL for Meteor by justinsb on Thursday April 16, 2015 @02:02PM (#9389636)
Logical decoding was only recently added in Postgres (9.4)? I'm not sure on the privileges required for logical decoding in postgres, but typically it requires 'root' access because it lets you see all the data in the system. So triggers can often be used on a shared database, where you might not be allowed to access the transaction log.
Re:Reactive PostgreSQL for Meteor by ivarv on Thursday April 16, 2015 @01:03PM (#9389244)
I'd guess ignorance? I'd never heard of 'logical decoding' before and the name of the feature doesn't lend itself to easy understanding.

That said, thanks for pointing this out - it looks like yet another very useful PG feature!

Re:Reactive PostgreSQL for Meteor by hammerandtongs on Thursday April 16, 2015 @01:13PM (#9389314)
At times it feels as if the entire Nosql industry was created by people not reading the Postgresql manual.

edit: thanks for the link to logical decoding, looks very useful.

Re:Reactive PostgreSQL for Meteor by 15155 on Thursday April 16, 2015 @12:15PM (#9388954)
Create triggers, fire all events off to a proper message broker for fanout.

Events can be triggered directly in PG using an extension for AMQP or something, or in a standalone service, using whatever you can dream up.