Jay A. Kreibich

Using SQLite

Small. Fast. Reliable. Choose Any Three.

• Broschiertes Buch

Produktbeschreibung

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. With this book, you'll get complete guidance for using this small and lightweight database effectively, including how to make SQLite an integral part of your application to help contain the size and complexity of your project.

---

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

---

Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.

Produktdetails

• Verlag: O'Reilly Media
• Seitenzahl: 526
• Erscheinungstermin: 21. September 2010
• Englisch
• Abmessung: 233mm x 181mm x 32mm
• Gewicht: 846g
• ISBN-13: 9780596521189
• ISBN-10: 0596521189
• Artikelnr.: 28972074

Autorenporträt

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.

Inhaltsangabe

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

Rezensionen

"Insgesamt gesehen hat das Buch [...] das Zeug zum Referenz-Titel. Ein umfangreicher Anhang mit allen SQL- und API-Kommandos rundet es ab." -- c't Heft, November 2010