The Definitive Guide to SQLite

CHAPTER 9SQLite Internals

This chapter is a brief tour through SQLite's major subsystems. It was inspired from a SQLite presentation given by Richard Hipp at a convention I attended. Much of the material presented here was taken directly from the handouts. Even if you never look at SQLite's source code, you may find the material in this chapter quite interesting, as I did. While some of the material is apt to change with ongoing SQLite development, the major concepts presented here are not likely to change too dramatically.

By now, you should be familiar with the major components of SQLite's architecture. Chapter 1 provides a general description of each major component, and Chapter 5 elaborated a little on the B-tree and pager in the process ...