How the Book Is Organized

This book is organized into three parts.

Part IGeneral SQLite Use

• Chapter 1: Getting Started Gives some background on SQLite and discusses its strengths and weaknesses. Covers a few basic SQL commands to get things going and looks at the interactive interfaces to SQLite.

• Chapter 2: Working with Data A concise SQLite tutorial introduces working with the SQLite back end. Discusses programming and database design issues related to SQLite.

• Chapter 3: SQLite Syntax and Use Examines SQL syntax as supported by SQLite and suggests workarounds for the unsupported features.

• Chapter 4: Query Optimization Discusses performance considerations related to SQL queries and gives some techniques that can be used to speed up your database application.

Part IIUsing SQLite Programming Interfaces

• Chapter 5: The PHP Interface How to use the SQLite library within PHP scripts to create dynamic, database-driven web pages.

• Chapter 6: The C/C++ Interface How to write C/C++ programs using the SQLite library.

• Chapter 7: The Perl Interface How to write Perl scripts using the Database Interface module and SQLite Database Driver.

• Chapter 8: The Tcl Interface How to write Tcl scripts using the supplied SQLite extension.

• Chapter 9: The Python Interface How to write Python programs using the PySQLite extension.

Part IIISQLite Administration

• Chapter 10: General Database Administration Discusses basic administration of SQLite and examines SQLite's internal architecture and the Virtual Database Engine (VDBE).