Human geography examines the dynamics of cultures, societies and economies, and physical geography examines the dynamics of physical landscapes and the environment.
In this blog i am going to explain what are the new Geography features available in MySQL 8.0
Major Difference in MySQL 5.7 & 8.0 Geography :
There is a big change from MySQL 5.7 to 8.0 when it comes to spatial data, it’s support, multiple spatial reference systems and geographic computations.
This means that the SRIDs of geometries actually have meaning and affect computations. In 5.7 and earlier, however, the SRIDs(spatial reference identifier) are ignored, and all computations are Cartesian.
What’s new in MySQL 8.0?
* Introduced ellipsoid computation instead of flat plane cartesian.
* Introduced multiple spatial reference …[Read more]