~ubuntu-branches/ubuntu/saucy/drizzle/saucy-proposed

0030: Implement pbms_keep_alive. This could be done at the socket level. The threads could set a timeout value before beginning a read/write operation. A seperater thread would monitor the workers and interupt them if the timeout expired.

------- 2009-01-13

0025: Port to Windows.

0024: Add a system table for HTTP meta data fields.[RESOLVED: RN54]

0023: Implement index support for all PBMS system tables.

0022: Add support for BLOB access via the BLOB alias.[RESOLVED: RN53] [Feature removed: RN190]

0021: Add transaction support.[RESOLVED: RN64]

------- 2008-09-11

0020: Add built in functions for use in triggers to enable non Media Streaming enabled engines to use PBMS.[RESOLVED: RN45] [Feature removed: RN59]

0019: Register a port number to be used as the default HTTP port number used by the daemon.

0018: Enable the HTTP server to handle 1000+ connections efficiently.

0017: Make the HTTP server more robust so that it can tolerate HTTP connections that do not have the keep-alive set but do not terminate immediately after receiving a reply.

0016: Add a connection timeout so that the HTTP server can close idle HTTP connections.

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

0015: Implement index support for the repository tables.

0014: Implement UPDATE/INSERT support for the repository tables.[RESOLVED: RN51, RN52]

0013: Implement support for sorting the repository tables.[RESOLVED: RN58]

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 daemon only allows download of selected column. The BLOBs must still be INSERTed into the database normally.

100

101

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.

102

103

The streaming enabled storage daemon 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 daemon.

104

105

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

106

107

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 daemon.

108

109

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

110

111

Barry Leslie

112

PrimeBase Technologies GmbH

113

barry.leslie@primebase.com

114

www.blobstreaming.org

Older »