3 ms·
Lambdas would be nice, as the author says there are external options. Postgres has the notify function that lets you build this sort of thing. https://gist.git
by xupybd 6y ago
Lambdas would be nice, as the author says there are external options. Postgres has the notify function that lets you build this sort of thing.
https://gist.github.com/colophonemes/9701b906c5be572a40a84b08f4d2fa4e https://gist.github.com/colophonemes/9701b906c5be572a40a84b0...
- UglyToad 6y agoThanks, I didn't know about this. I've been trying in vain to find something similar for MySQL. I think Lambdas are the killer feature that's missing from databases, you'd basically be able to handle all cache-invalidation / notification systems etc easily from the database layer, it would drastically simplify large numbers of common CRUD web-app problems.
- eloff 6y agoThe problem with notify is it can miss notifications if the connection drops (e.g. you restart the application process, server, or database), and I think also if there are too many notifications. It's only really useful for things that should happen, not for things that must happen.