numtel/pg-live-select
View on GitHub ↗ ★ 54 JavaScript
Live Updating PostgreSQL SELECT statements
5 mentions on Hacker News by 2 people: 0 stories, 5 comments · first 2015-04-16 · latest 2021-04-23
20082026
-
…cache invalidation functions for each dependent table. https://github.com/numtel/mysql-live-select https://github.com/numtel/pg-live-select
comment by numtel · 2021-04-23 · in Ask HN: Is there a way to efficiently subscribe to an SQL query for changes? -
I got around the 8000 byte limit by sending multiple notifications in this NPM package: https://github.com/numtel/pg-live-select/blob/master/lib/tri... Reading the replication log is probably faster though. MySQL has row-based replication…
comment by numtel · 2020-01-22 · in Show HN: Realtime Postgres -
…a node.js package a few years ago that gets past the 8000 bytes by sending multiple notifications. https://github.com/numtel/pg-live-select
comment by numtel · 2019-10-27 · in Rxdb: A reactive database where you can subscribe to the result of a query -
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.
comment by numtel · 2015-04-16 · in Reactive PostgreSQL for Meteor -
…using meteor, but are interested in using this in node, take a look at the library it's built on: https://github.com/numtel/pg-live-select At a glance it looks like it creates triggers on the fly and tears them down. I'm curious how…
comment by netghost · 2015-04-16 · in Reactive PostgreSQL for Meteor