Books & Videos

Table of Contents

  1. Chapter 1 What Is SQLite?

    1. Self-Contained, No Server Required

    2. Single File Database

    3. Zero Configuration

    4. Embedded Device Support

    5. Unique Features

    6. Compatible License

    7. Highly Reliable

  2. Chapter 2 Uses of SQLite

    1. Database Junior

    2. Application Files

    3. Application Cache

    4. Archives and Data Stores

    5. Client/Server Stand-in

    6. Teaching Tool

    7. Generic SQL Engine

    8. Not the Best Choice

    9. Big Name Users

  3. Chapter 3 Building and Installing SQLite

    1. SQLite Products

    2. Precompiled Distributions

    3. Documentation Distribution

    4. Source Distributions

    5. Building

    6. Build and Installation Options

    7. An sqlite3 Primer

    8. Summary

  4. Chapter 4 The SQL Language

    1. Learning SQL

    2. Brief Background

    3. General Syntax

    4. SQL Data Languages

    5. Data Definition Language

    6. Data Manipulation Language

    7. Transaction Control Language

    8. System Catalogs

    9. Wrap-up

  5. Chapter 5 The SELECT Command

    1. SQL Tables

    2. The SELECT Pipeline

    3. Advanced Techniques

    4. SELECT Examples

    5. What’s Next

  6. Chapter 6 Database Design

    1. Tables and Keys

    2. Common Structures and Relationships

    3. Normal Form

    4. Indexes

    5. Transferring Design Experience

    6. Closing

  7. Chapter 7 C Programming Interface

    1. API Overview

    2. Library Initialization

    3. Database Connections

    4. Prepared Statements

    5. Bound Parameters

    6. Convenience Functions

    7. Result Codes and Error Codes

    8. Utility Functions

    9. Summary

  8. Chapter 8 Additional Features and APIs

    1. Date and Time Features

    2. ICU Internationalization Extension

    3. Full-Text Search Module

    4. R*Trees and Spatial Indexing Module

    5. Scripting Languages and Other Interfaces

    6. Mobile and Embedded Development

    7. Additional Extensions

  9. Chapter 9 SQL Functions and Extensions

    1. Scalar Functions

    2. Aggregate Functions

    3. Collation Functions

    4. SQLite Extensions

  10. Chapter 10 Virtual Tables and Modules

    1. Introduction to Modules

    2. Module API

    3. Simple Example: dblist Module

    4. Advanced Example: weblog Module

    5. Best Index and Filter

    6. Wrap-Up

  1. Appendix SQLite Build Options

    1. Shell Directives

    2. Default Values

    3. Sizes and Limits

    4. Operation and Behavior

    5. Debug Settings

    6. Enable Extensions

    7. Limit Features

    8. Omit Core Features

  2. Appendix sqlite3 Command Reference

    1. Command-Line Options

    2. Interactive Dot-Commands

  3. Appendix SQLite SQL Command Reference

    1. SQLite SQL Commands

  4. Appendix SQLite SQL Expression Reference

    1. Literal Expressions

    2. Logic Representations

    3. Unary Expressions

    4. Binary Expressions

    5. Function Calls

    6. Column Names

    7. General Expressions

  5. Appendix SQLite SQL Function Reference

    1. Scalar Functions

    2. Aggregate Functions

  6. Appendix SQLite SQL PRAGMA Reference

    1. SQLite PRAGMAs

  7. Appendix SQLite C API Reference

    1. API Datatypes

    2. API Functions

  8. Colophon