Re: Use bytearray for blobs or not?

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