Prerequisites

This book assumes no prior knowledge of SQLite, though naturally people of all experience levels will benefit from the material. SQLite is written in C with an extensive C API and also supports many other languages such as Python, Tcl, Ruby, and Java. As a database engine, it also makes extensive use of SQL. Although the examples in this book will benefit a reader of any skill level, we don’t have space to also teach those languages.

How This Book Is Organized

The book contains 11 chapters, which cover the following broad areas:

• SQLite introduction, acquisition, and installation
• Using SQL with SQLite
• The C API for SQLite
• Using languages such as Python, Tcl, Ruby, and Java with SQLite
• Mobile device development with SQLite
• Internals and new features of SQLiteThere’s no real impediment to jumping in to whatever area takes your fancy, though you may find that Chapters 5, 6, and 7, which deal with the C API, are best approached in order.