MongoDB _id field will be mapped to an SQL id column.Īt present, MoSQL does not support using the dot notation to accessĪs a shorthand, you can specify a one-element hash of the form name: TYPE, in which case name will be used for both the source attributeĪnd the name of the destination column. In the above example, the name andīio fields of the author sub-document will be expanded, and the Use of the :source attribute allows for renaming attributes, andĮxtracting elements of a nested hash using MongoDB'sĭot notation. :source: The name of the attribute inside of MongoDB.This hash may contain the following fields: :columns is a list of hashes mapping SQL column names to an hashĭescribing that column.
#Mongodb and postgresql full
This lets you run production services against a MongoDBĭatabase, and then run offline analytics or reporting using the full PostgreSQL instance, using an oplog tailer to keep the SQL mirror live MoSQL imports the contents of your MongoDB database cluster into a So, we thought, why can't we have the best of both worlds? Thus: We love the fact that virtually every employee we hireĪlready knows SQL and is comfortable using it to ask and answer To pull together reports summarizing properties across multipleĭatasets. We love the ease of doing ad-hoc dataĪnalysis over small-to-mid-size datasets in SQL. Placeholder parameters, or any of that nonsense. Language that doesn't require generating and parsing strings, tracking
We love the flexibility it gives us inĬhanging data schemas as we grow and learn, and we love its We would love for it to find a forever home with someone who can give it the love it needs!Īt Stripe, we love MongoDB. If you are interested in helping maintain this repository, please let us know. MoSQL is no longer being actively maintained. MoSQL: a MongoDB → SQL streaming translator
0 kommentar(er)
