SQLite is a classic server less

Jiedao jdon 2021-05-04 12:35:54
sqlite classic server

majority SQL Database engines provide external access as separate server processes , External clients want to access the database , You need to communicate with the server process ( Usually TCP / IP), This will send the request to the server and receive the result back to the database server .SQLite But can't work in this way . Use SQLite, If you want to access the database , Can only read and write directly from the database file on disk .SQLite No server process .

No server has advantages and disadvantages .

The main advantage is that there is no need to install 、 Set up 、 To configure 、 initialization 、 Manage individual server processes . This is it. SQLite yes “  Zero configuration  ” One of the reasons for the database engine . Use SQLite Before running, you can set up the database engine without any management support . Any program that can access the disk can use SQLite database .

On the other hand, the disadvantage is that : Database engine using server process can provide better protection , To prevent errors in client applications - Stray pointers in the client cannot destroy the memory on the server . And because the server is a single persistent process , So it can control database access more precisely , To achieve finer grained locking and better concurrency .

majority SQL Database engines are all client based / Server's . In a server less database ,SQLite It's the only known one , It allows multiple applications to access the same database at the same time .

Classic no server vs. new no server

Recently, , People began to use “ There is no server ” A word that is slightly different from what is expected in this document . This is a “ There is no server ” Two possible definitions of :

  1. Classic no server :  The database engine is in the same process as the application 、 Running in thread and address space . No messaging or network activity .
  2. Neo-Serverless New no server :  The database engine runs in a different namespace than the application , Maybe on another computer , But the database is provided by the hosting provider as a turnkey service , There is no need for application owners to manage or manage , And so easy to use , So that developers can think that the database is really server free , Even if it does use the server in the background .

SQLite Is a classic example of a server less database engine . Use SQLite, There are no other processes , Threads , Machine or other mechanism ( host OS And file systems ) Can help provide database services or implement . There is really no server .

Microsoft Azure Cosmo DB  and  Amazon S3  Is an example of a new serverless database . These databases are implemented by server processes running separately in the cloud . But the server is made up of ISP Not maintained and managed by application developers . Application developers only use this service . Developers don't have to set up , Configure or manage database server instances , Because all this work is done automatically by the service provider . The database server actually exists , They're just hidden from developers .

understand “ There is no server ” These two different definitions are important . When the database claims to be “ There is no server ” when , Make sure you identify them as “ Classic no server ” still “ New no server ”.


本文为[Jiedao jdon]所创,转载请带上原文链接,感谢

  1. JS: event flow
  2. Front end performance optimization: rearrangement and redrawing
  3. JS - deep and shallow copy
  4. JavaScript异步编程3——Promise的链式使用
  5. JavaScript asynchronous programming 3 -- chain use of promise
  6. Vue.js组件的使用
  7. The use of vue.js component
  8. How to judge whether a linked list has links
  9. Element UI custom theme configuration
  10. Text image parallax effect HTML + CSS + JS
  11. Spring的nohttp宣言:消灭http://
  12. Vue3 intermediate guide - composition API
  13. Analysis of URL
  14. These 10 widgets that every developer must know
  15. Spring's nohttp Manifesto: eliminate http://
  16. Learn more about JS prototypes
  17. Refer to await to JS to write an await error handling
  18. A short article will directly let you understand what the event loop mechanism is
  19. Vue3 uses mitt for component communication
  20. Characteristics and thinking of ES6 symbol
  21. Two way linked list: I'm no longer one-way driving
  22. Vue event and form processing
  23. Reactive TraderCloud实时外汇开源交易平台
  24. Reactive tradercloud real time foreign exchange open source trading platform
  25. Node.js REST API的10个最佳实践
  26. Ten best practices of node.js rest API
  27. Fiddler advanced usage
  28. Process from Vue template to render
  29. Promise up (asynchronous or synchronous)
  30. Principle and implementation of promise
  31. Vs code plug in sharing - run code
  32. Vue practical notes (1) introduction of Ant Design
  33. Vue actual combat notes (2) introduction of element plus
  34. Introduction to webpack
  35. Webpack construction process
  36. Vue notes
  37. The experience and lessons of moving from ruby megalith architecture to go microservice
  38. Using leancloud to add artitalk module to hexo blog
  39. Implementation of chrome request filtering extension
  40. Detailed introduction of beer import declaration elements and label quarantine [import knowledge]
  41. Gallop workflow engine design series 01 process element design
  42. VUE移动端音乐APP学习【十六】:播放器歌词显示开发
  43. Vue Mobile Music App learning [16]: player lyrics display development
  44. jquery cookie
  45. jquery cookie
  46. 体面编码之JavaScript
  47. JavaScript for decent coding
  48. React17 系统精讲 结合TS打造旅游电商平台
  49. React17 system combined with TS to build tourism e-commerce platform
  50. 2021-05-04 hot news
  51. HttpSession对象与Cooike的关系 以及 Cookie对象构造函数问题
  52. gRPC-Web:替代REST的gRPC的Javascript库包
  53. The relationship between httpsession object and cooike and the construction of cookie object
  54. Grpc Web: a JavaScript library package to replace rest grpc
  55. Building reactive rest API with Java - kalpa Senanayake
  56. PDF转HTML工具——用springboot包装pdf2htmlEX命令行工具
  57. Pdf to HTML tool -- Wrapping pdf2htmlex command line tool with springboot
  58. PDF转HTML工具——用springboot包装pdf2htmlEX命令行工具
  59. Pdf to HTML tool -- Wrapping pdf2htmlex command line tool with springboot
  60. Vue.js比jQuery更容易学习