Book description
Application developers, take note: databases aren't just for the IS group any more. You can build database-backed applications for the desktop, Web, embedded systems, or operating systems without linking to heavy-duty client-server databases such as Oracle and MySQL. This book shows you how to use SQLite, a small and lightweight relational database engine that you can build directly into your application.
With SQLite, you'll discover how to develop a database-backed application that remains manageable in size and complexity. This book guides you every step of the way. You'll get a crash course in data modeling, become familiar with SQLite's dialect of the SQL database language, and much more.
- Learn how to maintain localized storage in a single file that requires no configuration
- Build your own SQLite library or use a precompiled distribution in your application
- Get a primer on SQL, and learn how to use several language functions and extensions
- Work with SQLite using a scripting language or a C-based language such as C# or Objective-C
- Understand the basics of database design, and learn how to transfer what you already know to SQLite
- Take advantage of virtual tables and modules
"Complex SQL concepts explained clearly."
--D. Richard Hipp, creator of SQLite
Table of contents
- Dedication
- A Note Regarding Supplemental Files
- Preface
- 1. What Is SQLite?
- 2. Uses of SQLite
- 3. Building and Installing SQLite
- 4. The SQL Language
- 5. The SELECT Command
- 6. Database Design
- 7. C Programming Interface
- 8. Additional Features and APIs
- 9. SQL Functions and Extensions
-
10. Virtual Tables and Modules
- Introduction to Modules
- Module API
- Simple Example: dblist Module
- Advanced Example: weblog Module
- Best Index and Filter
- Wrap-Up
- A. SQLite Build Options
- B. sqlite3 Command Reference
- C. SQLite SQL Command Reference
- D. SQLite SQL Expression Reference
- E. SQLite SQL Function Reference
- F. SQLite SQL PRAGMA Reference
- G. SQLite C API Reference
- Index
- About the Author
- Colophon
- Copyright
Product information
- Title: Using SQLite
- Author(s):
- Release date: August 2010
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596521189
You might also like
book
Relational Database Design and Implementation, 4th Edition
Relational Database Design and Implementation: Clearly Explained, Fourth Edition, provides the conceptual and practical information necessary …
book
40 Algorithms Every Programmer Should Know
Learn algorithms for solving classic computer science problems with this concise guide covering everything from fundamental …
book
Software Engineering at Google
Today, software engineers need to know not only how to program effectively but also how to …
book
Designing Data-Intensive Applications
Data is at the center of many challenges in system design today. Difficult issues need to …