HomePHP Using Unbuffered Queries and More with SQLite with PHP 5
Using Unbuffered Queries and More with SQLite with PHP 5
Are you one of those PHP developers looking for a tight and powerful RDBMS, other than MySQL, in order to build your next database-driven website? Then hopefully your search is finished. Welcome to the second installment of the series ďUsing SQLite with PHP 5.Ē Comprised of three articles, this series walks you through the implementation of the most important methods that come bundled with SQLite and shows you how to use them with numerous practical examples.
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!