Difference between SQLite and MongoDB

1. SQLite :
SQLite is a software library that provides relational database management system (RDBMS). It was designed by D. Richard Hipp on August 2000. The design goals of SQLite were to allow program to be operated without installing database management system (DBMS) or requiring database administrator.

2. MongoDB :
MongoDB is an open-source document-oriented database used for high volume data storage. It falls under classification of NoSQL database. NoSQL tool means that it doesn’t utilize usual rows and columns. MongoDB uses BSON (document storage format) which is binary style of JSON documents.



Difference between SQLite and MongoDB :

S.NO. SQLITE MONGODB
1. Developed by D. Richard Hipp on August 2000. Developed By MongoDB, Inc on 2009.
2. It is widely used in-process RDBMS. It is one of the most popular document stores available both as fully managed cloud service and for deployment on self-managed infrastructure.
3. The primary database model for SQLite is Relational DBMS. The primary database model for MongoDB is Document store.
4. It has no Secondary database models. It has Document store as Secondary database models.
5. SQLite is developed only in C language. MongoDB is developed only in C++ language.
6. SQLite does not require a server to run. Hence, it is serverless. Server operating systems for MongoDB are Linux, OS X, Solaris and Windows.
7. It does not support Server-side scripting. It has Javascript for Server-side scripts.
8. It supports SQL query language only. It supports JSON query language along with SQL.
9. It does not support any replication methods. It support only one replication methods – Master-master replication.
10. It does not support any Partitioning methods. In MongoDB, partitioning can be done by Sharding.
11. SQLite does not supports Map Reduce method. MongoDB supports Map Reduce method.
12. SQLite provides the concept of Referential Integrity and have Foreign keys. MongoDB does not provides the concept of Referential Integrity. Hence, no Foreign Keys.

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up

Small things always make you to think big

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.