Re:Tile38 – Realtime geofencing and geospatial index, v1.11.0
by petre on Tuesday March 06, 2018 @12:59AM
(#16527165)
It's nice but it's kind of limited to simple apps. No polygon or geocorridor points of interest and you'd need a database anyway to store historic data. For anything more complex tgan point on map apps, I'd use PostgreSQL + PostGIS.
[ Parent
| on HN ]
Re:Tile38 – Realtime geofencing and geospatial index, v1.11.0
by billylindeman on Tuesday March 06, 2018 @01:23AM
(#16527243)
I'd love to see something that makes use of realtime geofence hooks http://tile38.com/commands/sethook/
Re:Tile38 – Realtime geofencing and geospatial index, v1.11.0
by petre on Tuesday March 06, 2018 @04:04AM
(#16527745)
I 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-trigg...
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.