What do you think?
Rate this book
Using SQLite: Small. Fast. Reliable. Choose Any Three.
Application developers, take 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.
526 pages, Paperback
First published August 10, 2010
42 people are currently reading
60 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 9 of 9 reviews
February 25, 2021
How to rate and review this book?
I am not sure what the purpose of this book is and who the target audience is.
It is not a study book as there are barely any examples and no exercises.
It is not a beginners book as important topics like normalization just get a couple of pages. It also expects you to know C.
It is probably most useful for people who have (a lot) of experience using and managing other databases and want to start using SQLite.
For me, I think I might use the book as a reference manual in the future, and more specifically the appendices. It has been to long since I last worked as a DBA, for this book to be useful.
I gave it 3 stars, because I acknowledge that it can be a very useful book, but not for me right now.
I am not sure what the purpose of this book is and who the target audience is.
It is not a study book as there are barely any examples and no exercises.
It is not a beginners book as important topics like normalization just get a couple of pages. It also expects you to know C.
It is probably most useful for people who have (a lot) of experience using and managing other databases and want to start using SQLite.
For me, I think I might use the book as a reference manual in the future, and more specifically the appendices. It has been to long since I last worked as a DBA, for this book to be useful.
I gave it 3 stars, because I acknowledge that it can be a very useful book, but not for me right now.
November 18, 2022
Overall, this is a good reference for SQLite, given that SQLite has plenty of quirks. The book is moreso based on the SQLite implementation of SQL - building and installing, its implementation of data types, etc. In my opinion, you'd be better served to learn SQL another way first. For being a standard language, SQL has many vendor-specific implementations.
The book is split - about half is just reference for SQLite's SQL, and the C API. Of the other half, about half of that is building and installing SQLite, and the C API - The examples of which are helpful, but I would say understanding C is a huge prereq, especially structs and pointers. The last quarter of the book, then, covers the standard "SQL usage".
Ultimately, if you are looking for a reference to start using SQL or SQLite, I would start elsewhere. If you want to learn how you use custom fuctions, modules, and the C API, this book is especially helpful for that. But, for what it's worth, I'd rather just use Python for everything except virtual tables, and will be slowing moving most of my projects to postgreSQL. Not really an option if you want to build a mobile app or something like that.
The last caveat is that this book was written in 2010, so SQLite has added some functionality since then - so you'll at least need to supplement with the latest docs.
The book is split - about half is just reference for SQLite's SQL, and the C API. Of the other half, about half of that is building and installing SQLite, and the C API - The examples of which are helpful, but I would say understanding C is a huge prereq, especially structs and pointers. The last quarter of the book, then, covers the standard "SQL usage".
Ultimately, if you are looking for a reference to start using SQL or SQLite, I would start elsewhere. If you want to learn how you use custom fuctions, modules, and the C API, this book is especially helpful for that. But, for what it's worth, I'd rather just use Python for everything except virtual tables, and will be slowing moving most of my projects to postgreSQL. Not really an option if you want to build a mobile app or something like that.
The last caveat is that this book was written in 2010, so SQLite has added some functionality since then - so you'll at least need to supplement with the latest docs.
December 30, 2021
Buku yang bagus dan bermanfaat. Bukan untuk pemula. Ini adalah buku urutan ke dua yang saya baca setelah sebelumnya membaca Getting Started SQL yang keduanya membahas tentang SQLite. Kedua buku ini pun sama-sama dibimbing dan didukung oleh pembuat bahasa SQLitenya sendiri. Buku ini melengkapi hal-hal yang sengaja ditinggalkan dari buku pertama. Pembahasannya panjang lebar, teknis, dan mendetail. Agak rumit dan berat sebenarnya. Buku yang paling lengkap mengenai seluk beluk SQLite.
Hanya saja kekurangannya buku ini sudah lumayan tua bahkan saat ini sudah lebih dari satu dekade. Untungnya SQlite merupakan bahasa yang stabil dan menjaga dengan erat kompatibelitas kebelakang dengan versi-versi lamanya. Jadi kesimpulannya masih layak untuk dibaca dan memiliki banyak manfaat. Harapannya pada suatu saat yang dekat akan ada diterbitkan edisi terbarunya dengan pembaruan dan menghilangkan bagian yang tidak relevan lagi. Ketika itu terjadi saya yakin bintang lima layak didapatkan buku ini.
Hanya saja kekurangannya buku ini sudah lumayan tua bahkan saat ini sudah lebih dari satu dekade. Untungnya SQlite merupakan bahasa yang stabil dan menjaga dengan erat kompatibelitas kebelakang dengan versi-versi lamanya. Jadi kesimpulannya masih layak untuk dibaca dan memiliki banyak manfaat. Harapannya pada suatu saat yang dekat akan ada diterbitkan edisi terbarunya dengan pembaruan dan menghilangkan bagian yang tidak relevan lagi. Ketika itu terjadi saya yakin bintang lima layak didapatkan buku ini.
Read
July 2, 2019Really good reference.
April 25, 2020
Great intro material and nice chapter on designing a database model with solid examples.
August 5, 2020
For some solutions less is more.
Read
March 10, 2022Useful ref
October 20, 2012
This is the most complete book on SQLite, covering the basics and advanced topics, including user-defined functions and virtual tables. Readable, correct and has more (useful) appendixes than you could shake a stick at.
March 26, 2014
Read it on my Kindle. Fairly straightforward language used, considering the topic. For others who are interested in this topic, this book is worth your attention.
Displaying 1 - 9 of 9 reviews