DeepRead
Cover of Using SQLite

Using SQLite

Jay A. Kreibich · 2010

Programming and computer science › Databases and distributed data

#14,283 most recommended

About the book

A practical guide to SQLite, the self-contained SQL database engine that stores a whole database in a single file. It covers installing and using SQLite, its SQL dialect and command-line shell, data types and schema design, and how to access databases from application code, with a focus on the C API. The book presents SQLite as a dependable option for application data storage, not only for prototyping, as long as the developer understands how it differs from client-server databases. It works through the consequences of its design, including single-file storage, file-level locking and concurrency limits, and flexible typing, and shows how to use transactions, indexes, and the API in ways that fit those constraints. Its practical claim is that careful use of these features gives reliable and reasonably efficient results in embedded and small-to-medium applications.

Written by Claude from what it knows of this book.

What Hacker News says 50% recommend · 0% critical

02420202021202220232020 peak · 1
This bookAverage book in Databases and distributed data

In the commenters’ own words

What Open Library readers say

No Open Library reader has rated it yet.

  • 1 want to read
  • 0 reading
  • 0 have read

Open Library’s page for the book

What critics say, via Wikipedia

No Wikipedia article about this book yet, so no critics to quote.

Reddit communities — coming later

Details

First published
2010
ISBN
9780596521189
Editions known
6 at Open Library
Open Library
OL15691213W

Application softwareDatabase managementRelational databasesSQL (Computer program language)

Explore in the mosaic

Read next: its neighbours on the mosaic