百科问答小站 logo
百科问答小站 font logo



SQLite 的读写效率很高,有哪些使用其他数据库的理由? 第1页

  

user avatar   zhu-zhao-long-3 网友的相关建议: 
      

SQLite 文档已经给出了答案:SQLite 的竞争对手是 fopen,而不是像 MySQL 这样的 client/server 数据库。sqlite.org/whentouse.ht

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)

  1. Is the data separated from the application by a network? → choose client/server
  2. Many concurrent writers? → choose client/server
  3. Big data? → choose client/server
  4. Otherwise → choose SQLite!



  

相关话题

  请问从技术角度来看是鸿蒙操作系统,木兰编程语言,方舟编译器哪个技术水平更高一些? 
  数据分析人员需要掌握sql到什么程度? 
  未来会不会出现这样的编程语言? 
  一行 Java 代码(以分号结束)能实现什么丧心病狂的功能? 
  Java设计出checked exception有必要吗? 
  为什么看到这么多人不推荐C++? 
  SQL Server 相比 MySQL 有何优势? 
  学习编程必须要会英语吗? 
  为什么编程语言有这么多种类?为什么不统一成一种语言呢? 
  如何获得中国所有火车班次时刻表数据? 

前一个讨论
如何学习Python,以及新手如何入门?
下一个讨论
DL/ML 模型如何部署到生产环境中?





© 2025-05-30 - tinynew.org. All Rights Reserved.
© 2025-05-30 - tinynew.org. 保留所有权利