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 :
|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.|
|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.