Re: Use bytearray for blobs or not? - Mailing list pgsql-general

From Thomas Güttler
Subject Re: Use bytearray for blobs or not?
Date
Msg-id 01e65f2d-a6cc-871a-e3b8-7f6a70118e59@thomas-guettler.de
Whole thread Raw
In response to Re: Use bytearray for blobs or not?  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-general

Am 04.01.19 um 12:48 schrieb Achilleas Mantzios:
> On 4/1/19 1:41 μ.μ., Thomas Güttler wrote:
>> Some months ago I wrote a little application with Python+Django which stores
>> blob data in bytearrays.
>>
>> It works.
>>
>> In the future there will be a lot more traffic, and I am unsure
>> if this is really a good solution. I know this is more FUD than
>> concrete PG issue.
>>
>> What do you think?
> 
> Performance (at least for JDBC) is known to be better with blobs.
> However, with bytea life is just easier for many reasons (backups, logical replication, other types of replication,
sys
 
> management, etc).


I could switch to a s3 like storage server, too. Up to now, this would only be
some lines of code. I could store the s3 IDs in postgres.




-- 
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines


pgsql-general by date:

Previous
From: Kristjan Tammekivi
Date:
Subject: Re: Potentially undocumented behaviour change in Postgres 11concerning OLD record in an after insert trigger
Next
From: Adrian Klaver
Date:
Subject: Re: Potentially undocumented behaviour change in Postgres 11concerning OLD record in an after insert trigger