BLOB Streaming To-Do List
=========================

------- 2007-07-25

0015: Implement index support for the repository tables.

0014: Implement UPDATE/INSERT support for the repository tables.

0013: Implement  support for sorting the repository tables.

0012: Check limits and formats of given system variable values.

0011: Implement built-in functions BLOB_DATA() and/or BLOB_URL().

------- 2007-07-05

0010: Add content types [RESOLVED: RN10].

0009: Add create, access and reference timestamps [RESOLVED: RN9].

0008: Only open one file handle per file under UNIX.

0007: Implement RENAME TABLE with Blobs in the repository [RESOLVED: RN8].

0006: Implement DROP TABLE with Blobs in the repository [RESOLVED: RN7].

0005: Implement the MyBS compactor thread [RESOLVED: RN6].

0004: Implement the MyBS virtual tables [RESOLVED: RN11].

0003: Insert reference into a table. Implement reference and dereference BLOB [RESOLVED: RN5].

0002: Implement the file handle pool.

0001: Implement the temp BLOB list, including the temp list monitoring thread [RESOLVED: RN4].

------- 2007-06-19

There is still a lot to be done. The first version of the BLOB Streaming engine only allows download of selected column. The BLOBs must still be INSERTed into the database normally.

The next step is add support of the upload of BLOBs. It will then be possible to store BLOBs of any size in the database.

The streaming enabled storage engine will support this by storing BLOBs "out of record". When SELECTing these BLOBs from the server, a URL will be returned instead of the BLOB data. The URL can then be used GET the BLOB via the BLOB Streaming engine.

One of the top priorities is to introduce a security concept for the BLOB Streaming engine.

The current idea is to introduce a database user with a specific name (e.g. "mybs") who's grant profile reflects the columns that can be accessed via the BLOB Streaming engine.

I am still gathering ideas on this and other issue so input is welcome!

Paul McCullagh
SNAP Innovation GmbH
paul.mccullagh@primebase.com
www.blobstreaming.org