Current plans call for the use of the HTTP protocol to upload and
retrieve BLOBs to and from the database. The BLOB Streaming
Engine makes this possible by integrating a lightweight HTTP
server directly into the MySQL server.
I am currently working on an alpha implementation of this, and
would like to give a short demonstration of what is possible
using this system.
We start by creating a table using any streaming enabled storage
engine (a streaming enable storage engine, is an engine that
supports the server-side streaming API):
use test;
CREATE TABLE notes_tab (
n_id INTEGER PRIMARY KEY,
n_text BLOB
) ENGINE=pbxt;
INSERT notes_tab VALUES (1, "This is a BLOB streaming test!");
Now assuming the MySQL server is on the localhost, and the BLOB
streaming engine has been set to port 8080, you can open your
browser, and enter this URL:
…