Table of Contents

Inside SQLite

by Sibsankar Haldar

---

Publisher: O'Reilly

Pub Date: April 15, 2007

Print ISBN-10: 0-596-55006-5

Print ISBN-13: 978-0-59-655006-6

Pages: 76

Copyright

Chapter 1. Overview

Section 1.1. Sample Applications

Section 1.2. SQLite Architecture

Section 1.3. SQLite Limitations

Chapter 2. Database File Format

Section 2.1. Database Naming Conventions

Section 2.2. Database File Structure

Chapter 3. Page Cache Management

Section 3.1. Pager Responsibilities

Section 3.2. Pager Interface Structure

Section 3.3. Cache Management

Chapter 4. Transaction Management

Section 4.1. Transaction Types

Section 4.2. Lock Management

Section 4.3. Journal Management

Section 4.4. Transactional Operations

Chapter 5. Table and Index Management

Section 5.1. B+-Tree Structure

Section 5.2. B+-tree in SQLite

Section 5.3. Page Structure

Section 5.4. Module Functionality

Chapter 6. SQLite Engine

Section 6.1. Bytecode Programming Language

Section 6.2. Record Format

Section 6.3. Data Type Management

Chapter 7. Further Information