The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.

Marius M. (2) [Avatar] Offline
#1
Could be PostGIS + PostgreSQL a good choice to:

1. Store more than 5 million moving objects changing Latitude + Longitude in real time;
2. Fast processing queries;
3. Calculate radius around moving objects;
4. Distance on the streets between moving objects (North America);
5. Placing the moving objects on a map.
regina.leo (265) [Avatar] Offline
#2
Yes. Several companies use it for that, e.g.

collecting massive streams of GPS data in real-time, doing spatial analysis on that data (I think PostGIS is the fastest relational spatial engine even when compared to commercial offerings), and also showing on map in real-time.
Marius M. (2) [Avatar] Offline
#3
Wonderful,

Appreciate for fast reply smilie