SQLite 文档已经给出了答案:SQLite 的竞争对手是 fopen,而不是像 MySQL 这样的 client/server 数据库。https://www.sqlite.org/whentouse.html
SQLite is not directly comparable to client/server SQL database engines such as MySQL, Oracle, PostgreSQL, or SQL Server since SQLite is trying to solve a different problem.
Client/server SQL database engines strive to implement a shared repository of enterprise data. They emphasize scalability, concurrency, centralization, and control. SQLite strives to provide local data storage for individual applications and devices. SQLite emphasizes economy, efficiency, reliability, independence, and simplicity.
SQLite does not compete with client/server databases. SQLite competes with fopen().
SQLite 文档还贴心地指出了什么时候用 client/server SQL 数据库(如MySQL)