Open In App

Difference between SQLite and CouchDB

Improve
Improve
Like Article
Like
Save
Share
Report

1. SQLite : 

SQLite is a software library that provides a relational database management system (RDBMS). It was designed by D. Richard Hipp on August 2000. The design goals of SQLite were to allow the program to be operated without installing a database management system (DBMS) or requiring a database administrator. The lite in SQLite means light weight in terms of setup, database administration, and required resource. 

2. CouchDB : 

Apache CouchDB is an open-source document-oriented NoSQL database that uses multiple formats and protocols to store, transfer, and process its data, it uses JSON to store data, JavaScript as its query language using MapReduce, and HTTP for an API. It was developed by Apache Software Foundation and initially released in 2005. It is written in Erlang. 

Difference between SQLite and CouchDB :

S.NO. SQLITE COUCHDB
1. Developed By D. Richard Hipp on August 2000. Developed by Apache Software Foundation and initially released in 2005.
2. SQLite is developed only in C language. CouchDB is written in Erlang.
3. It is widely used in-process RDBMS. A native JSON – document store inspired by Lotus Notes, scalable from globally distributed server-clusters down to mobile phones.
4. The primary database model for SQLite is Relational DBMS. The primary database model for CouchDB is Document Store.
5. SQLite does not require a server to run. Hence, it is serverless. Server operating systems for CouchDB are Android, BSD, Linux, OS X, Solaris and Windows.
6. In SQLite, Data Schema is fixed. CouchDB is Data Schema free.
7. SQLite have predefined datatypes such as float, date, number, etc. In CouchDB there is no predefined datatypes.
8. It does not supports XML format. It does not supports XML format.
9. It does not support any replication methods.

It support two replication methods –

  • Master-master replication
  • Master-slave replication
10. SQLite provides ACID transactions. CouchDB does not supports ACID transactions.
11. SQLite does not supports Map Reduce method. CouchDB supports Map Reduce method.
12. SQLite provides the concept of Referential Integrity and have Foreign keys. CouchDB does not provides the concept of Referential Integrity. Hence, no Foreign Keys.
13. Does not have any partitioning methods. Supports partitioning methods such as sharding.

Last Updated : 07 Jul, 2022
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads