Getting data out of MySQL

Paul McCullagh implemented an interesting way to get BLOBs out of a MySQL database by using a URL. It is really very simple:

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:

http://localhost:8080/test/notes_tab/n_text/n_id=1

I suggested that we could extend this to returning data from any table using JSON which would provide a very nice REST access method into the data without having to go through the overhead of logging in and dealing with a SQL statement.