public inbox for [email protected]  

help / color / mirror / Atom feed
From: Aditya Toshniwal <[email protected]>
To: Pravesh Sharma <[email protected]>
Cc: pgadmin-hackers <[email protected]>
Subject: Re: Require suggestions on feature 4011
Date: Thu, 14 Aug 2025 15:06:20 +0530
Message-ID: <CAM9w-_=AN-av6P5NE_64x3fZs2fq-T4biF5kH_Ec8MUgLQLLLw@mail.gmail.com> (raw)
In-Reply-To: <CA+36bxE5YHZgyb5Ps0AzFsDR4GAPV_z3SQuAk_DBEc6N=X4Z3w@mail.gmail.com>
References: <CA+36bxHzcbXQ8uYn+KriUrZoNJeuQR2cLUtAWG_=9wdnfwAVTw@mail.gmail.com>
	<CA+36bxE5YHZgyb5Ps0AzFsDR4GAPV_z3SQuAk_DBEc6N=X4Z3w@mail.gmail.com>

Hi Pravesh,

I think we'll have to load the binary data in the backend at least like you
mentioned. It will increase memory consumption, so we'll have to make this
feature preference based with clear mention of the memory requirements in
the help string and by default disabled.

On Thu, Aug 14, 2025 at 2:35 PM Pravesh Sharma <
[email protected]> wrote:

> Hi Hackers,
>
> Any suggestions on the above issue.
>
> Thanks,
> Pravesh
>
> On Fri, Aug 8, 2025 at 3:41 PM Pravesh Sharma <
> [email protected]> wrote:
>
>> Hi Hackers,
>>
>> I'm working on feature #4011
>> <https://github.com/pgadmin-org/pgadmin4/issues/4011;, which involves
>> exporting and importing BLOB (bytea) data. I've checked its feasibility and
>> these are the challenges I'm facing:
>>
>> Currently, we simply return the string "binary data" for bytea columns,
>> and we don't load the actual binary data at all. If we want to download
>> this data, we can bring it to the cursor, but when returning it to the
>> front end, we'll still send the string "binary data" Upon a user's
>> request to download, we'll fetch it from the cursor and return it.
>>
>> The main challenge I'm facing is how we'll identify the row from which
>> the download needs to happen if there's no primary key in the table.
>> Additionally, keeping binary data in memory could cause performance issues.
>> For this reason, we can make it a preference-based option.
>>
>>
>> Please let me know your thoughts/suggestions.
>>
>>
>> Thanks,
>>
>> Pravesh
>>
>> --
>>
>>
>> Pravesh Sharma
>>
>> Senior SDE
>>
>> +91 9406461406
>>
>>
>> enterprisedb.com
>>
>

-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*
<https://www.enterprisedb.com/;
"Don't Complain about Heat, Plant a TREE"


reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Require suggestions on feature 4011
  In-Reply-To: <CAM9w-_=AN-av6P5NE_64x3fZs2fq-T4biF5kH_Ec8MUgLQLLLw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox