news.volyx.in

SQLite Is Serverless (sqlite.org)

501 points by alexellisuk · 2451 days ago · 440 comments on HN

Article summary

SQLite is a serverless database engine, meaning it does not require a separate server process to operate. Instead, the database engine runs within the same process as the application, reading and writing directly to the database files on disk. This architecture has advantages, such as zero-configuration and ease of use, but also disadvantages, such as reduced protection from bugs in the client application. The article also discusses the distinction between 'classic serverless' and 'neo-serverless' databases.

Main themes

  • Serverless databases
  • Database architecture
  • SQLite
  • Cloud computing
  • Terminology debate

What commenters say

  • The term 'serverless' is misleading when applied to SQLite, as it does not match the common understanding of the term in the context of cloud computing.
  • The original definition of 'serverless' as used by SQLite is clear and distinct from the newer usage in cloud computing.
  • Using the term 'serverless' to describe SQLite is unnecessary and confusing, as more established terms like 'in-process' or 'embedded' are available.
  • The distinction between 'classic serverless' and 'neo-serverless' is useful for understanding the different architectures and implications of each approach.
  • The evolution of language and terminology can lead to confusion and disagreements, especially when different communities use the same term to mean different things.
  • The use of the term 'serverless' in the context of SQLite is not problematic, as it accurately describes the database engine's architecture and lack of a separate server process.
  • The article's discussion of 'classic serverless' and 'neo-serverless' is an attempt to clarify the terminology and prevent further confusion.