anyone have knowledge storing byte arrays into PSQL? I have a bytea column I'm trying to store a nippy/freeze'd (serialized compressed byte-array) value in. If I (spit "out" (String. (nippy/freeze object))) its 11 bytes, if I INSERT (nippy/freeze object) its around 1200 bytes

same results if I create a prepared-statement and call .setBytes on it

which is the JDBC preferred way to do it: https://jdbc.postgresql.org/documentation/head/binary-data.html#binary-data-example

looks like Im stuck

@owen I'm using HugSQL and I just store a byte-array directly to it

@danielcompton oh I was able to store it successfully, just confused if the inflation in byte size is preventable

or is just PSQL overhead for byte array storage

from the PSQL docs: > bytea 1 or 4 bytes plus the actual binary string variable-length binary string

I would expect an 11 byte bytea to be a max or 15 bytes

but I also stored a 99KB image in a bytea field using the PSQL recommended practices in here: https://jdbc.postgresql.org/documentation/head/binary-data.html#binary-data-example and stilll saw an 11-12KB increase

so I'm guessing its just bytea overhead

thank you though!

How are you measuring the size?