Book description
SQLite is a small, fast, embeddable database. What makes it popular is the combination of the database engine and interface into a single library as well as the ability to store all the data in a single file. Its functionality lies between MySQL and PostgreSQL, however it is faster than both databases.
In SQLite, author Chris Newman provides a thorough, practical guide to using, administering and programming this up-and-coming database. If you want to learn about SQLite or about its use in conjunction with PHP this is the book for you.
Table of contents
- Copyright
- Foreword
- About the Author
- We Want to Hear from You!
- Reader Services
- Introduction Welcome to SQLite
-
I. General SQLite Use
- 1. Getting Started
- 2. Working with Data
- 3. SQLite Syntax and Use
- 4. Query Optimization
-
II. Using SQLite Programming Interfaces
- 5. The PHP Interface
- 6. The C/C++ Interface
- 7. The Perl Interface
- 8. The Tcl Interface
- 9. The Python Interface
- III. SQLite Administration
-
IV. Appendixes
- A. Downloading and Installing SQLite
- B. Command Reference for the sqlite Tool
-
C. SQL Syntax Reference
- Naming Conventions
- SQL Command Syntax
- ANSI SQL Commands and Features Not Supported
- D. PHP Interface Reference
-
E. C Interface Reference
- The Core API
- The Non-Callback API
-
The Extended API
- Finding Information About the SQLite Library
- Finding Information About Changes to the Database
- Checking SQL Statements
- Interrupting an SQL Statement
- Convenience Functions
- The _printf() Wrapper Functions
- Memory Management
- Dealing with Locked Database Files
- Performing Background Jobs During Large Queries
- Adding New SQL Functions
- F. Perl Interface Reference
- G. Tcl Interface Reference
- H. Python Interface Reference
- I. The Future of SQLite
Product information
- Title: SQLite
- Author(s):
- Release date: November 2004
- Publisher(s): Sams
- ISBN: 9780672326851
You might also like
video
Creating a Database with SQLite
Journey to database mastery as you learn how to create a simple database and manipulate its …
book
Using SQLite
Application developers, take note: databases aren't just for the IS group any more. You can build …
book
The Definitive Guide to SQLite
Traditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So …
book
The Definitive Guide to SQLite, Second Edition
Outside of the world of enterprise computing, there is one database that enables a huge range …