News Feed
Jobs Feed

News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Justin Silverton's Blog:
Using sqlite and php
March 08, 2006 @ 07:18:31

Justin Silverton has posted this introduction to using SQLite and PHP on his blog. It describes what SQLite is and how to install PHP support for it.

SQLite is a small library that implements a self-contained, embeddable, zero-configuration SQL database engine. Features include: Transactions are atomic, consistent, isolated, and durable, Zero-configuration, Database files can be freely shared, Supports databases up to 2 terabytes, and many more.

Why would I need this? If you want to have the advantages of a SQL database, without having to install a separate system such as mysql or postgres. It has also been demonstrated to work on websites getting more than 1,000,000 hits per day.

The installation section is a bit short on the details, but does briefly cover both the unix and windows sides. Also included is a brief example of how to make a query on a SQLite database via the PHP functions compiled in.

0 comments voice your opinion now!
tutorial sqlite using install example tutorial sqlite using install example

blog comments powered by Disqus

Similar Posts

php|architect: More powerful Validation from Respect

SitePoint PHP Blog: Find and Correct Misspelled Words with Pspell

Jonathan Snook's Blog: Easier Static Pages for CakePHP 1.2 Update

Jan Lehnardt's Blog: Using the Zend Framework with Code Igniter (an alternative) Using cURL for Remote Requests

Community Events

Don't see your event here?
Let us know!

opinion component unittest overview threedevsandamaybe package install facebook symfony2 hack podcast language introduction hhvm code application release composer framework security

All content copyright, 2014 :: - Powered by the Solar PHP Framework