Difference between SQLite and CouchDB

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.

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.