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. |
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.
Recommended Posts:
- Difference between SQLite and MS SQL Server
- SQL using Python and SQLite | Set 2
- SQL using C/C++ and SQLite
- Difference between Structured Query Language (SQL) and Transact-SQL (T-SQL)
- Difference between SQLite and Cassandra
- Difference between MySQL and SQLite
- Difference between SQLite and MongoDB
- Difference between SQLite and MariaDB
- Difference between SQLite and PostgreSQL
- Difference between SQLite and CouchDB
- Difference between SQLite and Couchbase
- Difference between PouchDB and SQLite
- Difference between SQLite and IBM DB2
- Difference between Derby and SQLite
- Difference between Elasticsearch and SQLite
- Difference between SQLite and dBASE
- Difference between Neo4j and SQLite
- Differences between Views and Materialized Views in SQL
- Introduction to SQLite
- How to pre populate database in Android using SQLite Database
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.
