SQLite (Developer's Library) (Paperback)

by Chris Newman (Author)

Editorial Reviews

Product Description

SQLite is a small, fast, embeddable database. What makes it popular is the combination of the database engine and interface into a single library as well as the ability to store all the data in a single file. Its functionality lies between MySQL and PostgreSQL, however it is faster than both databases.

In SQLite, author Chris Newman provides a thorough, practical guide to using, administering and programming this up-and-coming database. If you want to learn about SQLite or about its use in conjunction with PHP this is the book for you.

About the Author

Chris Newman is a consultant programmer specializing in the development of custom web-based database applications to a loyal international client base.

A graduate of Keele University, Chris lives in Stoke-on-Trent, England, where he runs Lightwood Consultancy Ltd, the company he founded in 1999 to further his interest in Internet technology. Lightwood operates web hosting services under the DataSnake brand and is proud to be one of the first hosting companies to offer and support SQLite as a standard feature on all accounts.

More information on Lightwood Consultancy Ltd can be found at http://www.lightwood.net, and Chris can be contacted at [e-mail].

See all Editorial Reviews

Product Details

• Paperback: 336 pages
• Publisher: Sams (November 19, 2004)
• Language: English
• ISBN-10: 067232685X
• ISBN-13: 978-0672326851
• Product Dimensions: 9 x 6.8 x 0.9 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Average Customer Review: 2.6 out of 5 stars See all reviews (5 customer reviews)
• Amazon.com Sales Rank: #654,898 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

8 of 9 people found the following review helpful:

2.0 out of 5 stars Not great - doesn't cover SQLite 3.0, July 21, 2006

By	Dan Baker - See all my reviews (REAL NAME)

This is an old book, and doesn't cover the newer SQLite 3.x information.

8 of 10 people found the following review helpful:

2.0 out of 5 stars Not very useful, March 5, 2006

By	M. Overweg - See all my reviews (REAL NAME)

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).

0 of 1 people found the following review helpful:

3.0 out of 5 stars SQL Lite, September 2, 2008

By	Galaxy_Stranger - See all my reviews

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.