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.
- Difference between SQLite and Cassandra
- Difference between MySQL and SQLite
- Difference between SQLite and MariaDB
- Difference between SQLite and PostgreSQL
- Difference between SQLite and CouchDB
- Difference between SQLite and Couchbase
- Difference between SQLite and MS SQL Server
- Difference between PouchDB and SQLite
- Difference between SQLite and IBM DB2
- Difference between Derby and SQLite
- Difference between Elasticsearch and SQLite
- Difference between SQLite and dBASE
- Difference between Neo4j and SQLite
- Differences between SQL and SQLite
- How to pre populate database in Android using SQLite Database
- SQLite Statements or Syntax
- Difference between Oracle and MongoDB
- Difference between RDBMS and MongoDB
- Difference between PostgreSQL and MongoDB
- Difference Between Hadoop and MongoDB
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.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.