PhpRiot
News Archive
PhpRiot Newsletter
Your Email Address:

More information

FWebDe Blog: Use SQLite For Your Next PHP Project

Note: This article was originally published at PHPDeveloper on 12 August 2010.
PHPDeveloper

On the FWebDe blog there's a recent post from Eric Bannatyne about using SQLite in your next project.

SQLite is one of those awesome pieces of software known for its "liteness". It is, as you can guess from the name, a database designed to have as small a footprint as possible. SQLite is a very popular database, in fact, it is believed to be the most widely deployed SQL database engine in the world.

He gives some reasons why to choose this database tool and introduces you to some of the basics - creating a database, connecting to it from PHP and running a query. He ties this all together in a complete example of connecting to the database and inserting post information into a table.