---

SQLite

ISBN: 067232685X
EAN: 2147483647

Year: 2004
Pages: 118

Authors: Chris Newman

BUY ON AMAZON

• 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