SQLite
- SQLite
- Table of Contents
- 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 CC Interface
- Preparing to Use the CC 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
- SYMBOL
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W