node-postgres
node-postgres copied to clipboard
Support sending ArrayBuffer values over the wire
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()