2. SQLite :
SQLite is software which provides relational database management system. SQLite lightweight in terms of setup, database administration, and required resources. SQLite has features like self-contained, server-less, zero-configuration, etc.
Differences between SQL and SQLite :
|SQL is Structured Query Language used to query Relational Database System. It is written in C language.||SQLite is an Relational Database Management System which is written in ANSI-C.|
|SQL is standard which specifies how relational schema is created, data is inserted or updated in relations, transactions are started and stopped, etc.||SQLite is file-based. It is different from other SQL databases because unlike most other SQL databases, SQLite does not have separate server process.|
|Main components of SQL are Data Definition Language(DDL), Data Manipulation Language(DML), Data Control Language(DCL).||SQLite supports many features of SQL and has high performance but does not support stored procedures.|
|SQL is Structured Query Language which is used with databases like MySQL, Oracle, Microsoft SQL Server, IBM DB2, etc.||SQLite is portable database resource. It could get an extension in whatever programming language used to access that database.|
|A conventional SQL database needs to be running as service like OracleDB to connect to and provide lot of functionalities.||SQLite database system does not provide such functionalities.|
|SQL is query language which is used by other SQL databases. It is not database itself.||SQLite is relational database management system itself which uses SQL.|
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.