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.|
Don’t stop now and take your learning to the next level. Learn all the important concepts of Data Structures and Algorithms with the help of the most trusted course: DSA Self Paced. Become industry ready at a student-friendly price.
- Difference between SQLite and IBM DB2
- Difference between SQLite and Couchbase
- Difference between SQLite and PostgreSQL
- Difference between SQLite and MariaDB
- Difference between Derby and SQLite
- Difference between Elasticsearch and SQLite
- Difference between SQLite and MongoDB
- Difference between SQLite and Cassandra
- Difference between PouchDB and SQLite
- Difference between SQLite and CouchDB
- Difference between SQLite and MS SQL Server
- Difference between MySQL and IBM Db2
- Difference between MySQL and PostgreSQL
- Difference between Redis and MySQL
- Difference between MySQL and MS SQL Server
- Difference between PouchDB and MySQL
- Difference Between MySQL and MariaDB
- Difference between Derby and MySQL
- Difference between Cassandra and MySQL
- Difference between CouchDB 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 email@example.com. 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.