Using Unbuffered Queries and More with SQLite with PHP 5

As the patient reader that I think you are, you’ll remember that over the first article I covered some of the most relevant methods included with SQLite. Many of them were focused on creating databases and tables, as well as running queries and fetching rows from a given result set. As you learned previously, SQLite is really easy to work with, as it boasts a fully-featured RDBMS system. This system is based primarily on the file system to create the corresponding database structure, although memory-based databases are also supported.

In addition to the handy features that you learned in the first article of the series, SQLite comes packaged with many more methods that can be truly helpful for working with unbuffered queries, counting and seeking rows, and finding insertion IDs. Even though the SQLite library has been integrated into a small package along with the PHP 5 distribution, I’m sure that you’ve already realized its remarkable capabilities.

Taking into account the group of characteristics that I mentioned a few lines above, in this second tutorial of the series, I’ll be taking a look at some of them. This will give you a clearer idea of how to use them as part of your existing and -- why not? -- future PHP applications.

Indeed, the subject looks interesting, therefore let’s no waste more time in preliminaries and continue discovering more handy methods included with SQLite. Let’s get going!