News for hackers. Stuff that matters.

A comment on In Praise of PostgreSQL. Parent comment

Re:In Praise of PostgreSQL by SahAssar on Friday August 06, 2021 @05:48AM (#28085066)
> But I cannot think of a PostgreSQL project that would not also have worked great in MySQL or a MySQL project that could not have been done with PostgreSQL.

Can MySQL do GIS related features like PostGIS? Also IIRC to index JSON in MySQL you need to add generated columns for all the properties/paths you want to index, which can get pretty hairy.

[ Parent | on HN ]
Re:In Praise of PostgreSQL by dagw on Friday August 06, 2021 @06:43AM (#28085397)
Can MySQL do GIS related features like PostGIS?

It can[1] for most of the common cases, but it lacks many of the more advanced features PostGIS has.

So if you have a MySQL database up and running, you probably don't have to switch to PostGIS just because you want to add some geospatial data. However if starting a new geospatial project then you should almost certainly choose PostGIS.

[1] https://dev.mysql.com/doc/refman/8.0/en/spatial-types.html

[ Parent | on HN ]