MySQL offers Spacial Extensions to operate with points in a 2 dimensional space.
For a project I'm working on, I need to work with points in an N dimensional space and measure the distance among them. Is there a clever do to solve the following problem?: Let's say I have 4 3D point (X,Y,Z): (0,0,0), (1,1,1), (4,4,2), (-2,30,18) And for a new point (3, -1, 1.5), I need to know which of my other points are closer and what the distance is. Any clues? Thank you in advance, Jose.
