Best data type to store GEOMETRY data type

Hi all,

What is the best data type to store GEOMETRY data type in MemSQL?

As far as I know, MemSQL supports GEOGRAPHY data type.
But, GEOMETRY data type supports flat, or Euclidean (flat surface) data. and, the GEOGRAPHY data type stores elliptic (round surface) data such as GPS latitude and longitude coordinates.

If I store GEOMETRY type’s data in GEOGRAPHY data type, I think the calculation(such as distance) will be wrong. Please guide us which is the best DATA TYPE to store GEOMETRY data type.



We don’t support an explicit GEOMETRY data type. If you only need to do simple math, you can store two doubles, but if you need to do complex indexing, this is not supported unless you can map your domain onto a sphere.