| | | Copyright |
| | | Foreword |
| | | About the Author |
| | | We Want to Hear from You! |
| | | Reader Services |
| | | Introduction Welcome to SQLite |
| | | | Why Use SQLite? |
| | | | Who This Book Is For |
| | | | How the Book Is Organized |
| | | | Versions of Software Covered |
| | | | Additional Resources |
| | | Part I: General SQLite Use |
| | | | Chapter 1. Getting Started |
| | | | Introduction |
| | | | Features and Limitations |
| | | | When Not to Choose SQLite |
| | | | Looking at SQLite Databases |
| | | | Help and Support |
| | | | Chapter 2. Working with Data |
| | | | SQLite Basics |
| | | | Querying and Updating the Database |
| | | | Chapter 3. SQLite Syntax and Use |
| | | | Naming Conventions |
| | | | Creating and Dropping Tables |
| | | | Anatomy of a SELECT Statement |
| | | | Attaching to Another Database |
| | | | Manipulating Data |
| | | | Indexes |
| | | | Views |
| | | | Triggers |
| | | | Working with Dates and Times |
| | | | SQL92 Features Not Supported |
| | | | Chapter 4. Query Optimization |
| | | | Keys and Indexes |
| | | | The EXPLAIN Statement |
| | | Part II: Using SQLite Programming Interfaces |
| | | | Chapter 5. The PHP Interface |
| | | | Configuring PHP for SQLite Support |
| | | | Using the PHP SQLite Extension |
| | | | Working with User-Defined Functions |
| | | | Using the PEAR Database Class |
| | | | Chapter 6. The C/C++ Interface |
| | | | Preparing to Use the C/C++ Interface |
| | | | Using the C Language Interface |
| | | | Adding New SQL Functions |
| | | | Chapter 7. The Perl Interface |
| | | | Preparing to Use the SQLite Interface |
| | | | About the Perl DBI |
| | | | Using the SQLite DBD |
| | | | Adding New SQL Functions |
| | | | Chapter 8. The Tcl Interface |
| | | | Preparing to Use the Tcl Interface |
| | | | Using the Tcl Interface |
| | | | Chapter 9. The Python Interface |
| | | | Preparing to Use the Python Interface |
| | | | Using the Python Interface |
| | | Part III: SQLite Administration |
| | | | Chapter 10. General Database Administration |
| | | | The PRAGMA Command |
| | | | Backing Up and Restoring Data |
| | | | Exploring the SQLite Virtual Database Engine |
| | | | Access to the Database File |
| | | Part IV: Appendixes |
| | | | Appendix A. Downloading and Installing SQLite |
| | | | Obtaining SQLite |
| | | | Appendix B. Command Reference for the sqlite Tool |
| | | | Dot Commands |
| | | | Appendix C. SQL Syntax Reference |
| | | | Naming Conventions |
| | | | SQL Command Syntax |
| | | | ANSI SQL Commands and Features Not Supported |
| | | | Appendix D. PHP Interface Reference |
| | | | Predefined Constants |
| | | | Runtime Configuration |
| | | | Function Reference |
| | | | Appendix E. C Interface Reference |
| | | | The Core API |
| | | | The Non-Callback API |
| | | | The Extended API |
| | | | Adding New SQL Functions |
| | | | Appendix F. Perl Interface Reference |
| | | | The Perl DBI |
| | | | Appendix G. Tcl Interface Reference |
| | | | The Tcl Library |
| | | | Appendix H. Python Interface Reference |
| | | | Opening and Closing a Database |
| | | | Creating User-Defined Functions |
| | | | Error Handling |
| | | | Appendix I. The Future of SQLite |
| | | | SQLite Version 3.0 |
| | | Index |
