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.
"Complex SQL concepts explained clearly."
What people are saying - Write a review
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
Appendix A SQLite Build Options
Appendix B sqlite3 Command Reference
Appendix C SQLite SQL Command Reference
Appendix D SQLite SQL Expression Reference
Appendix E SQLite SQL Function Reference
Appendix F SQLite SQL PRAGMA Reference
Appendix G SQLite C API Reference
Chapter 9 SQL Functions and Extensions
Chapter 10 Virtual Tables and Modules