Using SQLite
Small. Fast. Reliable. Choose Any Three.
Publisher: O'Reilly Media
Released: 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.3

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (0)

  • 4 Stars

     

    (2)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (1)

  • 1 Stars

     

    (0)

67%

of respondents would recommend this to a friend.

Pros

    Cons

      Best Uses

          • Reviewer Profile:
          • Developer (3)

        Reviewed by 3 customers

        Sort by

        Displaying reviews 1-3

        Back to top

        (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-3

            Back to top

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