SQLite as a MySQL replacement with PHP?

[brandon6684]

Right now my favored web development is with PHP and MySQL, but I've thought about going a bit more light weight on my web servers. I've already switched from Apache to lighttpd, but now I'd like to go after the database with a lightweight solution, and SQLite looks like a nice little database.

Does anyone here have any experiance with SQLite in this area?

Where there any "must have" features that were missing compared to MySQL?

Did is scale okay(at least as well as MySQL)?

 

[Super Macho Man]

It can be done, but the documentation/help on the internet is not that good, and much of it is outdated. PHP support for SQLite3 is through PDO and is somewhat buggy. The tools used to manage it are also not as mature as e.g. phpMyAdmin. However, I do recall reading somewhere that it is a very fast db.

http://www.sqlite.org/omitted.html