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
Absolute Beginner[ap]s Guide to Project Management
Planning a Project
Powerful Estimating Techniques and Methods
Creating a Project Budget
Management Fundamentals for Project Control
More Than Managing
Cisco IP Communications Express: CallManager Express with Cisco Unity Express
Introducing Cisco IPC Express
Invoking Call Pickup
Summary
Setting Up a Cisco UE Automated Attendant
Cisco Voice Network Management Solutions
Network Security Architectures
Security System Development and Operations Overview
References
Device Hardening
Edge Security Design
Defining the Teleworker Environment
SQL Hacks
Online Applications
Hack 73. Mix File and Database Storage
Hack 92. Deploy Applications
Hack 94. Create Users and Administrators
Hack 100. Run SQL from a Web Page
Visual C# 2005 How to Program (2nd Edition)
Algorithms
Drawing Arcs
Structuring Data
F.4. W3C XHTML Validation Service
G.10. Nested framesets
File System Forensic Analysis
Booting Process
Introduction
Removable Media
File Name Category
Ext2 and Ext3 Data Structures
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