One of the challenges faced by developers using MySQL is how to handle BLOBS in an efficiently and reliable manner. Storing BLOBs directly in the database has the limitation in that the BLOB cannot be larger than the maximum row size and operations involving BLOBs are slow and consume large amounts of memory. Storing the BLOBs outside the database results in loss of control by the database server: no backup or replication of BLOB data and unreferenced blobs or references to no existing blobs is always possible.
My session will show how to create tables that will utilize the PrimeBase BLOB streaming engine (PBMS) to efficiently store BLOB data in the database. It will also demonstrate how to build client applications using the PBMS ‘C’ API and PHP to stream BLOB data in and out of the database. The example application will make use of traditional MySQL storage engines such as MYISAM and InnoDB.
In addition to this demonstration I will explain how BLOB streaming works and why it is an improvement over traditional ways of storing BLOBs.
To end the session the future plans for BLOB streaming will be discuss with regards to remote BLOB storage and retrieval.
Barry Leslie is a core developer of the PrimeBase BLOB Streaming engine and cofounder of SNAP Innovation GmbH, Germany, where he is a senior developer in core technology. He has 20 years of software development experience. Barry has a Bachelor of Science in Computer Science from the University of Victoria and a Bachelor of Technology in Industrial Engineering from Ryerson University Toronto.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at firstname.lastname@example.org
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.