MongoDB for SQL developers
MongoDB was developed in the Web 2.0 era. By then, most developers were using SQL or object-relational mapping (ORM) tools from their language of choice to access RDBMS data. As such, these developers needed an easy way to get acquainted with MongoDB from their relational background.
Thankfully, there have been several attempts at making SQL-to-MongoDB cheat sheets that explain the MongoDB terminology in SQL terms.
On a higher level, we have the following:
- Databases and indexes (SQL databases)
- Collections (SQL tables)
- Documents (SQL rows)
- Fields (SQL columns)
- Embedded and linked documents (SQL joins)
Further examples of common operations in SQL and their equivalents in MongoDB are shown in the following table:
Table 1.1 – Common operations in SQL/MongoDB
A few more examples of common operations can be seen at https://s3.amazonaws.com/info-mongodb-com/sql_to_mongo.pdf.
Next, we will check out the features that MongoDB has brought for NoSQL developers.
