On 27-6-2019 18:31, Leyne, Sean wrote:
RDB$BLOB_UTIL will have procedures and functions so blobs could be created,
opened, read in chunks, written in chunks, discarded (cancel).
What about functions:
- to read from/write to local disk*
That would require tight access controls, because just giving access to
disk is a security risk. Without proper access control, it would mean
that anyone that can execute an execute block would be able to access
your disk. Even directory restrictions similar to those for external
table file locations would be too broad, as you would run the risk of
exposing too much of your data to unauthorized users.
- to read from/write to any external source (Thinking of S3 compatible storage)*
You could implement that using UDRs.
Sean
P.S. These are use cases where UDF-like functionality is required -- how else
would someone provide this functionality? (I don't see UDRs supporting this)
If you think a UDF can do it, why do you think a UDR wouldn't be able to
do it? UDRs can do more than UDFs.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel