Social Networks for the life of the world
Wall Street, lately, has been using high-speed trading to allow insiders to front-run trades by ordinary investors. So, for example, when an outfit like TIAA-CREF (pension funds for teachers) tries to place an order to buy shares of a company they like, other investors’ computers can detect the trade before it happens, buy the shares, … Read more
This Vincenty formula is a more numerically stable version of the spherical cosine law formula (commonly and wrongly known as the Haversine formula) for computing great circle distances. The question of numerical stability comes up specifically when the distances between points are small. In those cases the cosine is very close to 1, so the … Read more
It’s possible to use the geospatial extension in MySQL for an efficient location finder. For this to be worth the trouble, the following conditions must hold. You must use a MyISAM table for your geospatial data, or use version 5.7.5 or later of MySQL. A NOT NULL qualification on your geometry column is required A … Read more
In another article I described the process of using MySQL to compute great-circle distances between various points on the earth then their latitudes and longitudes are known. To do this requires the formula commonly called the haversine formula. It’s actually the spherical cosine law formula, and is shown here. There’s a more numerically stable formula — … Read more