Docunext


SQLite PHP

August 21st, 2007

With the help of Zend's developer zone, I made my first SQLite script:

#!/usr/local/bin/php";    print_r($row);    /* each result looks something like this    Array    (        [0] => 1        [id] => 1        [1] => Ilia        [name] => Ilia    )*/}?>

So far, I'm pretty excited about using sqlite. I was concerned about the foreign keys, but I just found this. You can create the equivalent of foreign key constraints with triggers, and triggers are supported by SQLite, Postgres, and MySQL!

Following on that minor progress, I added basic SQLite support to the pdo datasource in nexista.

Yearly Indexes: 2003 2004 2006 2007 2008 2009 2010 2011 2012 2013 2015 2019 2020