Hi,

On 12/4/08 6:14 PM, "Brian Aker" <[EMAIL PROTECTED]> wrote:

> Hi!
> 
> On Dec 3, 2008, at 4:43 PM, Barry Leslie wrote:
> 
>> 1) I am thinking a better name for this plug-in type mat be
>> "DataFilter"
>> since it could be used to perform non blob related operations on
>> data at the
>> handler level.
> 
> Hi!
> 
> Should this just be a callback() for insert/delete/update that we call
> at the same point where we call for replication?
> 
> We could just generically pass table in and you can do whatever you
> like?
> 

This is more or less what it does although it needs to know about tables
being dropped or renamed.

It is a bit different from a normal plugin because only one blobcontainer
plugin can be loaded at a time. This is because the plugin replaces blob
data being inserted or updated with a kind of blob URL, storing the actual
BLOB data some where else.

I rethought the idea of making this a generic 'filter' plugin and decided it
was not worth it. It would just add complexity and make maintenance more
difficult while adding a feature of dubious value.

On a related topic does anybody have an opinion on if it would be a good
idea to keep small blobs in the table itself while storing larger BLOBs
somewhere else. This would mean the column would have a mixture of BLOB URLS
and BLOBS. This is allowed in MySQL with the PBMS engine now. When the BLOB
column is accessed using the PBMS API it can handle this transparently for
the user. The definition of what a small blob is would be a plugin
parameter.

Right now you can end up replacing a BLOB with a BLOB URL that is bigger
than the BLOB. 

Barry

In the case where the BLOB is actually smaller than he BLUB URL that would
replace it

> Cheers,
> -Brian
> 
> --
> _______________________________________________________
> Brian "Krow" Aker, brian at tangent.org
> Seattle, Washington
> http://krow.net/                     <-- Me
> http://tangent.org/                <-- Software
> _______________________________________________________
> You can't grep a dead tree.
> 
> 
> 

-------------------------------------------------------------------------
Barry Leslie

SNAP Innovation Softwareentwicklung GmbH
Senior Software Engineer

Tel: (001) 250 595 4228
Fax: (001) 250 595 4233
Email: [EMAIL PROTECTED]
Web: www.PrimeBase.com

SNAP Innovation Softwareentwicklung GmbH, D-22765 Hamburg,
Max-Brauer-Allee 50, Germany
Amtsgericht Hamburg HRB 61066, Geschäftsführer: Ulrich Zimmer, Paul
McCullagh
-------------------------------------------------------------------------




_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to