SQL or MongoDB which is Best ?

Answer 1

this is not a question of "which is best"

this is a question of "which is best for my needs from the app"

here is some reading material for choosing between relational DB (SQL) and document based DB (NoSQL, MongoDB)

https://www.sitepoint.com/sql-vs-nosql-choose/

https://medium.com/xplenty-blog/the-sql-vs-nosql-difference-mysql-vs-mongodb-32c9980e67b2

https://blog.jooq.org/2016/09/28/when-to-choose-sql-and-when-to-choose-nosql/

https://dzone.com/articles/when-use-mongodb-rather-mysql

Answer 2

SQL is great with php. Mongodb with django might be cool.

Answer 3

SQL is great I would say, with huge community support you can get help easily whereas monoDB is not that famous.

Answer 4

oh btw, mongodb university is running free 8 weeks online course that you can register , u ll get certified after the end exam , in May I guess

course is pretty easy and fun I did the whole first one week course today morning itself, so it wouldnt be much of an issue.

just pick ur platform i.e nodejs, .net , java , etc and start the course.

you ll be able to tell the differences yourself

Answer 5

@just read the 4 article links by Burey they are awesome, heres few key takeaways.

SQLs big player is MySql
NoSqls big player is MongoDB

SQL works good when you have a known and non changing schema, as in legacy applications.

NoSQL is very easy to begin with hence everybody should start their first CRUD operations with mongoDB , learning curve is gentle.

mongoDB is quite scalable , with on the fly schema design possibilities.

SQL scales vertically i.e. you keep adding disks to same server, which is restrictive.
NoSQL scales horizontally i.e you add servers which is much beneficially from many points of view.

SQL perform better in most operations but NoSQL performs better in insert operations.

So study SQL if you have to forcefully otherwise go download mongoDb & robomongo( GUI for mongoDB) or make your own free 500 mb remote mongoDB at mlabs for testing.

👍

Answer 6

i am working on web development by python using flask some say MongoDB in that case would be easier... confused

Answer 7

Thanks will see through see this ☺

Answer 8

All of those use SQL. The only thing different might be a slight dialect. The real difference is the way the database operates.

Answer 9

Thanks for that too ☺