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.