Differences between SQL and SQLite
Last Updated :
13 Aug, 2020
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. |
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...