编程与软件工程sqlite.org
为什么 SQLite 用 C 编写？（2017）
Why Is SQLite Coded in C? (2017)
2018 — 2025，它一次次回到首页
黑点是上首页（≥ 50 分）的那次投稿，空心点是没冲上去的投稿，点越大分数越高。
导读
SQLite 官方文档解释了为什么这个数据库引擎用 C 语言编写：C 简单、稳定、可移植，且便于嵌入各种应用。文章还提到 C 的缺陷可以通过严格的工程实践和测试流程来弥补。
为什么经久不衰：它来自 SQLite 作者本人，直接回应了“为什么不用更现代的语言”这一反复出现的争论，是理解 C 语言在基础软件中持久地位的经典文本。
HN 评论精选
SQLite 的质量来自大量测试和分析工具的支撑，而非 C 语言本身的优势
我多次说过，“C”和“有分析支撑的 C”实际上是两种不同的语言，SQLite 属于后者。SQLite 的成功并不能证明 C 是一门好语言，反而说明要达到这种质量水平，需要在 C 外面套上多少额外的脚手架——考虑到所用工具的数量和多样性，这对“纯 C”来说并不是什么好话。
jerf查看英文原文
I've commented several times before that I consider "C" and "C with analysis backing" to be in practice two different languages. SQLite is the latter: https://sqlite.org/testing.html Writing SQLite in "plain C" without all that would, well, simply not work. I agree that "C with analysis backing" is the best language for SQLite right now. However, it should not be used as an example of "How C is a great language for programming in" unless you are also planning on skillfully using a very significant subset of the tools listed in that document. SQLite doesn't prove C is great; it demonstrates how much additional scaffolding is necessary to wrap around C to get that level of quality, and given the quantity and diversity of tools we are talking about, it is not particularly complimentary to "plain C".
C 语言小而透明，写起来直接清晰
我喜欢 C 的地方是它几乎不碍事。语言很小，熟悉之后几乎不用查文档。代码可能更啰嗦，但通常非常清晰。
rwbt查看英文原文
My favorite aspect of programming in C is how little it gets in the way of the programmer. Once you become familiar with the language there is not much to lookup in the docs because it's such a small language. I might end up writing more verbose code, but it's usually very clear to me. You still can write spaghetti code but that's besides the point.
希望有高级语言原生、兼容 SQLite 的替代实现，解决嵌入和部署难题
C 很棒，SQLite 也用得极好，但我真希望有针对特定语言/平台（如 .Net）的原生替代实现（文件格式和 SQL 方言 100% 兼容）。很多场景下数据库速度并非首要，简单和可移植才更重要。每次在 .Net 桌面应用里用 SQLite 都是一场噩梦，部署到别的机器上尤其麻烦。
qwerty456127查看英文原文
C is great and SQLite seems doing amazing leveraging its power. Yet I bloody wish there were alternative (yet 100% compatible on the file format and SQL dialect levels) SQLite implementations native to specific languages/platforms (e.g. .Net). In just so many cases the DB speed is the least priority while simplicity and portability are valued much higher (in these particular cases). Every time I build a humble desktop .Net app featuring an SQLite database it turns into in a ridiculous "try this, google a lot, try that, repeat, .... oh wow, it works!... oh, it doesn't" nightmare and even if it actually starts working nobody really knows how to deploy such an app on another computer (especially if it runs a different kind of OS) correctly. SQLite is arguably the best of what has happened to the world of desktop/embedded databases ever yet lack of alternative (not necessarily this fast) implementations in high-level languages is its main problem IMHO.
2000 年选 C 合理，但今天 Rust/Go 会是强有力的新选择
我强烈怀疑这篇文章是针对 C++、Java 或 C# 的回应。考虑到 SQLite 始于 2000 年，C 确实是当时无可争议的最佳选择，现有 C 代码也是反对重写的有力论据。不过今天用 Rust 甚至 Go 写一个类似 SQLite 的库会是很有力的竞争者。
chungy查看英文原文
I strongly suspect this article was written as a response against C++, Java, or C#. Especially given SQLite being started in 2000, C really was undeniably the best choice, and the existing code in C is a strong argument in favor against rewrites. That being said, Rust and possibly even Go would be strong contenders to make a new SQLite-like library/program today. At least on the Rust side, the C bindings are excellent too.
历次讨论
同类还值得读
开源应用架构
The Architecture of Open Source Applications
《开源软件架构》（AOSA）是一本在线免费书，邀请知名开源项目的作者亲自剖析其内部设计，涵盖 SQLAlchemy、LLVM、Audacity、Apache、Bash 等系统。
编程与软件工程上首页 9 次 · 2011–2024aosabook.org编辑精选编程语言简史：简短、不完整且多半错误
A Brief, Incomplete, and Mostly Wrong History of Programming Languages
一篇以戏谑、故意不准确的方式回顾编程语言史的博客文章，用夸张轶事和讽刺定义串起 Lisp、C、C++、Java、JavaScript、PHP 等语言。
编程与软件工程上首页 8 次 · 2009–2021james-iry.blogspot.comSQLite 是如何测试的
How SQLite is tested
SQLite 官方文档页，系统介绍 SQLite 的测试体系：多种测试方法（TCL 测试、模糊测试、回归测试、静态分析等）和海量测试用例，展示了这个小型开源项目如何靠极致测试获得…
编程与软件工程上首页 8 次 · 2009–2025sqlite.org编辑精选高级编程语言（2009）
Advanced programming languages (2009)
Matt Might 的经典文章，按用途推荐“高级编程语言”：如果追求就业就选主流语言，如果追求表达力、学术研究或创业，则推荐 Haskell、OCaml、Scala 等函数式语…
编程与软件工程上首页 8 次 · 2009–2022matt.might.net我的 Forth 与栈机器经历
Yosefk - My history with Forth & stack machines
作者以亲身经历回顾了使用 Forth 语言和栈式机器的历程：既赞叹其简洁优雅、代码量小、可自举的优点，也坦率指出栈操作在实际编程中的痛苦，以及 Forth 社区文化中的问题。
编程与软件工程上首页 8 次 · 2010–2024yosefk.com编辑精选