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

[Tony K. <tk...@ca...>]

> Hi guys,
>
> I am back after a week in the sun and I am ready to start work again. Can
> I just touch base with everyone and see how much work has been done.
>
> Tony: How have you done on the mySQL development?

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. 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:

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.

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?

Regards,
Tony Kirk