| 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. |