1. MySQL :
MySQL is an open-source relational database management system(RDBMS) based on Structured Query Language (SQL). It is developed and managed by oracle corporation and initially released on 23 may, 1995. It is widely being used in many small and large scale industrial applications and capable of handling a large volume of data.
2. SQLite :
SQLite is a software library that provides a relational database management system(RDBMS).It was designed by D. Richard Hipp on August 2000. The design goals of SQLite were to allow the program to be operated without installing a database management system(DBMS) or requiring a database administrator. The lite in SQLite means light weight in terms of setup, database administration, and required resource.
Difference between MySQL and SQLite:
|1.||Developed by Oracle on May 1995.||Developed By D. Richard Hipp on August 2000.|
|2.||MySQL is developed in C and C++ languages.||SQLite is developed only in C language.|
|3.||MySQL requires a database server for its functioning. Hence, it follows client/server architecture.||SQLite does not require a server to run. Hence, it is serverless.|
|4.||It can handle multiple connections simultaneously.||It can handle only one connection at a time.|
|5.||It is highly scalable and can handle a large volume of data very efficiently.||It can handle only small set of data if the volume of data increased its performance degrades.|
|6.||It requires large space in the memory for its functioning (approx 600 Mb).||It requires only some KBs of space as it is very lightweight approx (250Kb-300Kb).|
|7.||MySQL supports multiple user environment.||SQLite does not support multiple user environment.|
|8.||It also supports XML format.||It does not supports XML format.|
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.
- Difference between SQLite and Cassandra
- 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 SQLite and MS SQL Server
- 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 SQL and SQLite
- How to pre populate database in Android using SQLite Database
- SQLite Statements or Syntax
- MySQL | Common MySQL Queries
- Difference between MySQL and MS SQL Server
- Difference Between MySQL and MariaDB
- Difference between Cassandra and MySQL
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.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.