Table of Contents

   
book cover
  
• Table of Contents
• Index
SQLite
By Chris Newman
 
Publisher: Sams Publishing
Pub Date: November 09, 2004
ISBN: 0-672-32685-X
Pages: 336
   


   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



SQLite
SQLite
ISBN: 067232685X
EAN: 2147483647
Year: 2004
Pages: 118
Authors: Chris Newman

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net