
Using SQLite
Jay A. Kreibich · 2010
Programming and computer science › Databases and distributed data
#14,283 most recommended
Hacker News
2
mentions by 2 people · top 79% of 15,732 books
Open Library
—
No ratings yet
1 want to read
Wikipedia
—
No article yet
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
In the commenters’ own words
I recently came across a section in the book "Using SQLite" by Jay A. Kreibich where he mentions[1] the `SQLITE_OMIT_*` compile-time directives. > Using the…
They are The Definitive Guide to SQLite by Mike Owens and Using SQLite by Jay A. Kreibich. I am quite sure they are more book than I needed, I only plumbed a…
What Open Library readers say
No Open Library reader has rated it yet.
- 1 want to read
- 0 reading
- 0 have read
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)
Read next: its neighbours on the mosaic
The Definitive Guide to SQLiteMike Owens · 2006 · recommended by 5 people · similar by subject and what people say about it
SQL puzzles & answersJoe Celko · 1997 · recommended by 3 people · loosely similar by subject
Joe Celko's SQL for SmartiesJoe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
SQL for DummiesAllen G. Taylor · 1993 · recommended by 1 person · similar by subject and what people say about it
Database design and implementationEdward Sciore · 2008 · recommended by 7 people · similar by subject and what people say about it
SQL Queries for Mere MortalsJohn L. Viescas · 2018 · recommended by 2 people · similar by subject and what people say about it
Learning SQLAlan Beaulieu · 2005 · recommended by 3 people · similar by subject and what people say about it
UNIX relational database managementRod Manis · 1988 · recommended by 2 people · similar by subject and what people say about it
SQL and relational theoryC. J. Date · 2009 · recommended by 9 people · similar by subject and what people say about it
SQL antipatternsBill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
Developing time-oriented database applications in SQLRichard T. Snodgrass · 1999 · recommended by 6 people · similar by subject and what people say about it
An introduction to database systemsC. J. Date · 1975 · recommended by 14 people · loosely similar by subject
Readings in database systemsMichael Stonebraker · 1998 · recommended by 11 people · loosely similar by subject
SQL for Web NerdsPhilip Greenspun · 2000 · recommended by 7 people · loosely similar by subject
Foundations of databasesSerge Abiteboul · 1994 · recommended by 1 person · loosely similar by subject
The art of SQLStephane Faroult · 2006 · recommended by 8 people · loosely similar by subject
Sams teach yourself SQL in 10 minutesBen Forta · 1999 · recommended by 0 people · loosely similar by subject
Database System ConceptsKorth · 2005 · recommended by 4 people · loosely similar by subject
Database in depthC. J. Date · 2005 · recommended by 4 people · loosely similar by subject
Dying Earth - BaenJack Vance · 1950 · recommended by 22 people · loosely similar by subject
The Conspiracy Against the Human RaceThomas Ligotti · 2010 · recommended by 13 people · loosely similar by subject
HardwiredWalter Jon Williams · 1986 · recommended by 7 people · loosely similar by subject
Tomorrow FileLawrence Sanders · 1975 · recommended by 2 people · loosely similar by subject
The Night ManagerJohn le Carré · 1993 · recommended by 2 people · loosely similar by subject