SQLite Database System Design and Implementation (Second Edition, Version 1): (See other editions and books at https://books.google.com/books/?id=zSbxCwAAQBAJ and decide one)A preliminary edition of this book was published from O'Reilly (ISBN 9780596550066). SQLite is a small, embeddable, SQL-based, relational database management system. It has been widely used in low- to medium-tier database applications, especially in embedded devices. This book provides a comprehensive description of SQLite database system. It describes design principles, engineering trade-offs, implementation issues, and operations of SQLite. |
Contents
| 1 | |
SQLite Overview | 35 |
Storage Organization | 71 |
Transaction Management | 85 |
Commit protocol | 101 |
Disk access overheads | 109 |
Process and thread | 117 |
6 | 135 |
The Virtual Machine Module | 155 |
Column affinity example | 175 |
The Frontend Module | 181 |
SQLite Interface Handler | 197 |
Database application | 203 |
11 | 231 |
Other editions - View all
Common terms and phrases
abort affinity API function attached database autovacuum B+-tree big-endian bytecode program bytes cache catalog cell clause collation sequence column command commit compilation concurrency concurrency control cursor data items database connection database system datafile DBMS default delete disk encoding exclusive lock file descriptor format freelist implements inode insert integer interface internal leaf library connection Linux log records manifest type mode node NULL offset opcode operand operating system page cache pager module Pager object parse parse tree parser payload payload fraction pending lock pointer pragma primary key query optimization read-transactions release reserved lock returns rollback journal file rowid savepoint schema select statement shared lock space SQL statement SQLite development team SQLite library SQLite locks SQLite supports statement execution statement journal storage type stored string subquery thread tree module trigger tuples update user transaction WAL journaling write write-transaction