File Size: 1811 KB
Print Length: 528 pages
Page Numbers Source ISBN: 0596521189
Simultaneous Device Usage: Unlimited
Publisher: O'Reilly Media; 1 edition (August 10, 2010)
Publication Date: July 6, 2012
Sold by: Digital Services LLC
X-Ray: Not Enabled
Word Wise: Not Enabled
Lending: Not Enabled
Enhanced Typesetting: Not Enabled
Best Sellers Rank: #395,967 Paid in Kindle Store (See Top 100 Paid in Kindle Store) #153 in Books > Computers & Technology > Software > Databases #287 in Books > Computers & Technology > Databases & Big Data > SQL #313 in Kindle Store > Kindle eBooks > Computers & Technology > Databases
I have been using SQLite for about a year and thought I knew it reasonable well. After working through Using SQLite, I am a bit humbled. The author adds another layer of knowledge that is not present in the standard documentation. The book includes many addition nuggets of knowledge about the dialect of SQL used in SQLite and its C-interface. I learned a great deal from this book and have been revising my code since reading it.This book is not an introduction to SQL or SQLite. There are plenty of book for the former, and plenty of web pages for the latter. I would suggest you read/purchase Using SQLite after you build the hello world of SQLite programs but before you use it in your product.
Very detailed explanation of various SQLite commands, but VERY FEW EXAMPLES. This is weird because usually OReilly books are rich with examples, but this is an exception. Since the net provides very few rich examples of SQLite usage, a cookbook-style SQLite volume would be a big help. This isn't it. Not worth the Kindle price.
This book is not a tutorial book, which is why there aren't many coding snippets as many negative reviewers point out. This is a book for experienced developers (preferably C/C++ because the author uses its APIs, but not necessary) who found themselves seeking for a deeper understanding of SQLite in order to architect a better db and write efficient apps. I found this book particular easy to read because it's written by someone like ourselves who actually struggled and had to dig around for better insights, not as one of the SQL developers who might give us a good top-down view and details but lack the fundamental understanding of "Why we needed the book in the first place!".
This book is fairly well written and informative. I was already familiar with SQL but learned a lot about this particular flavor. I am not programming in C so a big chunk of the book (perhaps 1/3) was irrelevant to me.
SQLite is a great option for those that want to get a database up and running quickly, yet still with plenty of power. Great for prototyping, intranet applications, or any app that needs a small database, SQLite is the perfect solution for many, many problems that need to be solved. Instead of having to set up a server or get a DBA to go through the confusing steps of using Oracle or SQL Server, SQLite is eeeeeasy. 'Using SQLite' will show you how to set up your database, work with SELECT statements, designing your database, learning to interface with said database in C, working with built-in SQL functions, and a whole lot more.If you need a database that will get you moving quickly, this is a fantastic option. The writing is solid and enjoyable, and you get this in a nice package.***** HIGHLY RECOMMENDED
I consult this book regularly in my day to day use of SQLite. There is no information in this book which can not be found elsewhere, but the book captures everything very clearly and it is rare to find a case where the book does not provide the information which is needed.
"Using SQLite" by Jay Kreibich was just what I needed to add SQLite 3 relational database to one of my projects. This book is aimed at the C++ developer (and those who use certain scripting languages) who finds a need for a relational database, but doesn't want to assume the end user has a properly configured Oracle, MySQL, SQL Server or other massive database (requiring an administrator). As the author points out, SQLite is not a replacement for these enterprise-level database, but is often "good enough" for a many programming problems.Kreibich does a good job of covering all the basics a programmer needs to get started with SQLite: how to obtain the library (and build it if necessary), SQL language, API descriptions and usage, and a fair number of understandable examples. I was able to learn enough from this book to integrate successfully SQLite into my project.My only minor quibble is the book only hints at some of the more advanced features of SQLite; the author had to draw a line somewhere, otherwise the book would never been finished (and since my project had little use for these advanced subjects, I was not too upset). To the author's credit, he does attempt explanations of relational database concepts not specific to SQLite (table concepts, "normal" forms, indexes, etc.), but topics most C++ developers would have little familiarity.SQLite, by the way, is an embedded database, requiring no DB Admin to keep things running on the user's side. ADO.NET is not covered here, although there are .NET providers for SQLite (some free, others not). That would be subject for another book.
Many times you need a small database, and don't need / want to set up a server to run it. SQLite is the answer, and is probably the most installed database in the world. Using SQLite helps you get started, gives you a database / SQL primer, and in the second held of the book gives you programming API details initially in C with brief help in a variety of other languages later in the book.I bought the Kindle version, and found the ability text search made it invaluable.