Using SQLite

Front Cover
"O'Reilly Media, Inc.", Aug 17, 2010 - Computers - 503 pages
0 Reviews

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

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Chapter 1 What Is SQLite?
1
Chapter 2 Uses of SQLite
9
Chapter 3 Building and Installing SQLite
17
Chapter 4 The SQL Language
27
Chapter 5 The SELECT Command
61
Chapter 6 Database Design
87
Chapter 7 C Programming Interface
115
Chapter 8 Additional Features and APIs
159
Appendix A SQLite Build Options
269
Appendix B sqlite3 Command Reference
287
Appendix C SQLite SQL Command Reference
299
Appendix D SQLite SQL Expression Reference
341
Appendix E SQLite SQL Function Reference
361
Appendix F SQLite SQL PRAGMA Reference
381
Appendix G SQLite C API Reference
409
Index
491

Chapter 9 SQL Functions and Extensions
181
Chapter 10 Virtual Tables and Modules
217

Other editions - View all

Common terms and phrases

About the author (2010)

Jay Kreibich is a professional software engineer who has always beeninterested in how people process and understand information. He iscurrent working for Volition, Inc., a software studio that specializesin open-world video games. He lives on a small farm in central Illinois with his wife and two sons, where he enjoys reading, photography, and tinkering.

Bibliographic information