public inbox for [email protected]  

help / color / mirror / Atom feed

From: Pravesh Sharma <[email protected]>
To: pgadmin-hackers <[email protected]>
Subject: Re: Require suggestions on feature 4011
Date: Thu, 14 Aug 2025 14:35:10 +0530
Message-ID: <CA+36bxE5YHZgyb5Ps0AzFsDR4GAPV_z3SQuAk_DBEc6N=X4Z3w@mail.gmail.com> (raw)
In-Reply-To: <CA+36bxHzcbXQ8uYn+KriUrZoNJeuQR2cLUtAWG_=9wdnfwAVTw@mail.gmail.com>
References: <CA+36bxHzcbXQ8uYn+KriUrZoNJeuQR2cLUtAWG_=9wdnfwAVTw@mail.gmail.com>

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
>

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]
  Subject: Re: Require suggestions on feature 4011
  In-Reply-To: <CA+36bxE5YHZgyb5Ps0AzFsDR4GAPV_z3SQuAk_DBEc6N=X4Z3w@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