1. |
It was developed By D. Richard Hipp in August 2000. |
It was developed by Apache Software foundation and released in July 2008. |
2. |
SQLite is developed only in C language. |
Cassandra is also developed only in C language. |
3. |
It is widely used in-process RDBMS. |
It is wide-column store based on ideas of BigTable and DynamoDB. |
4. |
The primary database model for SQLite is RDBMS. |
The primary database model for Cassandra is Wide Column Store. |
5. |
SQLite does not require a server to run. Hence, it is serverless. |
Server operating systems for Cassandra are BSD, Linux, OS X and Windows. |
6. |
It supports secondary indexing. |
It supports secondary indexing but in a restricted way, i.e., only equality queries, not always the best performing solution. |
7. |
SQLite provides ACID transactions. |
Cassandra does not provide ACID transactions. |
8. |
It does not support any partitioning methods. |
In Cassandra, partitioning can be done using sharding. |
9. |
It does not support any replication methods. |
It support only one replication methods – Selectable Replication Factor. |
10. |
SQLite provides the concept of Referential Integrity and has Foreign Keys. |
Cassandra does not provide the concept of Referential Integrity. Hence, no Foreign Keys. |
11. |
It supports in-memory capabilities. |
It does not support in-memory capabilities. |
12 |
SQLite is a relational database that uses tables to store data, with columns and rows defining the schema. |
Cassandra, on the other hand, is a NoSQL database that uses a column-family data model, where data is organized into column families and columns, with each column containing a value for a specific attribute. |
13 |
SQLite is designed for single-machine use and does not scale horizontally, meaning that it cannot be used in a cluster |
designed to scale horizontally, with the ability to add nodes to a cluster to handle increasing amounts of data and traffic. |
14 |
SQLite is often used in small-scale applications that require a lightweight and embedded database, such as mobile apps or small websites. |
Cassandra is often used in large-scale distributed applications that require high availability and scalability, such as social media platforms or e-commerce websites. |