百科问答小站 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!



  

相关话题

  函数式编程的核心价值是什么? 
  编程中,有哪些好的习惯从一开始就值得坚持? 
  十大编程语言都有哪些?哪种比较好? 
  为什么 Go 语言把类型放在后面? 
  为什么那些会多国语言的人常常被赞赏,貌似没什么人因为精通各种编程语言而赞赏程序猿? 
  Lisp 和 Haskell 各有什么优缺点?学哪个好? 
  既然国外的 IT 巨头有能力推出自研发的语言,为什么国内的巨头们没有这种热情呢? 
  王垠喷 Go 语言,许式伟赞 Go 语言,大家怎么看? 
  为什么上古编程语言(比如 COBOL)总喜欢把代码全部写成大写字母? 
  刚开始学习Objective-C,面对Swift该怎么办? 

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





© 2024-05-18 - tinynew.org. All Rights Reserved.
© 2024-05-18 - tinynew.org. 保留所有权利