News for hackers. Stuff that matters.

A comment on Postgres geography type is not limited to Earth. Parent comment

Re:Postgres geography type is not limited to Earth by bad_alloc on Sunday August 20, 2017 @08:54PM (#15061157)
> what if I'm tracking objects in interplanetary space?

I guess you'd just want to store the orbital information of that object, as it probably won't stay at a fixed position.

[ Parent | on HN ]
Re:Postgres geography type is not limited to Earth by askvictor on Sunday August 20, 2017 @09:16PM (#15061256)
Indeed; does that mean such a database would need to run an n-body simulation to determine where one object is compared to another at a given time?
[ Parent | on HN ]
Re:Postgres geography type is not limited to Earth by Demiurge on Monday August 21, 2017 @02:51AM (#15062459)
That would require arbitrary telemetry and possibly non-deterministic solution, or something like SPICE(https://naif.jpl.nasa.gov/naif/toolkit.html) which is a bit too far outside of 'database' domain.
[ Parent | on HN ]