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.6

(based on 5 reviews)

Ratings Distribution

  • 5 Stars

     

    (0)

  • 4 Stars

     

    (4)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (1)

  • 1 Stars

     

    (0)

80%

of respondents would recommend this to a friend.

Pros

  • Accurate (3)
  • Easy to understand (3)
  • Well-written (3)

Cons

No Cons

Best Uses

  • Intermediate (3)
  • Novice (3)
  • Student (3)
    • Reviewer Profile:
    • Developer (5)

Reviewed by 5 customers

Sort by

Displaying reviews 1-5

Back to top

 
4.0

A book that is appealing to the programmer

By Tom

from Nacka, Sweden

About Me Developer

Verified Reviewer

Pros

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

Cons

    Best Uses

    • Expert
    • Intermediate
    • Student

    Comments about O'Reilly Media Using SQLite:

    A very good book. It is a book the I was absorbed by, and many evenings I just could not stop reading. I really like the style this book is written in. It is also a very informative book. In my view the examples have the perfect balance between brevity and details. Also the complexity (simplicity) of the examples are well chosen.

    The only thing that is not perfect is that the book is getting several years old by now. As a reader I cannot help wondering what changes has been introduced into SQLite since the book was written. Would it be time for an updated version of the book?

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

        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