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 sharp 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

Autorentext

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.

Klappentext

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

Zusammenfassung
Whether you're developing applications for the desktop, the Web, embedded systems, or operating systems, the SQLite database provides an alternative to heavy-duty client-server databases such as Oracle and MySQL.

Inhalt

• Preface
• Chapter 1: What Is SQLite?
• Chapter 2: Uses of SQLite
• Chapter 3: Building and Installing SQLite
• Chapter 4: The SQL Language
• Chapter 5: The SELECT Command
• Chapter 6: Database Design
• Chapter 7: C Programming Interface
• Chapter 8: Additional Features and APIs
• Chapter 9: SQL Functions and Extensions
• Chapter 10: Virtual Tables and Modules
• SQLite Build Options
• sqlite3 Command Reference
• SQLite SQL Command Reference
• SQLite SQL Expression Reference
• SQLite SQL Function Reference
• SQLite SQL PRAGMA Reference
• SQLite C API Reference
• Colophon