node-postgres icon indicating copy to clipboard operation
node-postgres copied to clipboard

Support sending ArrayBuffer values over the wire

Open s-devaney opened this issue 1 year ago • 3 comments

PG supports sending ArrayBuffer views (e.g. TypedArray instances like Uint8Array) over the wire as values in queries, but it cannot send the underlying ArrayBuffer as a value.

Use case: I have one ArrayBuffer which represents packed binary data, it containing multiple TypedArray views e.g. one UInt8Array for meta data and one Float32Array containing a payload.

I want to insert this entire ArrayBuffer into a Postgres BYTEA column.

But, currently, the PG prepareValue util function does not support preparing ArrayBuffer values.

Preparing an ArrayBuffer is a simple change, it can just be converted to a Buffer by simply passing it to Buffer.from()

s-devaney avatar Sep 30 '24 14:09 s-devaney