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):
CREATE TABLE notes_tab (
n_id INTEGER PRIMARY KEY,
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:
With the following result:
So without even doing a
SELECT, you can GET a BLOB directly out of the database!
Note that there is no need for the BLOB in the database to be explicitly "streamable" for this to work.