Using SQLite
Small. Fast. Reliable. Choose Any Three.
Publisher: O'Reilly Media
Final Release Date: August 2010
Pages: 530

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

Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
O'Reilly MediaUsing SQLite
 
3.5

(based on 4 reviews)

Ratings Distribution

  • 5 Stars

     

    (0)

  • 4 Stars

     

    (3)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (1)

  • 1 Stars

     

    (0)

75%

of respondents would recommend this to a friend.

Pros

    Cons

      Best Uses

      • Novice (3)
        • Reviewer Profile:
        • Developer (4)

      Reviewed by 4 customers

      Sort by

      Displaying reviews 1-4

      Back to top

       
      4.0

      Good for beginners

      By J. Pérez

      from Europe

      About Me Developer

      Pros

      • Accurate
      • Easy to understand
      • Well-written

      Cons

      • More Examples

      Best Uses

      • Novice
      • Student

      Comments about O'Reilly Media Using SQLite:

      This is a well written book to get in touch with SQLite.
      Nice book for beginners but should include more examples.

      (7 of 7 customers found this review helpful)

       
      4.0

      good for a beginner

      By the massist

      from Paris, France

      About Me Developer, Scientist researcher

      Verified Reviewer

      Pros

      • Accurate
      • Concise
      • Easy to understand
      • Well-written

      Cons

      • Give more examples

      Best Uses

      • Intermediate
      • Novice

      Comments about O'Reilly Media Using SQLite:

      I am a complete beginner in SQL (although I'm a seasoned programmer in C/C++) and I found this book very informative. Certainly, it takes the time it needs to explicate the fundamentals of SQL. The chapter about database design has proved useful to me. In four days did I write a program that parses XML files and funnels data into the database (a dozen tables).

      In a word : highly recommended for novices in SQL with programming background.

      (7 of 12 customers found this review helpful)

       
      2.0

      Doesn't have (enough) examples.

      By MDS

      from Europe

      About Me Developer

      Verified Reviewer

      Pros

      • None

      Cons

      • Too basic

      Best Uses

      • Student

      Comments about O'Reilly Media Using SQLite:

      Firstly this book spends to much ink on introduction, it can be ok if this book is written for theoretical purposes, which is not. I'm familiar with two sql dialects, and I was hoping to find examples, not to read 100s of pages of theory. No (much) real examples can be found in this book. There is no even one full example for transactions, which is core of software implementation when databases are included.

      (5 of 5 customers found this review helpful)

       
      4.0

      Good for getting up to speed

      By JVP

      from San Diego

      About Me Developer

      Verified Reviewer

      Pros

        Cons

          Best Uses

          • Intermediate
          • Novice

          Comments about O'Reilly Media Using SQLite:

          I'm currently reading it. Good intro to the SQLite version of SQL, and to the ins and outs of SQLite. Readable and useful. At certain points in the text I'd prefer more, or more complex, examples; but for that I'd give it 5 stars.

          Displaying reviews 1-4

          Back to top

           
          Buy 2 Get 1 Free Free Shipping Guarantee
          Buying Options
          Immediate Access - Go Digital what's this?
          Ebook: $41.99
          Formats:  APK, DAISY, ePub, Mobi, PDF
          Print & Ebook: $54.99
          Print: $49.99