SQLite - page 1
- 1
- 2
- 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
- 1
- 2
