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 Relational Database Systems.
- It is a standard which specifies how the data is inserted or how a relational schema or table is created.
- Some of the SQL databases are MySQL, Oracle, Microsoft SQL Server, etc.
- Ways to write the query is same in both the SQL and SQLite.
- Some components of SQL are DDL (Data Definition Language), DML (Data Manipulation Language) etc.
SQLite
- SQLite is an embedded relational database management system which is written in ANSI-C.
- SQLite is file-based whereas SQL is a server based.
- SQLite does not support stored procedures.
- SQLite is the lite form of SQL which runs on low powered devices or the devices with low memory such as mobile devices, PDAs or pocket music players etc.
Leave a Comment