Hi All,
I have just released PBXT 0.9.90 and MyBS version 0.5.03. PBXT is a
transactional storage engine for MySQL (http://www.primebase.com/xt),
and MyBS is a storage engine that enables streaming of BLOB data
directly in and out of a MySQL database (http://www.blobstreaming.org) .
For this release I have completed changes to the MySQL Connector/J
5.0.7, to allow BLOB data to be transparently stored and retrieved
from the MyBS BLOB repository. The new version of the driver is
called MySQL Connector/J SE (streaming enabled).
Uploading a BLOB is as simple as using setBinaryStream() or setBlob()
on INSERT. By using getBinaryStream() or getBlob() after a SELECT you
get direct access to the data stream coming from the repository. More
information and some examples are provided in the documentation at:
http://www.blobstreaming.org/documentation.
To try this out you need to install the latest versions of PBXT and
MyBS. Both are available from: http://www.blobstreaming.org/download.
Binary versions of the storage engines are also available for MySQL
5.1.22 running on 32-bit Linux and x86 Mac OS X. The modified version
of the JDBC source code is included in the MyBS source code
distribution, but the driver can also be downloaded here: http://
www.blobstreaming.org/download/mysql-connector-java-5.0.7se-bin.jar.
I have included a small test program, TestJDBC.java, as part of the
JDBC driver. So once you have installed the engines, you can test
BLOB streaming as follows:
java -cp mysql-connector-java-5.0.7se-bin.jar TestJDBC
TestJDBC connects to a local MySQL server, creates a PBXT table and
tests INSERT and SELECT of rows containing BLOBs. The program also
serves as an example of how to do BLOB streaming with JDBC.
To get started quickly, the most important things to note are:
* Set EnableBlobStreaming=true in your JDBC connection URL.
* Streamable BLOBs can only be stored in LONGBLOB columns in PBXT
tables.
* Use setBinaryStream(), setAsciiStream or setBlob() and specify the
length to upload a BLOB.
As usual, any comments, questions or bug reports can be sent directly
to me: paul-dot-mccullagh-at-primebase-dot-com. Make sure you put the
word PBXT or MyBS in the e-mail title to make it through my spam
filter! :)
Best regards,
Paul
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
