Re: obtain a BLOB size without fetching the whole thing?
Re: obtain a BLOB size without fetching the whole thing?
- Subject: Re: obtain a BLOB size without fetching the whole thing?
- From: Samuel Pelletier via Webobjects-dev <email@hidden>
- Date: Tue, 24 Jun 2025 19:40:59 -0400
Hi OC,
Without more details about your schema and needs, the only thing I see is maybe
a derived attribute on an entity may be a starting point.
Regards,
Samuel
> Le 24 juin 2025 à 17:33, ocs--- via Webobjects-dev
> <email@hidden> a écrit :
>
> Great, thanks! Works like a charm :)
>
> If there is a trick to do this at a higher EOF level, would be nice, but if
> there's none, this solves my problem all right. Thanks again!
>
> All the best,
> OC
>
>> On 24. 6. 2025, at 23:25, Amedeo Mantica <email@hidden> wrote:
>>
>> try something like this...
>> (raw SQL)
>>
>> SELECT id, OCTET_LENGTH(blob_col) AS blob_size_bytes FROM my_table;
>>
>>> Il giorno 24 giu 2025, alle ore 21:27, ocs--- via Webobjects-dev
>>> <email@hidden> ha scritto:
>>>
>>> Hi there,
>>>
>>> the subject says it all. I've got a FS which reads in some columns set up
>>> through setRawRowKeyPaths. The entity contains also a BLOB column which can
>>> be rather big. Is there a trick to get its size only in the result
>>> dictionaries, without actually fetching the data?
>>>
>>> If db-specific, with FrontBase.
>>>
>>> Thanks a lot!
>>> OC
>>> _______________________________________________
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list (email@hidden)
>>> Help/Unsubscribe/Update your Subscription:
>>>
>>> This email sent to email@hidden
>>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden