on March 5, 2006
As far as I know, this is the first book on SQLite and for that Chris Newman deserves a compliment.
Beyond that, this book is not very useful though:
1) It explains some basic SQL syntax but I didn't buy this book to learn SQL.
2) Very little information about the specifics and pitfalls of SQLite syntax, I rarely find what I'm looking for.
3) Being a PHP developer I don't need the chapters on C++, Perl, TCL and Python (about 25% of the book).
on September 2, 2008
SQLite is not intended to be a complete replacement to standard Database Management Systems. It IS, however, a good alternative to a full-blown database in some situations. Think of it as a simple database management system with NO RELATIONS - this may or may not be a problem for you and your project.
I would never use SQLite for a web site of any complexity - MySQL and other RDBMS's are simply too plentiful, powerful and easy to use. One great application I've found is to use SQLite in, say, a C++ application such as a game for saving information like player stats and scores. This saves you from having to do file i/o and parsing through text files. In such a situation, talking to an independent database server would cut the player off from the data if he was offline or otherwise not able to communicate with the server.