Flylib.com
SQLite
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
SQLite
ISBN: 067232685X
EAN: 2147483647
Year: 2004
Pages: 118
Authors:
Chris Newman
BUY ON AMAZON
Beginning Cryptography with Java
Object Description in Cryptography Using ASN.1
Certificate Revocation and Path Validation
CMS and S/MIME
Appendix B Algorithms Provided by the Bouncy Castle Provider
Appendix C Using the Bouncy Castle API for Elliptic Curve
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Wide Area Network (WAN) Technologies
Address Resolution Protocol (ARP)
Transmission Control Protocol (TCP) Basics
Internet Protocol Security (IPSec)
Virtual Private Networks (VPNs)
101 Microsoft Visual Basic .NET Applications
Data Access
Building Windows Forms User Interfaces
Advanced .NET Framework
Building Enterprise Services Applications
Visual Studio .NET
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
Relationships in the Supply Chain
The Internationalization of the Retail Supply Chain
Fashion Logistics and Quick Response
Rethinking Efficient Replenishment in the Grocery Sector
Transforming Technologies: Retail Exchanges and RFID
Information Dashboard Design: The Effective Visual Communication of Data
Variations in Dashboard Uses and Data
Tapping into the Power of Visual Perception
Understanding the Limits of Short-Term Memory
Gestalt Principles of Visual Perception
Summary
Digital Character Animation 3 (No. 3)
Chapter Two. Modeling Characters
Facial Rigging
Mesh Deformation
Refining Rigs
Beyond Walking
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies