News Feed
Sections




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

Zend Developer Zone:
SQLite Lean, Mean DB Machine
September 07, 2006 @ 07:41:38

On the Zend Developer Zone, there's a new tutorial looking at one of the unsung heroes of the web development world - one that, when you need it, it does what it does well - SQLite.

Is a full-blown database server even necessary for most PHP applications? What about a data-driven website like a blog or a simple family photo album or message board? In these and may other cases, the small, simple, and extremely powerful SQLite may be all you need. Let's take SQLite out for a test drive and see how it performs, find some of the quirks you might run in to, and how to get the most use out of it.

They talk about SQLite being a "staple" in PHP for a while now and how PDO plays so well with it. They move on to the code quickly, giving a simple example of how to create a database, and table, and inserting content into the latter.

Other more advanced features are discussed - data types, speed of queries, using transactions, and cleaning up the code to really make it fly. They even talk about "user defined aggregate functions", a method to make running a set of data through the same processes over and over a snap.

0 comments voice your opinion now!
sqlite tutorial introduction features database speed file pdo sqlite tutorial introduction features database speed file pdo


blog comments powered by Disqus

Similar Posts

Markus Wolff's Blog: ActiveRecord enhancements

Ralph Schindler's Blog: The Anatomy Of A Bug/Issue Reproduction Script

Christopher Bledsoe's Blog: PHP Dependency Injection (Inversion of Control)

Rami Alnawas: How to unit test code with Phalcon MVC Models

ThinkPHP Blog: Creating press-ready PDF documents on the fly including individual barcodes


Community Events





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


api laravel language composer podcast opinion interview series release voicesoftheelephpant unittest list threedevsandamaybe introduction framework symfony community conference version configure

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework