Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

There is always http://querymongo.com/ which will convert SQL to a MongoDB query.


I actually dislike this tool a fair bit, because it gets people to continue thinking of Mongo as "Mysql plus WEB SCALE" or whatever. It's a totally different database and doesn't do well with highly-normalized relational-style data, and the idea of an "automated converter" seems to reinforce the idea that it's just a drop in for MySQL that automatically solves all your scaling woes, when that's just utterly and completely false.

Trying to shove a MySQL square into the Mongo triangle just isn't going to work out that well.


You mean SQL not MySQL.

Also that might be one thing it does but it also allows people to transition from SQL queries they know to mongodb queries. It helps the learning process.


No, I mean MySQL. The tool linked is specifically tooled for MySQL queries.

I fully support it as a learning tool, but Mongo's query language isn't all that hard to pick up if you already know how SQL works. Getting stuck into the mindset of "just write relational DB-oriented software and then generate some Mongo queries for it" is an awful practice that is sure to lead to much pain and suffering.


this is great, I've been looking for something like this




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: