SQLITE

It is quite interesting to look at the SQLITE database. There is no server/client architechure. It strikes me that it was something like MSAccess that we use on some of our web services. However, it even gets better than that, it does not require ODBC setting.

For those data that we do not require security, for example bft results, it will be good idea to store the data in such database. The syntext of accessing is very simple. The example is below.


$db = new SQLiteDatabase("db.sqlite");

$result = $db->query("SELECT * FROM foo");

while ($result->valid()) {

$row = $result->current();

......

$result->next();

}

unset($db);

Compared with those that use ODBC, it is a breeze. There is no authentication whatsoever.

The next problem is of course obvious. How do I get the data? There is no import facility built in. Will think of some way to do it.