Re: Blob data

Hi Konstantin,

On Jun 26, 2007, at 1:37 PM, Konstantin Osipov wrote:

> * Paul McCullagh <paul.mccullagh@primebase.com> [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.

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

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/mysql?unsub=lists@pantek.com