MongoDB was developed in the Web 2.0 era. By then, most developers had been 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 SQL to MongoDB cheat sheets that explain MongoDB terminology in SQL terms.
On a higher level there are:
- Databases, indexes just like in SQL databases
- Collections (SQL tables)
- Documents (SQL rows)
- Fields (SQL columns)
- Embedded and linked documents (SQL Joins)
Some more examples of common operations:
|
SQL |
MongoDB |
|
Database |
Database |
|
Table |
Collection |
|
Index |
Index |
|
Row |
Document |
|
Column |
Field |
|
Joins |
Embed in document or link via DBRef |
|
CREATE TABLE employee (name VARCHAR(100)) |
db.createCollection("employee") |
|
INSERT INTO employees VALUES (Alex, 36) |
db.employees.insert({name: "Alex", age: 36}) |
|
SELECT * FROM employees |
db.employees.find() |
|
SELECT * FROM employees LIMIT 1 |
db.employees.findOne() |
|
SELECT DISTINCT name FROM employees |
db.employees.distinct("name") |
|
UPDATE employees SET age = 37 WHERE name = 'Alex' |
db.employees.update({name: "Alex"}, {$set: {age: 37}}, {multi: true}) |
|
DELETE FROM employees WHERE name = 'Alex' |
db.employees.remove({name: "Alex"}) |
|
CREATE INDEX ON employees (name ASC) |
db.employees.ensureIndex({name: 1}) |