---
title: "what is the difference between sql and sqlite?"  
description: "what is the difference between sql and sqlite?"  
author: "Prateek sharma"  
published: 2018-04-06  
canonical: https://answers.mindstick.com/qa/40985/what-is-the-difference-between-sql-and-sqlite  
category: "android"  
tags: ["android"]  
reading_time: 2 minutes  

---

# what is the difference between sql and sqlite?

## Answers

### Answer by Arti Mishra

## Difference between SQL and SQLite

## SQL

- SQL stands for **Structure [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)** that is used for Relation [Database Management](https://answers.mindstick.com/qa/115622/does-mindstick-software-training-include-database-management-and-cloud-computing) System. It is generally **written in C Language**.
- SQL specifies how **relational schema** are created, and data is properly inserted or deleted in the [relational database](https://www.mindstick.com/forum/158028/what-are-the-disadvantages-of-using-a-nosql-database-over-a-relational-database) and also check transaction are begin or stopped etc.
- SQL is a **query language** **not a database** which is used in different [SQL database](https://www.mindstick.com/articles/337535/connecting-to-sql-databases-ado-dot-net-essentials).
- SQL Language provides a **lot of functionality** to **connect Oracle DB**.
- SQL Language is used in different databases like **MySQL, Oracle, [Microsoft SQL](https://www.mindstick.com/forum/159597/my-sql-server-vs-microsoft-sql-server-which-one-better) Server, IBM DB2** etc.
- SQL language are used to perform different operation like **DDL (Data Definition Language), DML (Data Manipulation Language), DQL (Data Query Language), DCL(Data Control language)** etc.

## \

## SQLite

- SQLite is an Integrated Relational Database [Management System](https://answers.mindstick.com/qa/112059/what-are-the-advantages-of-using-a-content-management-system-cms-for-website-development) which is **written in ANSI-C** (American National Standards Institute-C).
- SQLite is **file-based database**. It is different from other database because it **doesn’t have any server process**.
- SQLite is a database management system which is **uses SQL language for query processing**.
- SQLite **doesn’t provide any functionality**.
- SQLite is **used in desktop and [mobile applications](https://www.mindstick.com/forum/158139/how-do-mobile-applications-and-development-impact-the-it-industry)**.
- SQLite **does not support any [stored procedure](https://www.mindstick.com/articles/803/using-stored-procedure-in-asp-dot-net)** and it contain different feature of SQL Language.
- SQLite only use in **[android development](https://www.mindstick.com/articles/12015/a-revolution-in-mobile-industry-magic-of-android-development)**.


---

Original Source: https://answers.mindstick.com/qa/40985/what-is-the-difference-between-sql-and-sqlite

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