I don't have any experience with MongoDB, but the example put me off using it completely. The MySQL query is concise and brief, the MongoDB equivalent is bloated. Only after several seconds I was able to deduce that the MongoDB query probably does something more than MySQL query. Can you please make the examples more comparable? Or did I misunderstand the MongonDB and it actually is so bloated by design? I believe it is not your goal to discourage people from MongoDB , if so, better not do it unintentionally.
The default query already filled in is translating to the use of a Group function, which is a very bad idea. While not deprecated per se, its use is discouraged.<p>Group <i>does not function in Sharding mode at all</i>, it also takes a lock on the JavaScript interpreter making it non-parallelizable.<p>Map/Reduce is somewhat better in that it is shardable, and with V8 likely in the next stable release, will have better parallelization prospects.<p>Ideally, you should be using the new Aggregation Framework to do this kind of work: <a href="http://docs.mongodb.org/manual/applications/aggregation/" rel="nofollow">http://docs.mongodb.org/manual/applications/aggregation/</a><p>(EDIT) To clarify - Aggregation is ideal because its implementation is 100% in C++, meaning there are no JavaScript interpreter locks necessary to run it, so it is parallelizable. Additionally, one of the biggest overhead costs to MapReduce and Group in MongoDB is the translation back and forth between BSON (the native format MongoDB uses for data, or rather the C++ representations thereof) and JavaScript types. Aggregation not utilizing JavaScript eliminates this overhead and manipulates the database' internal types directly.
I've also found this diagram incredibly helpful translating from a SQL to map/reduce world.<p><a href="http://rickosborne.org/blog/2010/02/infographic-migrating-from-sql-to-mapreduce-with-mongodb/" rel="nofollow">http://rickosborne.org/blog/2010/02/infographic-migrating-fr...</a>
Not particularly useful, I tried a simple join and I got this error message:<p>Failure parsing MySQL query: Unable to convert queries based on more than one table
Very nice! I once thought about doing something like this, but I had some real work to do. Thanks for this resource!<p>This is specially useful because of the verbosity and ugliness of the "JSON" API (much more difficult to get right by hand than SQL) and because I found 0 working GUI tools to work with Mongo in a mac (they all crash at startup or after ~5 seconds of usage in a modern mac).
Nice work. Played around with it, and found that<p>SELECT *
FROM demo
WHERE score > 0 AND person LIKE '%bob%'<p>doesn't work that well. It will need to convert the %bob% thing to a regular expression.
Awesome! I haven't played around with NoSQL databases and I always wondered how you would query one. Definitely peaked my interest in the whole movement.