Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:37910
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 74.125.46.28 as permitted sender)
DomainKey-Status: bad
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:mime-version:content-type;
        b=DJTs7Tg4RJDnh7tYTsE7bmdRLEt5YlLFwRy4RCSjF9ITTBBniv+tRZbWBmN+2ppWnG41W1QP9c2mL39dV3gM0qSrdZsueP6pbIb+B9AMuZn3LI6kHtsMu8OGp1TV+e6b+seVc3gVFc0rmfSlbkifYJ4IGLSaYRqPDlYMp9DRbCc=
Message-ID: <d75889800805261355s5da87e89pa0d0d10de843d246@mail.gmail.com>
Date: Tue, 27 May 2008 02:25:47 +0530
To: "PHP Internals" <internals@lists.php.net>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_13976_23599218.1211835348008"
Subject: Streaming Enabled MySQL Driver for PHP - Google Summer of Code 2008 - MySQL
From: prf.kishorekumar@gmail.com ("KishoreKumar Bairi")

------=_Part_13976_23599218.1211835348008
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello all,

I'm KishoreKumar Bairi, Google Summer of Code Student for MySQL.

Project: *Streaming Enabled MySQL Driver for PHP*

Details:

MyBS[1] is a storage engine used along with other engines to manage BLOB
data efficiently.
MyBS maintains a blob repository for each database to store the blobs
belonging to that database. Each blob stored in this repository has a unique
ID which can be used to reference that blob. MyBS has an embedded light
weight webserver which interfaces the blob repository and client.

 BLOBs can be stored in this repository by sending HTTP PUT request to the
embedded web server which returns the unique ID that can be stored in
database to refer this blob later. To retrieve this BLOB, HTTP GET request
for referencing URL is sent to the embedded web server.

This task involves addition of two functions to 'mysqli'.

1. resource mysqli_get_blob ( mysqli link, string reference )

reference: is the string which used after database part in the referencing
URL.
It can be repository Id (or) "<table>/<column>/<row condition>".

2. string mysqli_put_blob ( mysqli link, string file_path, string mode , int
length )

file_path: is the path of the file which is to be stored in a blob field.

mode: mode specifier if the file should be read ASCII mode or binary mode.

link: is the object representing the MySQL database connection.
So, finally this is how the usage will be.

Procedural style:
1. resource mysqli_get_blob ( mysqli link , string reference )
2. string mysqli_put_blob (mysqli link ,string file_path, string mode , int
length)

Object Oriented style:

(methods)

mysqli {
   resource mysqli_get_blob ( string reference )
}

mysqli {
   string mysqli_put_blob(string file_path, string mode , int length)
}

Looking forward for suggestions and comments.


[1] http://www.blobstreaming.org/


Regards,
KishoreKumar Bairi.

------=_Part_13976_23599218.1211835348008--