SQLite内部:页和B树

A parliament of owls meticulously inspecting various pages while in a tree. There's also two feet.

Fly.io runs apps close to users around the world, by taking containers and upgrading them to full-fledged virtual machines running on our own hardware around the world. Sometimes those containers run SQLite and we make that easy too. Give us a whirl and get up and running quickly.

Fly.io通过将容器升级为成熟的虚拟机,并在我们自己的硬件上运行,从而使应用程序接近世界各地的用户。有时这些容器会运行SQLite,我们也会让它变得简单。给我们一个机会,快速启动和运行。

Ok, I'll admit it—I'm a SQLite shill. There are few holes that I don't try to put a SQLite-shaped peg into. It's not that I dislike other databases, they're great. But SQLite is so easy to use and, more importantly, it's simple. Simplicity leads to reliability and I don't know of a more reliable database than SQLite.

好吧,我承认,我是一个SQLite的推销员。很少有洞是我不试图把一个SQLite形状的钉子塞进去的。这并不是说我不喜欢其他数据库,它们都很好。但是SQLite非常容易使用,更重要的是,它很简单。简单导致可靠,我不知道还有什么比SQLite更可靠的数据库。

There's a comfort with being able to read through a spec or a code repository and know that you've covered the full breadth of a tool. That's why I love Go's simple 100-page language specification and that's why I love SQLite's 130KLOC core code base. It's something that you can read through in a long weekend if, ya know, that's what you do on weekends.

读完一份规范或代码库,知道自己已经涵盖了一个工具的全部内容,这种感觉很舒服。这就是为什么我喜欢Go的简单的100页语言规范,也是为什么我喜欢SQLite的130KLOC核心代码库。你可以在一个漫长的周末里读完它,如果你知道,这就是你在周末做的事情。

This constrained size means that SQLite doesn't include every bell and whistle. It's careful to include the 95% of what you need in a database—strong SQL support, transactions, windowing functions, CTEs, etc—without cluttering the source with more esoteric features. This limited feature set also means the structure of the database can stay simple and makes it easy for anyone to understand.

这种限制性的规模意味着SQLite并不包括所有的铃声和口哨。它小心翼翼地包含了你在数据库中需要的95%的东西--强大的SQL支持、事务、窗口函数、CTE等等--而没有用更多深奥的功能来扰乱源。这种有限的功能集也意味着数据库的结构可以保持简单,使任何人都能容易理解。

We here at Fly.io have an unreasonable affinity for explanations involving sandwiches and this post will continue in that sacred tradition.

我们在Fly.io对涉及三明治的解释有一种不合理的亲和力,这篇文章将继续这一神圣的传统。

I Have Binders Full of Sandwiches

...

开通本站会员,查看完整译文。

首页 - Wiki
Copyright © 2011-2024 iteam. Current version is 2.123.1. UTC+08:00, 2024-03-29 10:32
浙ICP备14020137号-1 $访客地图$