1. |
It was developed By D. Richard Hipp in August 2000. |
It was developed by Couchbase, Inc. and initially released in August 2011. |
2. |
SQLite is developed only in C language. |
Couchbase is written in C++, Erlang, C and Go languages. |
3. |
It is a widely used in-process RDBMS. |
It is a JSON-based document store derived from CouchDB with a Memcached-compatible interface. |
4. |
The primary database model for SQLite is RDBMS. |
The primary database model for Couchbase is Document Store. |
5. |
SQLite does not require a server to run. Hence, it is serverless. |
Server operating systems for Couchbase are Linux, OS X and Windows. |
6. |
It does not support any replication methods. |
It support two replication methods : Master-master replication and Master-slave replication. |
7. |
SQLite does not support Map Reduce method. |
Couchbase supports Map Reduce method. |
8. |
SQLite provides the concept of Referential Integrity and has Foreign keys. |
Couchbase does not provide the concept of Referential Integrity and has no Foreign keys. |
9. |
It does not support any partitioning method. |
In Couchbase, partitioning can be done by sharding. |
10. |
SQLite provides ACID transactions. |
Couchbase also provides ACID transactions. |
11. |
It does not support server-side scripting. |
It has functions and timers in JavaScript for Server-side scripts. |
12. |
SQLite does not support secondary indexes. |
Couchbase supports secondary indexes. |
13. |
SQLite has SQL support. |
Couchbase supports Declarative query language (N1QL) that extends ANSI SQL to JSON. |
14 |
SQLite is in the public domain and can be used without any licensing restrictions |
Couchbase is licensed under the Apache License, which is a liberal open-source license. |
15 |
SQLite is designed for single-machine use and is not suitable for large-scale deployments or high-traffic applications. |
Couchbase includes a built-in caching layer that can improve performance by keeping frequently accessed data in memory, while SQLite does not include a built-in caching layer
|