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.
Customer Reviews
Average Rating:
Rating: - SQL Lite
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 ... Read More
Rating: - Not great - doesn't cover SQLite 3.0
This is an old book, and doesn't cover the newer SQLite 3.x information.
Rating: - Not very useful
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).
Rating: - If you use Linux, stay away from ebooks
I was not aware that Adobe did not have an ebook reader for Linux. And since you can not print it, or copy/paste selections from this book (I use VMWare to run Windows apps), this book loses its usefulness altogether.
SQLite is a fine and simple database, with many advantages for developers of single-user software. But you (and SQLite) would be best served by buying the paperback edition.
Rating: - faster than MySQL
My impression was that PHP and MySQL were de facto two sides of the same coin. Many websites using PHP deploy MySQL on the backend. Indeed, there have been several books written about implementing this combination. But Newman offers a simple alternative. A stripped down SQL database that he claims will suffice for many websites. Indeed, he points out that SQLite has proved persuasive enough that PHP5 ships with it.
Going over its syntax, the book shows much of SQLite to be generic SQL. Given ... Read More
- SQL Lite
- Not great - doesn't cover SQLite 3.0
- faster than MySQL
