3 ms·
I'd love to see something that makes use of realtime geofence hooks http://tile38.com/commands/sethook/ http://tile38.com/commands/sethook/
by billylindeman 9y ago
I'd love to see something that makes use of realtime geofence hooks http://tile38.com/commands/sethook/ http://tile38.com/commands/sethook/
- petre 9y agoI think you can write a trigger procedure and use the listen/notify mechanism for notifications. Both exist since 9.3. https://www.postgresql.org/docs/current/static/plpgsql-trigger.html https://www.postgresql.org/docs/current/static/plpgsql-trigg... https://www.postgresql.org/docs/current/static/sql-listen.html https://www.postgresql.org/docs/current/static/sql-listen.ht... Web-based notification is pretty much trivial after that since you need a database client written in a language of your choice that forwards the notification via HTTP to some endpoint. It's not as trivial as the tile38 but it can be more powerful since you can add any type of geometry to your POI. For instance you want to be notified when a vehicle crosses state borders.