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
