---
title: "Difference between SQL and SQLite"  
description: "The various difference SQL and SQLite database are - SQL   SQL is a structured query language which is used to query a database which is usually Relat"  
author: "Prateek sharma"  
published: 2018-01-25  
updated: 2018-01-25  
canonical: https://www.mindstick.com/blog/11668/difference-between-sql-and-sqlite  
category: "android apps"  
tags: ["android", "sql", "sqlite"]  
reading_time: 1 minute  

---

# Difference between SQL and SQLite

The various difference SQL and [SQLite database](https://www.mindstick.com/articles/1554/crud-operation-in-asp-dot-net-using-sqlite-database) are -

**SQL** \

1. SQL is a structured [query language](https://www.mindstick.com/forum/158386/what-is-the-purpose-of-the-sqlite-query-language-and-how-does-it-differ-from-other-sql-dialects) which is used to query a database which is usually [Relational Database](https://www.mindstick.com/forum/158346/what-is-sql-server-and-how-does-it-differ-from-other-relational-database-management-systems) Systems.
2. It is a standard which specifies how the data is inserted or how a relational schema or table is created.
3. Some of the [SQL databases](https://www.mindstick.com/forum/160340/how-does-horizontal-scalability-differ-in-nosql-databases-compared-to-traditional-sql-databases) are MySQL, Oracle, [Microsoft SQL](https://www.mindstick.com/forum/159597/my-sql-server-vs-microsoft-sql-server-which-one-better) Server, etc.
4. Ways to write the query is same in both the SQL and SQLite.
5. Some components of SQL are DDL (Data Definition Language), DML (Data Manipulation Language) etc.

## SQLite

1. SQLite is an embedded relational [database management](https://www.mindstick.com/forum/34816/what-is-mapping-constraints-in-database-management-system) system which is written in ANSI-C.
2. SQLite is file-based whereas SQL is a server based.
3. SQLite does not support [stored procedures](https://www.mindstick.com/forum/540/using-stored-procedures-with-entity-framework-in-an-asp-dot-net-application).
4. SQLite is the lite form of SQL which runs on low powered devices or the devices with low memory such as [mobile devices](https://yourviews.mindstick.com/view/85524/influence-of-mobile-devices-on-travel-and-tourism-experiences), PDAs or pocket music players etc.

---

Original Source: https://www.mindstick.com/blog/11668/difference-between-sql-and-sqlite

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.