What is the difference between SQLite and MySql? How to select website database

We see that WordPress program supports MYSQL database and SQLITE database. How do we choose when installing? The database we may use frequently is MYSQL. MySQL is a relational database management system based on SQL, SQL is the most widely used programming language for accessing and managing database records. MySQL is a free open source software licensed under the GNU General Public License. SQLite is a relational database management system for embedded systems. It is a self contained, serverless, and configurable transactional SQL database engine.

Let's see the difference between the two:

1、 SQLite is an independent database and does not require a server. This is also called an embedded database because the database engine is integrated into the program. MySQL requires a server to run. In order to communicate over the network, MySQL requires a client and server architecture.

2、 The SQLite library is about 250 KB in size, while the MySQL server is about 600 MB in size. SQLite stores information in a single file, making it easy to copy. No settings are required, and the operation can be completed with minimal help. You must compress MySQL into a single file before copying or exporting it. For large databases, this will be a time-consuming task.

3、 SQLite lacks user management ability and is not suitable for multi-user access. MySQL is extensible and can easily handle larger databases.

SQLite database does not need to build a separate database environment. It can be produced in directory files like static files, while MYSQL database needs to be built separately. SQLite is suitable for small projects, MYSQL database is suitable for medium and above projects and can realize database separation. Generally, it is appropriate for us to use MYSQL.