Hello:
I discovered a new sqlite book that by description is very interesting, it is so new there are no reviews. I was hoping someone here will buy it, then tell me if I should do the same. ;D
http://www.amazon.com/SQL-Guide-SQLite-Rick-Lans/dp/0557076765/ref=sr_1_2?ie=UTF8&s=books&qid=1260400594&sr=1-2
or just search for "The SQL Guide to SQLite", by Rick Van der Lans
this is from the description:
It contains a complete description of the SQL dialect as implemented in SQLite version 3.6. The book can be seen as a tutorial and a reference book. Source code for the numerous SQL examples and exercises included in this book can be downloaded from www.r20.nl.(broken link)
thought this might be of interest.
Paul,
I just ordered and received this one....The Definitive Guide to SQLite. I have only had a chance to read the first few pages, but flipping through the subjects, it looks pretty good. When I search Barnes & Noble for SQLite, it found this one and another and when I read through the subjects covered, it looked like this one would be the best.
I'll let you know how this one goes ;)
Gary
I just received "The SQL Guide to SQLite" by Rick Van der Lans. As the title impies it is just the SQL part of SQLite. SQL beyond simple selects and a very basic join is one of my many weak areas. This book includes things like CASE, INTERSECT, EXCEPT, GROUP_COMCAT and many other topics of interest. It includes a full index (something lacking in "The Definitive Guide to SQLite"). I expect to be hitting this book alot and I'm sure I'll find many gems that will justify the cost.
To save typing all the SQL is available for download here:
http://www.r20.nl/SQLGuidetoSQLite_V1_1.htm (http://www.r20.nl/SQLGuidetoSQLite_V1_1.htm)
I ended up getting the book from Santa. I have started working through the examples. It is set up like tutorial-perfect for someone learning sqlite for desktop work. I will report later on a better review.
Any further feedback/updates on the value of this book?
-JohnM.