In general, I have been very happy with it. It is a great introduction and provides lots of examples. I think of it as more of a tutorial than a reference manual. The SQLite web site is a better reference manual, but lacks the examples and sample code that the book offers. Once you get the basics down, it is pretty easy to out grow the usefulness of the book or any book for that matter. Any printed document for a living project is obsolete at the time of publication.
-Steve Stefan Arentz wrote: > Sorry if this is a little offtopic but I am curious what other people thing. > > Is it just me, or is the APress book 'The definitive guide to SQLIte' > not very high quality? > > First, the index is completely unusable. The index is grouped by > subject, so if you want to for example lookup where the book talks > about sqlite3_reset you first have to know that it is grouped under > the 'Prepared Query'. This is completely useless for looking up things > and I keep for a full index scan (heh) to find things. My copy of the > book mentions 'Find it faster at http://superindex.apress.com !' but > that site gives a 404. > > Also, the book seems to be inaccurate in a bunch of places. For > example, when I did find the section about sqlite_reset, I read the > following: > > "If you want to reuse the statement, you can do so using > sqlite3_reset(). It will keep the compiled SQL statement (and any > bound parameters), but commits any changes related to the current > statement to the database." > > Maybe the terminology used here is simply very confusing but I'm > pretty sure that sqlite3_reset does not commit anything. It only > resets the state of the prepared statement so that it can be used > again. > > The terminology used is also very inconsistent. For example the books > talks about 'Compiled SQL Queries', 'Prepared Queries', 'Prepared > Statements' and 'Compiled SQL Statements' instead of using simply > 'Prepared Statement' as the rest of the database world does. > > Some sections are pretty good and give a lot of insight, but in > general I am very disappointed and I think I will simply toss it away > and keep using the documentation on the SQLite web site. > > S. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
