November 27, 2005

PHP and SQLite

I compiled PHP version 5.1.0, and noted that by default, it installs the support libraries of SQLite, the normal driver and the PDO.

Looks like that database is making a huge success. When you access their homepage, you see that SQLite won the "Integrator" prize of Open Source Awards 2005.

The open source community is fully supporting this database, and it is so versatile that bests MySQL in speed.

Surely in small projects SQLite will do well, because MySQL 5 is a little bloated (with support to stored procedures, triggers, and that kind of stuff of enterprise-level databases).

You will see in a near future a lot of sites and softwares using SQLite. It's just a matter of time.