Quick PHP Code Tips and Examples

Here is a well-written step-by-step tutorial on how to use SQLite in PHP 5. The tutorial was written by Ilia Alshanetsky and featured in Zend Developer Zone.

SQLite Introduction

For those who don't know, SQLite is a lightweight embedded database management system, it is available as the default database engine for PHP5. Due to its embedded nature, SQLite store its database on a single file and is significantly faster than MySQL. Backing up SQLite database is as simple as copying its database file to a backup media.

SQLite is an excellent choice for creating and deploying portable web application without the need to do complex db setups on target machines.

Tags: php, php5, sqlite