SQLite Expert is currently the most excellent SQLite database visual manager, which allows user to create, edit, copy, extract, and perform other database operations on a SQLite server. It is known as the best auxiliary software to develop SQLite3 database.
Navicat Premium is an award-winning universal database managing tool that is enough to meet professional database developers' all requirements. In particular, for newcomers to database servers, it is also quite easy to learn and use.
PHP 5 Power Programming is a classic must-read authoritative book with 720 pages of content published in 2004, cooperatively written by 3 PHP masters (PHP 5's chief designer - Andi Gutmans, PEAR's founder - Stig Saether Bakken and PHP's core contributor - Derick Rethans). Now its full copyright has been completely free.
EZDML is a free lightweight but practical database builder from China, with which we can quickly design a database table structure, and set up the data model. To a certain extent, we can see it as a super lite version of many commonly used database modeling tools (such as SAP PowerDesigner, CA ERwin, ER/Studio, Rational Rose family, and so on).
About the pros and cons of SQLite, AppNee does not comment. Because its long course of appearance and development has naturally proved it's superior (especially than Oracle and MySQL) enough to make it rule some application fields - such as database-driven mobile and desktop apps, as well as some small, lightweight network applications.
If you want to be familiar with SQLite, then starting with The Definitive Guide to SQLite, 2nd Edition is definitely a good idea (especially for beginners, after finishing its easy-to-understand and dapper content, you will get a good harvest). And in fact, guide books with the same quality for SQLite are hardly to find out on the market.