Re:Postgres geography type is not limited to Earth
by ianai on Sunday August 20, 2017 @07:31PM
(#15060799)
Yes but the ability to have this add on is a deep feature of Postgresql missing from other RDBMS
[ Parent
| on HN ]
Re:Postgres geography type is not limited to Earth
by nimchimpsky on Sunday August 20, 2017 @11:46PM
(#15061779)
its not missing from sql server, or oracle.
Re:Postgres geography type is not limited to Earth
by nodesocket on Monday August 21, 2017 @12:22AM
(#15061906)
Geo/GIS is an area where SQL Server and Oracle have a solid lead over MySQL and PostgreSQL. Oracle especially handles GIS data extremely well.
Re:Postgres geography type is not limited to Earth
by vetinari on Monday August 21, 2017 @06:08AM
(#15063341)
Oracle Spatial isn't that different, compared to PostGIS. Except for license fees, of course.
Meanwhile, they both are missing the concept of spatial contexts.
Re:Postgres geography type is not limited to Earth
by anc84 on Monday August 21, 2017 @05:20AM
(#15063114)
Benchmarks and proof on Oracle handling GIS data better than PostGIS please.
Re:Postgres geography type is not limited to Earth
by nimchimpsky on Monday August 21, 2017 @08:34AM
(#15064071)
sql server does. We benchmarked it at work.
If you are that interested do your own tests.
Re:Postgres geography type is not limited to Earth
by anc84 on Monday August 21, 2017 @09:08AM
(#15064255)
Good for you but I did not ask for stranger's anecdotes. Everything I find online does not support your point so I cannot take your word for it.
Re:Postgres geography type is not limited to Earth
by nimchimpsky on Monday August 21, 2017 @09:56PM
(#15069173)
I'm not asking you to take my word for it, I'm suggesting you test it yourself using your typical use case.
Re:Postgres geography type is not limited to Earth
by anc84 on Tuesday August 22, 2017 @07:01AM
(#15071212)
And I have neither the time nor the resources to do that comprehensively.
Re:Postgres geography type is not limited to Earth
by haskal on Monday August 21, 2017 @03:29PM
(#15067088)
For a person who is relying on benchmarks, you should know that benchmarks are only a rough indication of how well anything performs for a very specific use case.
Your reply is arrogant and ignorant, and you should feel bad about typing that.
> If you are that interested do your own tests.
Why is he not allowed to review your results or check what factors you benchmarked it on? If there's no citation, that claim does not stand.
Re:Postgres geography type is not limited to Earth
by nimchimpsky on Monday August 21, 2017 @09:52PM
(#15069158)
lol
Re:Postgres geography type is not limited to Earth
by chillydawg on Monday August 21, 2017 @08:07AM
(#15063923)
To be fair, Oracle is usually extremely good at most of the stuff it does. I've no idea about GIS specifically, but, generally, you get what you pay for.