If you've been reading much about PHP these days, you know that the SQLite extension is becoming the de facto standard for quick and easy database access. Unfortunately, outside of the documentation on their own site, there's not that much out there to work with. Well, PHP Magazine aims to help with that.

In their latest, SQLite - Part 1 (The Swiss army knife of data storage), they start off with some introductions, showing you what SQLite is and isn't. Moving on, installing SQLite is a breeze (even if you don't use the method they show), and you can quickly be using the extension in your code. They give a sample setup where they open a database, create a table inside, insert their data into the table, and then fetch it back out. This sample gives a very basic, but useful overview of the functionality this speedy little extension has to offer.

They continue on, giving a "real world" example - a simple guestbook you can use on your own site. It's definitely a good place to start, and should really give you a good overview of this fast and easy extension.