Re: [Vfs-devel] Back to work....

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

Hi Tony,

> Actually no code was done for the MySQL part. I figured it would be best to
> have one version done (like the PGSQL version). Then do the MySQL and all
> other versions off that. From then on it would be easy to update each
> version with single new features at the same time. This is just to stop each
> database file from heading into different directions before the initial
> multi-database version of VFS was released. 

Ok. That seems like sound reasoning. I should be able to finish the
multi-database framework this weekend. I will let you know how I get on.
It should be quite easy then to start adding extra database support.



> What I *have* been doing is
> research and planning. I found out that the latest versions of MySQL support
> a 'Load_File($filename)' function to get the contents of a file into a
> string. It was introduced in version 3.23.0. This would be good to use as it
> gives the same ability as the 'pg_lo()' function. Here are the limitations:

version 3.23.0 is the latest beta right? They say it GPL'ed aswell which
sorts out some of the liscensing issues. Is it stable? Should I install
this version on my production server?
 
> LOAD_FILE(file_name)
>     Reads the file and returns the file contents as a string. The file must
> be on the server, you must specify the full pathname to the file, and
> you must have the file privilege. The file must be readable by all and be
> smaller than max_allowed_packet. If the file doesn't exist or can't     be
> read due to one of the above reasons, the function returns NULL.

So far this doesn't sound so different to the Postgres way
 
> max_allowed_packet is an option in the my.cnf file which the default for
> is -- 1meg. Now the question is -- do we want to support this function? As
> it would mean that are only supporting 3.23.0 and > versions of MySQL. I say
> yes. 90%+ of all solid MySQL users upgrade every time a new version is
> released. What do you think?

I don't think that it is really a problem to support this function.
Remember, we still have a long development cycle infront of us. This is
just the beginning. We still have to add, directory support, groups of
users and many other features. In that time I am sure we will change the
database structure again and again. By the time we finalise the database
structure I am sure most people will have upgraded to the latest version.

Anyway, I am not one for developing a new product and trying to include
backward compatibility. It is best to develop to the bleeding edge. On
this note....I am even thinking we should move to PHP4 soon as many people
are already make the move (including many of my servers).

Anyway, let me try to finish what I need to do and then we can try to
integrate your mySQL stuff.

Regards,

AW