Raw mongodb query in rails

Question

I have a Rails/Mongoid app that displays data client-side using highcharts. Right now, to pass the data to Javascript, I use a Mongoid query and Rails' as_json/to_json in the template file. This seems very inefficient to me because the json data has to be parsed into ruby structures, and then re-converted to JSON. This is okay when there is a small amount of data, but in my case, there can be a lot.

So my question is, how can I do a raw mongodb query, and just write the output directly to the Rails response buffer without going through Ruby JSON serialization/deserialization?

can you provide some examples?

Vasiliy Ermolovich
– Vasiliy Ermolovich

2011-04-23 12:34:25 +00:00
Commented Apr 23, 2011 at 12:34 — Vasiliy Ermolovich
– Vasiliy Ermolovich, Commented Apr 23, 2011 at 12:34

Roman · Accepted Answer · 2011-04-23 12:43:15Z

3

The data in MongoDB is stored in BSON, which is not JSON. The ruby driver does deserialization (BSON::BSON_CODER.deserialize) in read_documents method. If you'd like to roll your own BSON-to-JSON, you'll need your implementation of BSON::BSON_coder.deserialize, and, probably, rewrite more parts in mongo-ruby driver. If, however, this is a overhead that's acceptable, then you'll just subclass ActionController::Metal and do something like this:

class ChartController < ActionController::Metal
  def chart
    res = fetch_data_from_mongodb
    self.content_type = 'application/json'
    self.response_body = res.to_json
  end
end

Another alternative might be using the MongoDB's REST HTTP interface, which provides JSON. But you'll have to have some access control in your application, and, basically, proxy requests.

answered Apr 23, 2011 at 12:43

Roman

13.1k4 gold badges50 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Raw mongodb query in rails

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related