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
SQL Tips & Techniques (Miscellaneous)
Using SQL Data Definition Language (DDL) to Create Data Tables and Other Database Objects
Using Data Control Language (DCL) to Setup Database Security
Using Keys and Constraints to Maintain Database Integrity
Understanding Triggers
Working with Data BLOBs and Text
Snort Cookbook
Installing Snort Binaries on Linux
Viewing Traffic While Logging
Detecting Binary Content
Decoding Application Traffic
Analyzing and Graphing Logs
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Part I - The Underpinning Theory
Individual change
Team change
Cultural change
IT-based process change
Persuasive Technology: Using Computers to Change What We Think and Do (Interactive Technologies)
The Functional Triad Computers in Persuasive Roles
Computers as Persuasive Media Simulation
Computers as Persuasive Social Actors
Credibility and Computers
The Ethics of Persuasive Technology
Microsoft VBScript Professional Projects
Arrays
Scheduling Disk Maintenance
Mapping Network Printers and Disks
Developing Script Log Analyzers
Designing the Web Site
Understanding Digital Signal Processing (2nd Edition)
DISCRETE LINEAR SYSTEMS
REFERENCES
REFERENCES
BLOCK FLOATING-POINT BINARY FORMAT
Chapter Thirteen. Digital Signal Processing Tricks
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