firebird BLOB type is not preserved by replication

Stream BLOBs become segmented in target database.

Mar 14 '24 16:03 aafemt

I suppose it could be easily done by a separate tag e.g. opStoreBlob2. But given that we already had a suggestion to drop segmented blobs at all (in favor of stream blobs), maybe it should be considered instead?

Mar 17 '24 07:03 dyemanov

opStreamedBlob would sound better for me (no impression that it supersede opStoreBlob at least).

Segmented BLOBs has its own usage. I'll vote against their dropping.

Mar 17 '24 10:03 aafemt

I would not vote for the abolition of segmented BLOBs, but rather for changes to the type of default BLOBs. By default, BLOBs are streaming, but if you really want to, then we make them segmented. Segmented BLOBs have only one use - to store lists of objects of the same size. In other cases, they have no advantages over streaming ones.

Mar 18 '24 10:03 sim1984

Size of objects may vary but yes, preserving boundaries between them is a useful feature. The same way in network world stream-oriented TCP is mostly used but message-oriented UDP still keep a niche.

Mar 18 '24 10:03 aafemt