Hi Konstantin,
On Jun 26, 2007, at 1:37 PM, Konstantin Osipov wrote:
* Paul McCullagh <[EMAIL PROTECTED]> [07/06/26 15:35]:
I am about to release the first version of the BLOB Streaming engine.
We are not that far yet (obviously), but our aim is to create an open
platform which will be extendable. So adding various image and
fulltext searching should be possible. Also the inclusion of
compression and encryption as you mentioned below.
Our client/server protocol and SQL interpreter do not have support
for blob streaming. We always copy the entire column to and from
the engine and, in the protocol, to the client.
So it would be actually very interesting to see how you
contemplate to deliver data between applications and the storage
engine.
The BLOB Streaming engine allows you to stream BLOB data directly
from a MySQL table using HTTP.
To store a BLOB to the database you will use the HTTP PUT method to
upload the data into a table row, and to retrieve a BLOB, you use the
HTTP GET method to download the data from a table row.
The URL specifies the database, table, column and search condition,
in order to identify the BLOB location.
It will also be possible to store the BLOBs "out-of-row". In this
case, only a BLOB reference is stored in the row. The reference is
basically a URL which can be used to retrieve the data. So when you
do an SQL SELECT which includes a BLOB column, the resulting rowset
does not contain the data, just the BLOB reference (URL).
The BLOB reference URL can be placed directly into an HTML page, or
the data can be retrieved by the application using HTTP when it is
needed.
In order to store a BLOB out-or-row, you upload the BLOB to MySQL
without specifying a target row. The PUT command returns the BLOB
reference. Then you do a normal INSERT, placing the BLOB reference in
the BLOB column. When the INSERT is committed, the uploaded BLOB is
committed to the database as well.
Best regards,
Paul
P.S. Thanks for your reply to "MySQL forces engine shutdown, and
hangs". Saved me quite a bit of time! :)
--
-- Konstantin Osipov Software Developer, Moscow, Russia
-- MySQL AB, www.mysql.com The best DATABASE COMPANY in the GALAXY
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
