Menu
I am getting multiple similar JSON object from a remote site and looking to store them in a local MongoDB.
What would be the best way to do this ? (Preferably via Mongoid or Mongo-mapper gems)
Thanks
281
Does MongoDB use BSON or JSON? MongoDB stores data in BSON format both internally, and over the network, but that doesn't mean you can't think of MongoDB as a JSON database. Anything you can represent in JSON can be natively stored in MongoDB, and retrieved just as easily in JSON.
SQL Server and Azure SQL Database have native JSON functions that enable you to parse JSON documents using standard SQL language. You can store JSON documents in SQL Server or SQL Database and query JSON data as in a NoSQL database.
PostgreSQL offers two types for storing JSON data: json and jsonb . To implement efficient query mechanisms for these data types, PostgreSQL also provides the jsonpath data type described in Section 8.14. 7. The json and jsonb data types accept almost identical sets of values as input.
JSON is a great format to store data, widely used in JavaScript but not only - discover all about it! JSON is a file format that's used to store and interchange data. Data is stored in a set of key-value pairs. This data is human readable, which makes JSON perfect for manual editing.
You can use a mongoid field of type Hash or an embedded document.
class MyModel
include Mongoid::Document
field :some_data, :type => Hash
end
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
