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
Interprocess Communications in Linux: The Nooks and Crannies
Real and Effective User and Group IDs
Signal and Signal Management Calls
Message Queue Control
Multiplexing I/O with select
C.4. Some RPC Examples
The CISSP and CAP Prep Guide: Platinum Edition
Access Control
Security Architecture and Design
Business Continuity Planning and Disaster Recovery Planning
Initiation of the System Authorization Process
Appendix B Glossary of Terms and Acronyms
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Part I - The Underpinning Theory
Organizational change
Leading change
Part II - The Applications
Restructuring
Mapping Hacks: Tips & Tools for Electronic Cartography
Hack 19. Analyze Elevation Profiles for Wireless Community Networks
Hack 23. Explore David Rumseys Historical Maps
Hacks 47-63
Hack 59. Geocode Your Voice Recordings and Other Media
Hack 78. What to Do if Your Government Is Hoarding Geographic Data
An Introduction to Design Patterns in C++ with Qt 4
C++ First Example
Qt 4 Models and Views
Selection Statements
Review Questions
Multiple Inheritance
Twisted Network Programming Essentials
Starting the Twisted Event Loop
Working with Asynchronous Results
Web Servers
Using a Web Client to Update Resources Through REST
Using Authentication in a Twisted Server
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