How many database systems there are that use JSON for storage or transport? I know of:
CouchDB
MongoDB
DBSlayer
I remember I saw yet another vendor in a SO user's profile. That systems was using what they called binary JSON, but I can't remember the name of the product.
Lately, it appears that more and more DB projects are looking t...
Here is my query:
select *
from (select *, 3956 * 2 * ASIN(SQRT(POWER(SIN(RADIANS(45.5200077 - lat)/ 2), 2) + COS(RADIANS(45.5200077)) * COS(RADIANS(lat)) * POWER(SIN(RADIANS(-122.6942014 - lng)/2),2))) AS distance
from stops
order by distance, route asc) as p
group by route, dir
order by distance asc
limit 10...
I recently stumbled across DBslayer (http://code.nytimes.com/projects/dbslayer/wiki/WhyUseIt) and wondered what is the actual benefit of using it as an interface to mysql.
As far as I understand, it runs as some kind of proxy for mysql and offers a HTTP / JSON interface. So? Why should I use this setup instead of connecting directly to...
When I run a query through DBslayer http://code.nytimes.com/projects/dbslayer the floating point results are
truncated to a total of six digits (plus decimal point and negative
sign when needed).
{ ... "lat":52.2228,"lng":-2.19906, ... }
When I run the same query in MySQL, the results are as expected.
| 52.22280884 | -2.19906425 ...