Differences between SQL and SQLite
1. Structured Query Language (SQL) :
SQL stands for Structured Query Language. SQL can access, created and manage databases. SQL has became standard of American National Standards Institute.
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 | 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. |