[Vfs-devel] class.DBI

[Abdul-Wahid P. <ee...@we...>]

I have just been playing around with class.DBI and it seems to work fine
with Postgres. I haven't tried any other database though but I am sure
they work properly.

There are a few issues around using class.DBI that we need to resolve.
Manly due to the use of BLOBS for file storage. The way that PHP handles
blobs for Postgres, Oracle and Informix is complete different. Mainly
because there is no standard way that the databases handle blobs. I
suggest that we have different functions for the individual databases that
use blobs. Where should they go? May be we could still put them in
some_database_wrapper.inc that gets included from by the db_wrapper.inc.
The structure would then be something like this:

header.inc calls vfs_auth.inc, db_wrapper.inc and config.inc

db_wrapper.inc calls some_database_wrapper.inc and loads class.DBI

class.DBI loads the relevant class.DBD::some_database

NOTE: we might also need to use the some_database_wrapper.inc to do other
database specific functions like: using sequences, formating dates, etc.

I suggest also that we create a directory /lib where we put the .inc
files and the class.DBI stuff. We might have to change the class.DBI
slightly because it calls the DBD driver from the current directory which
won't be /lib but / becuase that is where the .php script will be running
from.

Anyone else got any ideas on all of this?

Regards,

AW