Questions tagged [dbslayer]

6 questions
27
votes
7 answers

Databases using JSON as storage/transport format

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…
Ionuț G. Stan
  • 176,118
  • 18
  • 189
  • 202
3
votes
2 answers

DBSlayer - what does it actually do?

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…
Max
  • 15,693
  • 14
  • 81
  • 131
1
vote
1 answer

Problem with truncation of floating point values in DBSlayer

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…
fadedbee
  • 42,671
  • 44
  • 178
  • 308
1
vote
1 answer

Current status of dbslayer?

Just that I've been researching for SQL solution for NodeJS and MySQL, and saw a lot of good things about dbslayer. But it's been more than 4 days that I couldn't connect to both code.nytimes.com and www.dbslayer.org, hence neither could I install…
user917099
  • 231
  • 3
  • 11
0
votes
1 answer

JSON, HighCharts/HighStock, DBSlayer - Data display

I have a MySQL database with some price data in it I would like to display using HighCharts/HighStock yet I'm not sure how I can actually go about getting this data from MySQL (via DBslayer as the JSON layer) and display in high charts (the example…
NightWolf
  • 7,694
  • 9
  • 74
  • 121
0
votes
2 answers

MySQL 1064 error, works in command line and phpMyAdmin; not in app

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 …
user128970