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
Crystal Reports 9 on Oracle (Database Professionals)
Connectivity, Authentication, and Privileges
Oracle Structures
Optimizing: Reducing Parses
Data Dictionary Report
Appendix A Common Issues
SQL Tips & Techniques (Miscellaneous)
Using SQL Data Manipulation Language (DML) to Insert and Manipulate Data Within SQL Tables
Creating Indexes for Fast Data Retrieval
Performing Multiple-table Queries and Creating SQL Data Views
Working with Ms-sql Server Information Schema View
Exploiting MS-SQL Server Built-in Stored Procedures
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Building a Static Library Using Boost.Build
Getting the Length of a String
Using vectors Instead of Arrays
Merging Data
Writing and Reading Dates and Times
Visual C# 2005 How to Program (2nd Edition)
Creating Your Simple Application in Visual C# Express
Notes on Declaring and Using Methods
Files and Streams
Notes on Generics and Inheritance
Synchronized Collections
Programming .Net Windows Applications
Start Page
Form Properties
Text
Bug Database: A Windows Application
Deployment
Python Programming for the Absolute Beginner, 3rd Edition
Signals
PyClock: An Analog/Digital Clock Widget
Where to Go from Here
CGI Script Trade-offs
The PyErrata Web Site
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