Using SQLite

Application developers, take note: databases aren't just for the IS group any more. You can build database-hacked 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 can develop a database-hacked application that remains manageable both 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

Jay A. Kreibich is a professional software engineer who has always been interested in how people process and understand information. He currently works for Volition, Inc., a software studio that specializes in open-world video games.